Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

SQoop job is hangs importing data from Teradata to Hive table while loading uploaded data to hive

New Contributor

I am trying to runSqoop job to import the data from Teradata to hive table. The query hangs at

18/06/13 16:24:39 INFO hive.HiveImport: Loading uploaded data into Hive 18/06/13 16:24:39 DEBUG hive.HiveImport: Using in-process Hive instance. 18/06/13 16:24:39 DEBUG util.SubprocessSecurityManager: Installing subprocess security manager

Logging initialized using configuration in jar:file:/usr/hdp/2.5.3.0-37/hive/lib/hive-common-1.2.1000.2.5.3.0-37.jar!/hive-log4j.properties

Note: The same Job was completed in 2 seconds and now it is taking more than 40 minutes.(Load on cluster at both cases is same)

1 REPLY 1

Hey @Gangi Yadiki!
Are you using hive.support.concurrency=true? If so, try to run the following command:

show locks <TABLE>;
unlock table <TABLE>;

Hope this helps

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.