Sqoop does not support creating Hive external tables. Instead you might:
Step 1: import data from mysql to hive table.
Step 2: In hive change the table type from Managed to External.
refer SQOOP-816
Step 1: import data from mysql to hive table.
sqoop import --connect jdbc:mysql://localhost/ --username training --password training --table --hive-import --hive-table -m 1 --fields-terminated-by ','
Step 2: In hive change the table type from Managed to External.
Alter table <Table-name> SET TBLPROPERTIES('EXTERNAL'='TRUE')
refer SQOOP-816
Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking.Big Data Hadoop Online Training India
ReplyDelete