通过sqoop 导入hive错误

Question

[root@orep apps]# sqoop import --connect jdbc:mysql://192.168.3.6:3306/hive --username root --password mysql123 --table VERSION --hive-table VERSION --hive-import
17/03/09 05:45:34 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.10.0
17/03/09 05:45:34 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/03/09 05:45:34 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
17/03/09 05:45:34 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
17/03/09 05:45:34 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
17/03/09 05:45:34 INFO tool.CodeGenTool: Beginning code generation
17/03/09 05:45:34 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM VERSION AS t LIMIT 1
17/03/09 05:45:34 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM VERSION AS t LIMIT 1
17/03/09 05:45:34 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /apps/hadoop-2.7.2
Note: /tmp/sqoop-root/compile/4b54b295fba470d9743716efe53e0d48/VERSION.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
17/03/09 05:45:36 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/4b54b295fba470d9743716efe53e0d48/VERSION.jar
17/03/09 05:45:36 WARN manager.MySQLManager: It looks like you are importing from mysql.
17/03/09 05:45:36 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
17/03/09 05:45:36 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
17/03/09 05:45:36 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
17/03/09 05:45:36 INFO mapreduce.ImportJobBase: Beginning import of VERSION
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/apps/hadoop-2.7.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/apps/hbase/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
17/03/09 05:45:36 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar
17/03/09 05:45:37 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
17/03/09 05:45:37 INFO client.RMProxy: Connecting to ResourceManager at /192.168.3.6:8032
17/03/09 05:45:41 INFO db.DBInputFormat: Using read commited transaction isolation
17/03/09 05:45:41 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(VER_ID), MAX(VER_ID) FROM VERSION
17/03/09 05:45:41 INFO db.IntegerSplitter: Split size: 0; Num splits: 4 from: 1 to: 1
17/03/09 05:45:41 INFO mapreduce.JobSubmitter: number of splits:1
17/03/09 05:45:41 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1488979391372_0005
17/03/09 05:45:42 INFO impl.YarnClientImpl: Submitted application application_1488979391372_0005
17/03/09 05:45:42 INFO mapreduce.Job: The url to track the job: http://Kylin01:8088/proxy/application_1488979391372_0005/
17/03/09 05:45:42 INFO mapreduce.Job: Running job: job_1488979391372_0005
17/03/09 05:45:50 INFO mapred.ClientServiceDelegate: Application state is completed. FinalApplicationStatus=FAILED. Redirecting to job history server
17/03/09 05:45:50 INFO mapreduce.Job: Job job_1488979391372_0005 running in uber mode : false
17/03/09 05:45:50 INFO mapreduce.Job: map 0% reduce 100%
17/03/09 05:45:50 INFO mapreduce.Job: Job job_1488979391372_0005 failed with state FAILED due to:
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: The MapReduce job has already been retired. Performance
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: counters are unavailable. To get this information,
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: you will need to enable the completed job store on
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: the jobtracker with:
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.active = true
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.hours = 1
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: A jobtracker restart is required for these settings
17/03/09 05:45:50 INFO mapreduce.ImportJobBase: to take effect.
17/03/09 05:45:50 ERROR tool.ImportTool: Error during import: Import job failed!
烦请给我大神帮我诊断一下，谢谢

Answer 1

http://blog.csdn.net/chaiyiping/article/details/40622507