본문 바로가기

Hadoop Ecosystem

sqoop import failure


sqoop import failure


[hadoop@h001 sqoop]$ ./bin/sqoop import --verbose --connect jdbc:mysql://192.168.73.11/hadoopdb --table sqt002 --fields-terminated-by ',' --username hadoop --password 1 --hive-import --hive-home /user/hive/warehouse/  -m 1 



in progress : ? > --outdir   /user/hive/warehouse/etl   --hive-import   --hive-table  hiveimporttest

--target-dir   --where

use help


Warning: $HADOOP_HOME is deprecated.

13/07/01 16:29:16 DEBUG tool.BaseSqoopTool: Enabled debug logging.
13/07/01 16:29:16 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
13/07/01 16:29:16 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
13/07/01 16:29:16 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory
13/07/01 16:29:16 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:mysql:
13/07/01 16:29:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
13/07/01 16:29:16 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.MySQLManager@1777f5b2
13/07/01 16:29:16 INFO tool.CodeGenTool: Beginning code generation
13/07/01 16:29:16 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
13/07/01 16:29:18 DEBUG manager.SqlManager: Using fetchSize for next query: -2147483648
13/07/01 16:29:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `sqt002` AS t LIMIT 1
13/07/01 16:29:18 DEBUG orm.ClassWriter: selected columns:
13/07/01 16:29:18 DEBUG orm.ClassWriter:   id
13/07/01 16:29:18 DEBUG orm.ClassWriter:   name
13/07/01 16:29:18 DEBUG orm.ClassWriter:   phone
13/07/01 16:29:18 DEBUG manager.SqlManager: Using fetchSize for next query: -2147483648
13/07/01 16:29:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `sqt002` AS t LIMIT 1
13/07/01 16:29:18 DEBUG orm.ClassWriter: Writing source file: /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/sqt002.java
13/07/01 16:29:18 DEBUG orm.ClassWriter: Table name: sqt002
13/07/01 16:29:18 DEBUG orm.ClassWriter: Columns: id:12, name:12, phone:12,
13/07/01 16:29:18 DEBUG orm.ClassWriter: sourceFilename is sqt002.java
13/07/01 16:29:18 DEBUG orm.CompilationManager: Found existing /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/
13/07/01 16:29:18 INFO orm.CompilationManager: HADOOP_HOME is /home/hadoop/hadoop/libexec/..
13/07/01 16:29:18 DEBUG orm.CompilationManager: Adding source file: /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/sqt002.java
13/07/01 16:29:18 DEBUG orm.CompilationManager: Invoking javac with args:
13/07/01 16:29:18 DEBUG orm.CompilationManager:   -sourcepath
13/07/01 16:29:18 DEBUG orm.CompilationManager:   /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/
13/07/01 16:29:18 DEBUG orm.CompilationManager:   -d
13/07/01 16:29:18 DEBUG orm.CompilationManager:   /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/
13/07/01 16:29:18 DEBUG orm.CompilationManager:   -classpath
13/07/01 16:29:18 DEBUG orm.CompilationManager:   /home/hadoop/hadoop/libexec/../conf:/usr/local/java/lib/tools.jar:/home/hadoop/hadoop/libexec/..:/home/hadoop/hadoop/libexec/../hadoop-core-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/asm-3.2.jar:/home/hadoop/hadoop/libexec/../lib/aspectjrt-1.6.5.jar:/home/hadoop/hadoop/libexec/../lib/aspectjtools-1.6.5.jar:/home/hadoop/hadoop/libexec/../lib/commons-beanutils-1.7.0.jar:/home/hadoop/hadoop/libexec/../lib/commons-beanutils-core-1.8.0.jar:/home/hadoop/hadoop/libexec/../lib/commons-cli-1.2.jar:/home/hadoop/hadoop/libexec/../lib/commons-codec-1.4.jar:/home/hadoop/hadoop/libexec/../lib/commons-collections-3.2.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-configuration-1.6.jar:/home/hadoop/hadoop/libexec/../lib/commons-daemon-1.0.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-digester-1.8.jar:/home/hadoop/hadoop/libexec/../lib/commons-el-1.0.jar:/home/hadoop/hadoop/libexec/../lib/commons-httpclient-3.0.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-io-2.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-lang-2.4.jar:/home/hadoop/hadoop/libexec/../lib/commons-logging-1.1.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-logging-api-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/commons-math-2.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-net-1.4.1.jar:/home/hadoop/hadoop/libexec/../lib/core-3.1.1.jar:/home/hadoop/hadoop/libexec/../lib/hadoop-capacity-scheduler-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/hadoop-fairscheduler-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/hadoop-thriftfs-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/hsqldb-1.8.0.10.jar:/home/hadoop/hadoop/libexec/../lib/jackson-core-asl-1.8.8.jar:/home/hadoop/hadoop/libexec/../lib/jackson-mapper-asl-1.8.8.jar:/home/hadoop/hadoop/libexec/../lib/jasper-compiler-5.5.12.jar:/home/hadoop/hadoop/libexec/../lib/jasper-runtime-5.5.12.jar:/home/hadoop/hadoop/libexec/../lib/jdeb-0.8.jar:/home/hadoop/hadoop/libexec/../lib/jersey-core-1.8.jar:/home/hadoop/hadoop/libexec/../lib/jersey-json-1.8.jar:/home/hadoop/hadoop/libexec/../lib/jersey-server-1.8.jar:/home/hadoop/hadoop/libexec/../lib/jets3t-0.6.1.jar:/home/hadoop/hadoop/libexec/../lib/jetty-6.1.26.jar:/home/hadoop/hadoop/libexec/../lib/jetty-util-6.1.26.jar:/home/hadoop/hadoop/libexec/../lib/jsch-0.1.42.jar:/home/hadoop/hadoop/libexec/../lib/junit-4.5.jar:/home/hadoop/hadoop/libexec/../lib/kfs-0.2.2.jar:/home/hadoop/hadoop/libexec/../lib/log4j-1.2.15.jar:/home/hadoop/hadoop/libexec/../lib/mockito-all-1.8.5.jar:/home/hadoop/hadoop/libexec/../lib/oro-2.0.8.jar:/home/hadoop/hadoop/libexec/../lib/servlet-api-2.5-20081211.jar:/home/hadoop/hadoop/libexec/../lib/slf4j-api-1.4.3.jar:/home/hadoop/hadoop/libexec/../lib/slf4j-log4j12-1.4.3.jar:/home/hadoop/hadoop/libexec/../lib/xmlenc-0.52.jar:/home/hadoop/hadoop/libexec/../lib/jsp-2.1/jsp-2.1.jar:/home/hadoop/hadoop/libexec/../lib/jsp-2.1/jsp-api-2.1.jar:/home/hadoop/sqoop/conf::/home/hadoop/sqoop/lib/ant-contrib-1.0b3.jar:/home/hadoop/sqoop/lib/ant-eclipse-1.0-jvm1.2.jar:/home/hadoop/sqoop/lib/avro-1.5.3.jar:/home/hadoop/sqoop/lib/avro-ipc-1.5.3.jar:/home/hadoop/sqoop/lib/avro-mapred-1.5.3.jar:/home/hadoop/sqoop/lib/commons-io-1.4.jar:/home/hadoop/sqoop/lib/hsqldb-1.8.0.10.jar:/home/hadoop/sqoop/lib/jackson-core-asl-1.7.3.jar:/home/hadoop/sqoop/lib/jackson-mapper-asl-1.7.3.jar:/home/hadoop/sqoop/lib/jopt-simple-3.2.jar:/home/hadoop/sqoop/lib/mysql-connector-java-5.1.25-bin.jar:/home/hadoop/sqoop/lib/paranamer-2.3.jar:/home/hadoop/sqoop/lib/snappy-java-1.0.3.2.jar:/home/hadoop/hbase/conf:/usr/local/java/lib/tools.jar:/home/hadoop/hbase:/home/hadoop/hbase/hbase-0.94.7.jar:/home/hadoop/hbase/hbase-0.94.7-tests.jar:/home/hadoop/hbase/lib/activation-1.1.jar:/home/hadoop/hbase/lib/asm-3.1.jar:/home/hadoop/hbase/lib/avro-1.5.3.jar:/home/hadoop/hbase/lib/avro-ipc-1.5.3.jar:/home/hadoop/hbase/lib/commons-beanutils-1.7.0.jar:/home/hadoop/hbase/lib/commons-beanutils-core-1.8.0.jar:/home/hadoop/hbase/lib/commons-cli-1.2.jar:/home/hadoop/hbase/lib/commons-codec-1.4.jar:/home/hadoop/hbase/lib/commons-collections-3.2.1.jar:/home/hadoop/hbase/lib/commons-configuration-1.6.jar:/home/hadoop/hbase/lib/commons-digester-1.8.jar:/home/hadoop/hbase/lib/commons-el-1.0.jar:/home/hadoop/hbase/lib/commons-httpclient-3.1.jar:/home/hadoop/hbase/lib/commons-io-2.1.jar:/home/hadoop/hbase/lib/commons-lang-2.5.jar:/home/hadoop/hbase/lib/commons-logging-1.1.1.jar:/home/hadoop/hbase/lib/commons-math-2.1.jar:/home/hadoop/hbase/lib/commons-net-1.4.1.jar:/home/hadoop/hbase/lib/core-3.1.1.jar:/home/hadoop/hbase/lib/guava-11.0.2.jar:/home/hadoop/hbase/lib/hadoop-core-1.0.4.jar:/home/hadoop/hbase/lib/high-scale-lib-1.1.1.jar:/home/hadoop/hbase/lib/httpclient-4.1.2.jar:/home/hadoop/hbase/lib/httpcore-4.1.3.jar:/home/hadoop/hbase/lib/jackson-core-asl-1.8.8.jar:/home/hadoop/hbase/lib/jackson-jaxrs-1.8.8.jar:/home/hadoop/hbase/lib/jackson-mapper-asl-1.8.8.jar:/home/hadoop/hbase/lib/jackson-xc-1.8.8.jar:/home/hadoop/hbase/lib/jamon-runtime-2.3.1.jar:/home/hadoop/hbase/lib/jasper-compiler-5.5.23.jar:/home/hadoop/hbase/lib/jasper-runtime-5.5.23.jar:/home/hadoop/hbase/lib/jaxb-api-2.1.jar:/home/hadoop/hbase/lib/jaxb-impl-2.2.3-1.jar:/home/hadoop/hbase/lib/jersey-core-1.8.jar:/home/hadoop/hbase/lib/jersey-json-1.8.jar:/home/hadoop/hbase/lib/jersey-server-1.8.jar:/home/hadoop/hbase/lib/jettison-1.1.jar:/home/hadoop/hbase/lib/jetty-6.1.26.jar:/home/hadoop/hbase/lib/jetty-util-6.1.26.jar:/home/hadoop/hbase/lib/jruby-complete-1.6.5.jar:/home/hadoop/hbase/lib/jsp-2.1-6.1.14.jar:/home/hadoop/hbase/lib/jsp-api-2.1-6.1.14.jar:/home/hadoop/hbase/lib/jsr305-1.3.9.jar:/home/hadoop/hbase/lib/junit-4.10-HBASE-1.jar:/home/hadoop/hbase/lib/libthrift-0.8.0.jar:/home/hadoop/hbase/lib/log4j-1.2.16.jar:/home/hadoop/hbase/lib/metrics-core-2.1.2.jar:/home/hadoop/hbase/lib/netty-3.2.4.Final.jar:/home/hadoop/hbase/lib/protobuf-java-2.4.0a.jar:/home/hadoop/hbase/lib/servlet-api-2.5-6.1.14.jar:/home/hadoop/hbase/lib/slf4j-api-1.4.3.jar:/home/hadoop/hbase/lib/slf4j-log4j12-1.4.3.jar:/home/hadoop/hbase/lib/snappy-java-1.0.3.2.jar:/home/hadoop/hbase/lib/stax-api-1.0.1.jar:/home/hadoop/hbase/lib/velocity-1.7.jar:/home/hadoop/hbase/lib/xmlenc-0.52.jar:/home/hadoop/hbase/lib/zookeeper-3.4.5.jar:/home/hadoop/hbase/conf:/home/hadoop/hadoop/libexec/../conf:/usr/local/java/lib/tools.jar:/home/hadoop/hadoop/libexec/..:/home/hadoop/hadoop/libexec/../hadoop-core-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/asm-3.2.jar:/home/hadoop/hadoop/libexec/../lib/aspectjrt-1.6.5.jar:/home/hadoop/hadoop/libexec/../lib/aspectjtools-1.6.5.jar:/home/hadoop/hadoop/libexec/../lib/commons-beanutils-1.7.0.jar:/home/hadoop/hadoop/libexec/../lib/commons-beanutils-core-1.8.0.jar:/home/hadoop/hadoop/libexec/../lib/commons-cli-1.2.jar:/home/hadoop/hadoop/libexec/../lib/commons-codec-1.4.jar:/home/hadoop/hadoop/libexec/../lib/commons-collections-3.2.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-configuration-1.6.jar:/home/hadoop/hadoop/libexec/../lib/commons-daemon-1.0.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-digester-1.8.jar:/home/hadoop/hadoop/libexec/../lib/commons-el-1.0.jar:/home/hadoop/hadoop/libexec/../lib/commons-httpclient-3.0.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-io-2.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-lang-2.4.jar:/home/hadoop/hadoop/libexec/../lib/commons-logging-1.1.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-logging-api-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/commons-math-2.1.jar:/home/hadoop/hadoop/libexec/../lib/commons-net-1.4.1.jar:/home/hadoop/hadoop/libexec/../lib/core-3.1.1.jar:/home/hadoop/hadoop/libexec/../lib/hadoop-capacity-scheduler-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/hadoop-fairscheduler-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/hadoop-thriftfs-1.0.4.jar:/home/hadoop/hadoop/libexec/../lib/hsqldb-1.8.0.10.jar:/home/hadoop/hadoop/libexec/../lib/jackson-core-asl-1.8.8.jar:/home/hadoop/hadoop/libexec/../lib/jackson-mapper-asl-1.8.8.jar:/home/hadoop/hadoop/libexec/../lib/jasper-compiler-5.5.12.jar:/home/hadoop/hadoop/libexec/../lib/jasper-runtime-5.5.12.jar:/home/hadoop/hadoop/libexec/../lib/jdeb-0.8.jar:/home/hadoop/hadoop/libexec/../lib/jersey-core-1.8.jar:/home/hadoop/hadoop/libexec/../lib/jersey-json-1.8.jar:/home/hadoop/hadoop/libexec/../lib/jersey-server-1.8.jar:/home/hadoop/hadoop/libexec/../lib/jets3t-0.6.1.jar:/home/hadoop/hadoop/libexec/../lib/jetty-6.1.26.jar:/home/hadoop/hadoop/libexec/../lib/jetty-util-6.1.26.jar:/home/hadoop/hadoop/libexec/../lib/jsch-0.1.42.jar:/home/hadoop/hadoop/libexec/../lib/junit-4.5.jar:/home/hadoop/hadoop/libexec/../lib/kfs-0.2.2.jar:/home/hadoop/hadoop/libexec/../lib/log4j-1.2.15.jar:/home/hadoop/hadoop/libexec/../lib/mockito-all-1.8.5.jar:/home/hadoop/hadoop/libexec/../lib/oro-2.0.8.jar:/home/hadoop/hadoop/libexec/../lib/servlet-api-2.5-20081211.jar:/home/hadoop/hadoop/libexec/../lib/slf4j-api-1.4.3.jar:/home/hadoop/hadoop/libexec/../lib/slf4j-log4j12-1.4.3.jar:/home/hadoop/hadoop/libexec/../lib/xmlenc-0.52.jar:/home/hadoop/hadoop/libexec/../lib/jsp-2.1/jsp-2.1.jar:/home/hadoop/hadoop/libexec/../lib/jsp-2.1/jsp-api-2.1.jar:/home/hadoop/sqoop/sqoop-1.4.2.jar:/home/hadoop/sqoop/sqoop-test-1.4.2.jar::/home/hadoop/hadoop/hadoop-core-1.0.4.jar:/home/hadoop/sqoop/sqoop-1.4.2.jar
Note: /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/sqt002.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
13/07/01 16:29:26 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/sqt002.jar
13/07/01 16:29:26 DEBUG orm.CompilationManager: Scanning for .class files in directory: /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82
13/07/01 16:29:26 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/sqt002.class -> sqt002.class
13/07/01 16:29:26 DEBUG orm.CompilationManager: Finished writing jar file /tmp/sqoop-hadoop/compile/b8dfda49b298b92b0660b760559cca82/sqt002.jar
13/07/01 16:29:26 WARN manager.MySQLManager: It looks like you are importing from mysql.
13/07/01 16:29:26 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
13/07/01 16:29:26 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
13/07/01 16:29:26 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
13/07/01 16:29:26 DEBUG manager.MySQLManager: Rewriting connect string to jdbc:mysql://192.168.73.11/hadoopdb?zeroDateTimeBehavior=convertToNull
13/07/01 16:29:26 DEBUG manager.CatalogQueryManager: Retrieving primary key for table 'sqt002' with query SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = (SELECT SCHEMA()) AND TABLE_NAME = 'sqt002' AND COLUMN_KEY = 'PRI'
13/07/01 16:29:26 DEBUG manager.CatalogQueryManager: Retrieving primary key for table 'sqt002' with query SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = (SELECT SCHEMA()) AND TABLE_NAME = 'sqt002' AND COLUMN_KEY = 'PRI'
13/07/01 16:29:26 INFO mapreduce.ImportJobBase: Beginning import of sqt002
13/07/01 16:29:27 DEBUG mapreduce.DataDrivenImportJob: Using table class: sqt002
13/07/01 16:29:27 DEBUG mapreduce.DataDrivenImportJob: Using InputFormat: class com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/sqoop-1.4.2.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/mysql-connector-java-5.1.25-bin.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/sqoop-1.4.2.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/sqoop-1.4.2.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/hsqldb-1.8.0.10.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/jackson-core-asl-1.7.3.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/jackson-mapper-asl-1.7.3.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/commons-io-1.4.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/paranamer-2.3.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/jopt-simple-3.2.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/ant-contrib-1.0b3.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/snappy-java-1.0.3.2.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/avro-ipc-1.5.3.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/avro-mapred-1.5.3.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/mysql-connector-java-5.1.25-bin.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/avro-1.5.3.jar
13/07/01 16:29:27 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/ant-eclipse-1.0-jvm1.2.jar
13/07/01 16:29:35 INFO mapred.JobClient: Running job: job_201306281952_0028
13/07/01 16:29:36 INFO mapred.JobClient:  map 0% reduce 0%
13/07/01 16:30:25 INFO mapred.JobClient:  map 100% reduce 0%
13/07/01 16:30:39 INFO mapred.JobClient: Job complete: job_201306281952_0028
13/07/01 16:30:39 INFO mapred.JobClient: Counters: 18
13/07/01 16:30:39 INFO mapred.JobClient:   Job Counters
13/07/01 16:30:39 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=47601
13/07/01 16:30:39 INFO mapred.JobClient:     Total time spent by all reduces waiting after reserving slots (ms)=0
13/07/01 16:30:39 INFO mapred.JobClient:     Total time spent by all maps waiting after reserving slots (ms)=0
13/07/01 16:30:39 INFO mapred.JobClient:     Launched map tasks=1
13/07/01 16:30:39 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
13/07/01 16:30:39 INFO mapred.JobClient:   File Output Format Counters
13/07/01 16:30:39 INFO mapred.JobClient:     Bytes Written=108
13/07/01 16:30:39 INFO mapred.JobClient:   FileSystemCounters
13/07/01 16:30:39 INFO mapred.JobClient:     HDFS_BYTES_READ=87
13/07/01 16:30:39 INFO mapred.JobClient:     FILE_BYTES_WRITTEN=30753
13/07/01 16:30:39 INFO mapred.JobClient:     HDFS_BYTES_WRITTEN=108
13/07/01 16:30:39 INFO mapred.JobClient:   File Input Format Counters
13/07/01 16:30:39 INFO mapred.JobClient:     Bytes Read=0
13/07/01 16:30:39 INFO mapred.JobClient:   Map-Reduce Framework
13/07/01 16:30:39 INFO mapred.JobClient:     Map input records=4
13/07/01 16:30:39 INFO mapred.JobClient:     Physical memory (bytes) snapshot=76013568
13/07/01 16:30:39 INFO mapred.JobClient:     Spilled Records=0
13/07/01 16:30:39 INFO mapred.JobClient:     CPU time spent (ms)=5510
13/07/01 16:30:39 INFO mapred.JobClient:     Total committed heap usage (bytes)=18481152
13/07/01 16:30:39 INFO mapred.JobClient:     Virtual memory (bytes) snapshot=721170432
13/07/01 16:30:39 INFO mapred.JobClient:     Map output records=4
13/07/01 16:30:39 INFO mapred.JobClient:     SPLIT_RAW_BYTES=87
13/07/01 16:30:39 INFO mapreduce.ImportJobBase: Transferred 108 bytes in 72.0333 seconds (1.4993 bytes/sec)
13/07/01 16:30:39 INFO mapreduce.ImportJobBase: Retrieved 4 records.
13/07/01 16:30:39 DEBUG hive.HiveImport: Hive.inputTable: sqt002
13/07/01 16:30:39 DEBUG hive.HiveImport: Hive.outputTable: sqt002
13/07/01 16:30:39 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
13/07/01 16:30:39 DEBUG manager.SqlManager: Using fetchSize for next query: -2147483648
13/07/01 16:30:39 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `sqt002` AS t LIMIT 1
13/07/01 16:30:39 DEBUG hive.TableDefWriter: Create statement: CREATE TABLE IF NOT EXISTS `sqt002` ( `id` STRING, `name` STRING, `phone` STRING) COMMENT 'Imported by sqoop on 2013/07/01 16:30:39' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054' LINES TERMINATED BY '\012' STORED AS TEXTFILE
13/07/01 16:30:39 DEBUG hive.TableDefWriter: Load statement: LOAD DATA INPATH 'hdfs://h001:9000/user/hadoop/sqt002' INTO TABLE `sqt002`
13/07/01 16:30:39 INFO hive.HiveImport: Removing temporary files from import process: hdfs://h001:9000/user/hadoop/sqt002/_logs
13/07/01 16:30:39 INFO hive.HiveImport: Loading uploaded data into Hive
13/07/01 16:30:39 DEBUG hive.HiveImport: Using external Hive process.
13/07/01 16:30:46 INFO hive.HiveImport: WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
13/07/01 16:30:54 INFO hive.HiveImport: Logging initialized using configuration in file:/home/hadoop/hive/conf/hive-log4j.properties
13/07/01 16:30:54 INFO hive.HiveImport: Hive history file=/tmp/hadoop/hive_job_log_hadoop_201307011630_1303644418.txt


