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.

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

[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.

 

 

 

2 REPLIES 2

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

New Contributor

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;

Highlighted

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

Champion

 

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