Support Questions
Find answers, ask questions, and share your expertise
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;
Time taken: 1.731 seconds


Any body could help appreciate.




Who agreed with this topic