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.

sqoop import into hive issue

sqoop import into hive issue

New Contributor

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