Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Who agreed with this topic

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

New Contributor

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