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.
05-25-2018 04:53 AM
Hi,
You just imported test table from postgresql to hdfs.
now next you open hive prompt and load this table into hive.
# hive
hive> load data inpath '/user/hive/warehouse/test' into table test;
hive> show tables;
05-25-2018 11:17 PM
what user are you firing the sqoop ?
try using the below parameter
the ouput of the mapreduce should give you some information byte written .
--target-dir or --warehouse-dir