Sqoop : Hive

Scoop CLI automatically creates Hive MetaData

Note

• Sqoop requires hive meta table to be configured. ( /user/hive/warehouse/emp_table )
• automatically executes a CREATE TABLE command in Hive.
• automatically executes a LOAD DATA INPATH command in hive to move data into hive.

Also

• To import into hive using sqoop , in end just add --hive-import option
• can also specify --hive-overrite to replace existing hive table.
• if you want to keep hive table name different from source table name , use --hive-table option.
• For all hive related commands , sqoop will execute a local hive client from the  machine where sqoop is running , use --hive-home to specify the hive binary.