13/07/01 16:31:23 INFO hive.HiveImport: Exception in thread "main" java.lang.NoSuchMethodError: org.apache.thrift.EncodingUtils.setBit(BIZ)B


13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.plan.api.Query.setStartedIsSet(Query.java:487)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.plan.api.Query.setStarted(Query.java:474)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.QueryPlan.updateCountersInQueryPlan(QueryPlan.java:304)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.QueryPlan.getQueryPlan(QueryPlan.java:437)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.QueryPlan.toString(QueryPlan.java:609)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.history.HiveHistory.logPlanProgress(HiveHistory.java:499)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1059)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.ql.Driver.run(Driver.java:935)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:347)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:445)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:455)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:711)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)
13/07/01 16:31:23 INFO hive.HiveImport:     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
13/07/01 16:31:23 INFO hive.HiveImport:     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
13/07/01 16:31:23 INFO hive.HiveImport:     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
13/07/01 16:31:23 INFO hive.HiveImport:     at java.lang.reflect.Method.invoke(Method.java:601)
13/07/01 16:31:23 INFO hive.HiveImport:     at org.apache.hadoop.util.RunJar.main(RunJar.java:156)


13/07/01 16:31:23 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Hive exited with status 1


    at org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:364)
    at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:314)
    at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:226)
    at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:415)
    at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
    at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
    at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
    at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)