Sqoop_Hive Issue

85 views
Skip to first unread message

shob...@gmail.com

unread,
May 11, 2016, 11:11:44 AM5/11/16
to Hadoop Users Group (HUG) Chennai

I have uploaded 30L records in mysql , currently am trying to load the same data in HDFS through Sqoop-Hive Integration. by using below query

bin/sqoop-import --connect jdbc:mysql://localhost/
training -username root -password root --table retailpoc --target-dir /sqoophive --hive-import --create-hive-table --hive-table retailpoc2 -m 1

Job Ran successfully

Hive table retailpoc2 is avl in /user/hive/warehouse.  But if i try to execute Select query in Hive Shell, Am not able to see the retailpoc2  table in hive shell

Pls let me know, what might be the reason
Hive_Sqoop .odt
Reply all
Reply to author
Forward
0 new messages