Hi, Full Hive documentation regarding table creation can be found here: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL I think that should be enough for you to start with. ... View more

Everybody thank you! >< I get it by command  oozie job -oozie http://oozieHost:11000/oozie -config ~/.job.properties -run ... View more

Sqoop eval and Sqoop list tables requires only the Name node connection with the SQL server. But for SQOOP import, all the nodes in the cluster needs to have access to the remote SQL server. Here the Telnet failed from datanodes. It was due the network settings and firewalls configuration. Later when every node was able to access the Remote SQL server the SQOOP IMPORT was successful. ... View more

Impala won't be able to create gzip compression format for text file. Please refer to below documentation: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_file_formats.html It mentioned below: For text format, if LZO compression is used, you must create the table and load data in Hive. If other kinds of compression are used, you must load data through LOAD DATA, Hive, or manually in HDFS. So the short answer is that you can't do it in Impala. ... View more

A hive table consists the following: 1. metadata info (all table and column definitions and HDFS location) 2. actual HDFS data stored in HDFS If you delete a managed table, both 1 and 2 will be deleted. However, if you delete an external table, then only 1 will be deleted, meaning, the table reference will be removed in Hive's backend database (show tables will not return the table and you can't query the table any more). The underlining HDFS file will remain on HDFS path untouched. To confirm this, you can check where the backend database is stored. If it is mysql, simply login and check the table under TBLS and check if you can query the table (mysql table, not hive table): SELECT * FROM TBLS WHERE TBL_NAME = "{your_table_name}"; Hope above helps. ... View more