Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

[HELP!!!] Sqoop import table to hive, not shown on hive (CM 5.7.x)

avatar
Explorer

Use the Command below to import data from postgresql to hive

$ sqoop import --connect jdbc:postgresql://my host/cqdb --username test --table test --split-by value --hive-import ----direct

 

There is corresponding file under hdfs

$ hadoop fs -ls /user/hive/warehouse

 

drwxrwxrwt - root hive 0 2016-06-30 19:06 /user/hive/warehouse/test

 

 

The file could not be shown on hive

$ hive
hive> show tables;
OK
Time taken: 1.731 seconds

 

Any body could help appreciate.

 

 

 

Who agreed with this topic