HCatalog Creating Table


Creating Table in HCatalog

This post describes, how to create a table.

Step 1 - Open a new termAAinal (CTRL + ALT + T) and Change the directory to /usr/local/hive/hcatalog/bin




$ cd $HCAT_HOME/bin

Step 2 - Creating a new employee table




$ ./hcat -e "CREATE TABLE IF NOT EXISTS employee( eid int, name String, salary String, destination String) \
COMMENT 'Employee details' \
ROW FORMAT DEIMITED \
FIELDS TERMINATED BY ' ' \
LINES TERMINATED BY '\n' \
STORED AS TEXTFILE;"


Step 3 - Check whether it is created or not. It shows all the tables that are present.




$ ./hcat -e "show tables;"

Have any Question or Comment?

Leave a Reply

Your email address will not be published. Required fields are marked *