Reply
Highlighted
New Contributor
Posts: 7
Registered: ‎08-05-2014

sqoop import into hive issue

Hi ,

     I am using sqoop Sqoop version: 1.4.3-cdh4.7.0. While trying to import all tables into HIVE from MYSQL database, it is stopping with import of first table in the database alone and then the process is not getting killed. I tried using import option to import a single table into HIVE  from MYSQL. Even here I face the same issue wherein after the table import is over, the sqoop process is not coming out. Kindly help me with this . I have pasted last few lines of my log below:

 

14/09/01 17:39:15 INFO hive.HiveImport: Removing temporary files from import process: hdfs://myhostdeva:8020/user/deva/BRAND_DIM/_logs
14/09/01 17:39:16 INFO hive.HiveImport: Loading uploaded data into Hive
14/09/01 17:39:18 INFO hive.HiveImport: Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
14/09/01 17:39:18 INFO hive.HiveImport: Hive history file=/tmp/deva/hive_job_log_e3ed37f4-1f69-46d6-aeb8-ac0fa8776cad_536488293.txt
14/09/01 17:39:18 INFO hive.HiveImport: SLF4J: Class path contains multiple SLF4J bindings.
14/09/01 17:39:18 INFO hive.HiveImport: SLF4J: Found binding in [jar:file:/usr/lib/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
14/09/01 17:39:18 INFO hive.HiveImport: SLF4J: Found binding in [jar:file:/usr/lib/hive/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
14/09/01 17:39:18 INFO hive.HiveImport: SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
14/09/01 17:39:21 INFO hive.HiveImport: OK
14/09/01 17:39:21 INFO hive.HiveImport: Time taken: 2.655 seconds

 

 

 

"After this the sqoop process is not coming out of the terminal. It is getting stopped.When I do as ps -ef | grep sqoop  to look at the process running, I see sqoop hive import of imported table still running"

 

 

Thanks in Advance.

 

Regards,

Deva

Announcements
New solutions