Loading Profile...
Sqood cannot import data
I download hadoop-0.20+133, but the company cluster using Hadoop 0.19.2-dev, can I run Sqoop on my client?
I can list table now, but I got errors when I import the data.
09/11/04 15:23:18 INFO sqoop.Sqoop: Beginning code generation
09/11/04 15:23:18 INFO manager.MySQLManager: Executing SQL statement: SELECT t.* FROM chijiongtest AS t LIMIT 1
09/11/04 15:23:18 INFO manager.MySQLManager: Executing SQL statement: SELECT t.* FROM chijiongtest AS t LIMIT 1
09/11/04 15:23:18 INFO orm.CompilationManager: HADOOP_HOME is /home/chijiong/hadoop-0.20
09/11/04 15:23:18 INFO orm.CompilationManager: Found hadoop core jar at: /home/chijiong/hadoop-0.20/hadoop-0.20.1+133-core.jar
09/11/04 15:23:19 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop/compile/chijiongtest.jar
09/11/04 15:23:19 INFO mapreduce.DataDrivenImportJob: Beginning data-driven import of chijiongtest
09/11/04 15:23:19 INFO util.ClassLoaderStack: Loaded jar into current JVM: jar:file:///tmp/sqoop/compile/chijiongtest.jar!/
09/11/04 15:23:19 INFO util.ClassLoaderStack: Added classloader for jar /tmp/sqoop/compile/chijiongtest.jar: java.net.FactoryURLClassLoader@42ef83d3
09/11/04 15:23:19 INFO util.ClassLoaderStack: Restoring classloader: java.net.URLClassLoader@690da5eb
09/11/04 15:23:19 ERROR sqoop.Sqoop: Encountered IOException running import job: java.io.IOException: Call to /172.23.114.211:9000 failed on local exception: java.io.EOFException
I can list table now, but I got errors when I import the data.
09/11/04 15:23:18 INFO sqoop.Sqoop: Beginning code generation
09/11/04 15:23:18 INFO manager.MySQLManager: Executing SQL statement: SELECT t.* FROM chijiongtest AS t LIMIT 1
09/11/04 15:23:18 INFO manager.MySQLManager: Executing SQL statement: SELECT t.* FROM chijiongtest AS t LIMIT 1
09/11/04 15:23:18 INFO orm.CompilationManager: HADOOP_HOME is /home/chijiong/hadoop-0.20
09/11/04 15:23:18 INFO orm.CompilationManager: Found hadoop core jar at: /home/chijiong/hadoop-0.20/hadoop-0.20.1+133-core.jar
09/11/04 15:23:19 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop/compile/chijiongtest.jar
09/11/04 15:23:19 INFO mapreduce.DataDrivenImportJob: Beginning data-driven import of chijiongtest
09/11/04 15:23:19 INFO util.ClassLoaderStack: Loaded jar into current JVM: jar:file:///tmp/sqoop/compile/chijiongtest.jar!/
09/11/04 15:23:19 INFO util.ClassLoaderStack: Added classloader for jar /tmp/sqoop/compile/chijiongtest.jar: java.net.FactoryURLClassLoader@42ef83d3
09/11/04 15:23:19 INFO util.ClassLoaderStack: Restoring classloader: java.net.URLClassLoader@690da5eb
09/11/04 15:23:19 ERROR sqoop.Sqoop: Encountered IOException running import job: java.io.IOException: Call to /172.23.114.211:9000 failed on local exception: java.io.EOFException
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?My command line:
sqoop --connect jdbc:mysql://172.23.52.50:3307/metastore_db --username hive -P --table chijiongtest -
Inappropriate?Hi Azuryy, the version of Sqoop that comes with CDH hadoop-0.20 will only work with Hadoop 0.20 or newer.
If you download the older CDH (hadoop-0.18) this also contains a Sqoop client (albeit one with less functionality and lower performance) which should work with Hadoop 18 and 19. -
Inappropriate?That's very good, Thanks a lot, Aaron!
EMPLOYEE
