28730
DISCUSSIONS
101731
MEMBERS
3157
ARTICLES
Created on 06-30-2016 07:59 PM - edited 06-30-2016 08:18 PM
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.