Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop hangs when import from Teradata


Copy link to this message
-
Sqoop hangs when import from Teradata
I have trouble import Teradata table into HDFS:

   1. Installed CDH using cloudera manager on CentOS 6.
   2. Installed Sqoop-Teradata-Connector 1.2.5c5 using parcel.
   3. Install Sqoop Client service, and deploy the configuration file.
   4. Downloaded teradata jdbc driver v15.0.0.15 and v13.10.00.36, and
   extracted the jars in ~/apps/terajdbc.
   5. export
   HADOOP_CLASSPATH=~/apps/terajdbc/terajdbc4.jar:~/apps/terajdbc/tdgssconfig.jar
   6. sqoop import --connect jdbc:teradata://teraserver/DATABASE=MYDB
   --username bewang -P --table action --num-mappers 1, then it just hangs
   after creating jar. The table 'action' is pretty small, only 161 rows.

14/06/17 18:05:08 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-cloudera/compile/6c32f78ff095211b76e44a53cb3cdaef/action.jar
14/06/17 18:05:08 DEBUG orm.CompilationManager: Scanning for .class files
in directory: /tmp/sqoop-cloudera/compile/6c32f78ff095211b76e44a53cb3cdaef
14/06/17 18:05:08 DEBUG orm.CompilationManager: Got classfile:
/tmp/sqoop-cloudera/compile/6c32f78ff095211b76e44a53cb3cdaef/action.class
-> action.class
14/06/17 18:05:08 DEBUG orm.CompilationManager: Finished writing jar file
/tmp/sqoop-cloudera/compile/6c32f78ff095211b76e44a53cb3cdaef/action.jar
14/06/17 18:05:08 INFO teradata.TeradataManager: Beginning Teradata table
based import

   1. I could successfully run "sqoop eval" to dump the table without
   problem.

What's wrong with my method?

 
+
Benyi Wang 2014-06-18, 20:57
+
Abraham Elmahrek 2014-06-18, 21:02
+
Benyi Wang 2014-06-18, 21:49
+
Abraham Elmahrek 2014-06-18, 21:54