hdfs mysql sqoop 失败_sqoop从mysql导入数据到hdfs出错

执行 的命令：

sqoop import --connect jdbc:mysql://localhost:3306/sqoop --username root --password 123456 --query 'select * from user_info where id<3 and $CONDITIONS' --split-by id --target-dir /data/sqoop/mysql/user_info -m 1

错误信息：

Warning: /usr/lib/sqoop/bin/../../hbase does not exist! HBase imports will fail.

Please set $HBASE_HOME to the root of your HBase installation.

Warning: /usr/lib/sqoop/bin/../../hcatalog does not exist! HCatalog jobs will fail.

Please set $HCAT_HOME to the root of your HCatalog installation.

Warning: /usr/lib/sqoop/bin/../../accumulo does not exist! Accumulo imports will fail.

Please set $ACCUMULO_HOME to the root of your Accumulo installation.

16/09/25 19:40:38 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.0

16/09/25 19:40:38 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.

16/09/25 19:40:38 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.

16/09/25 19:40:38 INFO tool.CodeGenTool: Beginning code generation

16/09/25 19:40:38 INFO manager.SqlManager: Executing SQL statement: select * from user_info where id<3 and (1 = 0)

16/09/25 19:40:38 INFO manager.SqlManager: Executing SQL statement: select * from user_info where id<3 and (1 = 0)

16/09/25 19:40:38 INFO manager.SqlManager: Executing SQL statement: select * from user_info where id<3 and (1 = 0)

16/09/25 19:40:38 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/lib/hadoop-mapreduce

Note: /tmp/sqoop-wwx/compile/500c28a290511a002dc4d9df4c372e00/QueryResult.java uses or overrides a deprecated API.

Note: Recompile with -Xlint:deprecation for details.

16/09/25 19:40:40 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-wwx/compile/500c28a290511a002dc4d9df4c372e00/QueryResult.jar

16/09/25 19:40:40 INFO mapreduce.ImportJobBase: Beginning query import.

16/09/25 19:40:41 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar

16/09/25 19:40:41 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps

16/09/25 19:40:41 INFO Configuration.deprecation: session.id is deprecated. Instead, use dfs.metrics.session-id

16/09/25 19:40:41 INFO jvm.JvmMetrics: Initializing JVM Metrics with processName=JobTracker, sessionId=

16/09/25 19:40:42 INFO db.DBInputFormat: Using read commited transaction isolation

16/09/25 19:40:42 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(id), MAX(id) FROM (select * from user_info where id<3 and (1 = 1) ) AS t1

16/09/25 19:40:42 WARN db.TextSplitter: Generating splits for a textual index column.

16/09/25 19:40:42 WARN db.TextSplitter: If your database sorts in a case-insensitive order, this may result in a partial import or duplicate records.

16/09/25 19:40:42 WARN db.TextSplitter: You are strongly encouraged to choose an integral split column.

16/09/25 19:40:42 INFO mapreduce.JobSubmitter: number of splits:1

16/09/25 19:40:42 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_local491857971_0001

16/09/25 19:40:43 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642721/sqoop-1.4.5-cdh5.4.0.jar

16/09/25 19:40:43 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642721/sqoop-1.4.5-cdh5.4.0.jar /usr/lib/sqoop/bin/sqoop-1.4.5-cdh5.4.0.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/sqoop-1.4.5-cdh5.4.0.jar': Permission denied

16/09/25 19:40:43 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642721/sqoop-1.4.5-cdh5.4.0.jar

16/09/25 19:40:43 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/sqoop-1.4.5-cdh5.4.0.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642721/sqoop-1.4.5-cdh5.4.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642722/ant-eclipse-1.0-jvm1.2.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642722/ant-eclipse-1.0-jvm1.2.jar /usr/lib/sqoop/bin/ant-eclipse-1.0-jvm1.2.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/ant-eclipse-1.0-jvm1.2.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642722/ant-eclipse-1.0-jvm1.2.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/ant-eclipse-1.0-jvm1.2.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642722/ant-eclipse-1.0-jvm1.2.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642723/jackson-core-asl-1.8.8.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642723/jackson-core-asl-1.8.8.jar /usr/lib/sqoop/bin/jackson-core-asl-1.8.8.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/jackson-core-asl-1.8.8.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642723/jackson-core-asl-1.8.8.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/jackson-core-asl-1.8.8.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642723/jackson-core-asl-1.8.8.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642724/parquet-jackson.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642724/parquet-jackson.jar /usr/lib/sqoop/bin/parquet-jackson.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-jackson.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642724/parquet-jackson.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-jackson.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642724/parquet-jackson.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642725/xz-1.0.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642725/xz-1.0.jar /usr/lib/sqoop/bin/xz-1.0.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/xz-1.0.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642725/xz-1.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/xz-1.0.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642725/xz-1.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642726/parquet-generator.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642726/parquet-generator.jar /usr/lib/sqoop/bin/parquet-generator.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-generator.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642726/parquet-generator.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-generator.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642726/parquet-generator.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642727/slf4j-api-1.7.5.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642727/slf4j-api-1.7.5.jar /usr/lib/sqoop/bin/slf4j-api-1.7.5.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/slf4j-api-1.7.5.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642727/slf4j-api-1.7.5.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/slf4j-api-1.7.5.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642727/slf4j-api-1.7.5.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642728/paranamer-2.3.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642728/paranamer-2.3.jar /usr/lib/sqoop/bin/paranamer-2.3.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/paranamer-2.3.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642728/paranamer-2.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/paranamer-2.3.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642728/paranamer-2.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642729/mysql-connector-java-5.1.34-bin.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642729/mysql-connector-java-5.1.34-bin.jar /usr/lib/sqoop/bin/mysql-connector-java-5.1.34-bin.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/mysql-connector-java-5.1.34-bin.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642729/mysql-connector-java-5.1.34-bin.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/mysql-connector-java-5.1.34-bin.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642729/mysql-connector-java-5.1.34-bin.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642730/commons-codec-1.4.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642730/commons-codec-1.4.jar /usr/lib/sqoop/bin/commons-codec-1.4.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/commons-codec-1.4.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642730/commons-codec-1.4.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/commons-codec-1.4.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642730/commons-codec-1.4.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642731/jackson-annotations-2.3.0.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642731/jackson-annotations-2.3.0.jar /usr/lib/sqoop/bin/jackson-annotations-2.3.0.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/jackson-annotations-2.3.0.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642731/jackson-annotations-2.3.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/jackson-annotations-2.3.0.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642731/jackson-annotations-2.3.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642732/opencsv-2.3.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642732/opencsv-2.3.jar /usr/lib/sqoop/bin/opencsv-2.3.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/opencsv-2.3.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642732/opencsv-2.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/opencsv-2.3.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642732/opencsv-2.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642733/commons-io-1.4.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642733/commons-io-1.4.jar /usr/lib/sqoop/bin/commons-io-1.4.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/commons-io-1.4.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642733/commons-io-1.4.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/commons-io-1.4.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642733/commons-io-1.4.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642734/snappy-java-1.0.4.1.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642734/snappy-java-1.0.4.1.jar /usr/lib/sqoop/bin/snappy-java-1.0.4.1.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/snappy-java-1.0.4.1.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642734/snappy-java-1.0.4.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/snappy-java-1.0.4.1.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642734/snappy-java-1.0.4.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642735/parquet-format.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642735/parquet-format.jar /usr/lib/sqoop/bin/parquet-format.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-format.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642735/parquet-format.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-format.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642735/parquet-format.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642736/jackson-core-2.3.1.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642736/jackson-core-2.3.1.jar /usr/lib/sqoop/bin/jackson-core-2.3.1.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/jackson-core-2.3.1.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642736/jackson-core-2.3.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/jackson-core-2.3.1.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642736/jackson-core-2.3.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642737/parquet-common.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642737/parquet-common.jar /usr/lib/sqoop/bin/parquet-common.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-common.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642737/parquet-common.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-common.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642737/parquet-common.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642738/kite-data-core.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642738/kite-data-core.jar /usr/lib/sqoop/bin/kite-data-core.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/kite-data-core.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642738/kite-data-core.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/kite-data-core.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642738/kite-data-core.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642739/parquet-avro.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642739/parquet-avro.jar /usr/lib/sqoop/bin/parquet-avro.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-avro.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642739/parquet-avro.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-avro.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642739/parquet-avro.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642740/parquet-column.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642740/parquet-column.jar /usr/lib/sqoop/bin/parquet-column.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-column.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642740/parquet-column.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-column.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642740/parquet-column.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642741/kite-hadoop-compatibility.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642741/kite-hadoop-compatibility.jar /usr/lib/sqoop/bin/kite-hadoop-compatibility.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/kite-hadoop-compatibility.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642741/kite-hadoop-compatibility.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/kite-hadoop-compatibility.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642741/kite-hadoop-compatibility.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642742/ant-contrib-1.0b3.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642742/ant-contrib-1.0b3.jar /usr/lib/sqoop/bin/ant-contrib-1.0b3.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/ant-contrib-1.0b3.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642742/ant-contrib-1.0b3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/ant-contrib-1.0b3.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642742/ant-contrib-1.0b3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642743/parquet-hadoop.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642743/parquet-hadoop.jar /usr/lib/sqoop/bin/parquet-hadoop.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-hadoop.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642743/parquet-hadoop.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-hadoop.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642743/parquet-hadoop.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642744/commons-logging-1.1.3.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642744/commons-logging-1.1.3.jar /usr/lib/sqoop/bin/commons-logging-1.1.3.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/commons-logging-1.1.3.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642744/commons-logging-1.1.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/commons-logging-1.1.3.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642744/commons-logging-1.1.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642745/commons-jexl-2.1.1.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642745/commons-jexl-2.1.1.jar /usr/lib/sqoop/bin/commons-jexl-2.1.1.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/commons-jexl-2.1.1.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642745/commons-jexl-2.1.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/commons-jexl-2.1.1.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642745/commons-jexl-2.1.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642746/parquet-encoding.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642746/parquet-encoding.jar /usr/lib/sqoop/bin/parquet-encoding.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/parquet-encoding.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642746/parquet-encoding.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/parquet-encoding.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642746/parquet-encoding.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642747/kite-data-hive.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642747/kite-data-hive.jar /usr/lib/sqoop/bin/kite-data-hive.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/kite-data-hive.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642747/kite-data-hive.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/kite-data-hive.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642747/kite-data-hive.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642748/avro.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642748/avro.jar /usr/lib/sqoop/bin/avro.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/avro.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642748/avro.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/avro.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642748/avro.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642749/hsqldb-1.8.0.10.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642749/hsqldb-1.8.0.10.jar /usr/lib/sqoop/bin/hsqldb-1.8.0.10.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/hsqldb-1.8.0.10.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642749/hsqldb-1.8.0.10.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/hsqldb-1.8.0.10.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642749/hsqldb-1.8.0.10.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642750/kite-data-mapreduce.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642750/kite-data-mapreduce.jar /usr/lib/sqoop/bin/kite-data-mapreduce.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/kite-data-mapreduce.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642750/kite-data-mapreduce.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/kite-data-mapreduce.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642750/kite-data-mapreduce.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642751/jackson-mapper-asl-1.8.8.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642751/jackson-mapper-asl-1.8.8.jar /usr/lib/sqoop/bin/jackson-mapper-asl-1.8.8.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/jackson-mapper-asl-1.8.8.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642751/jackson-mapper-asl-1.8.8.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/jackson-mapper-asl-1.8.8.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642751/jackson-mapper-asl-1.8.8.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642752/commons-compress-1.4.1.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642752/commons-compress-1.4.1.jar /usr/lib/sqoop/bin/commons-compress-1.4.1.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/commons-compress-1.4.1.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642752/commons-compress-1.4.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/commons-compress-1.4.1.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642752/commons-compress-1.4.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642753/jackson-databind-2.3.1.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642753/jackson-databind-2.3.1.jar /usr/lib/sqoop/bin/jackson-databind-2.3.1.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/jackson-databind-2.3.1.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642753/jackson-databind-2.3.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/jackson-databind-2.3.1.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642753/jackson-databind-2.3.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Creating symlink: /tmp/hadoop-wwx/mapred/local/1474803642754/avro-mapred-hadoop2.jar

16/09/25 19:40:44 WARN fs.FileUtil: Command 'ln -s /tmp/hadoop-wwx/mapred/local/1474803642754/avro-mapred-hadoop2.jar /usr/lib/sqoop/bin/avro-mapred-hadoop2.jar' failed 1 with: ln: creating symbolic link `/usr/lib/sqoop/bin/avro-mapred-hadoop2.jar': Permission denied

16/09/25 19:40:44 WARN mapred.LocalDistributedCacheManager: Failed to create symlink: /tmp/hadoop-wwx/mapred/local/1474803642754/avro-mapred-hadoop2.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: Localized file:/usr/lib/sqoop/lib/avro-mapred-hadoop2.jar as file:/tmp/hadoop-wwx/mapred/local/1474803642754/avro-mapred-hadoop2.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642721/sqoop-1.4.5-cdh5.4.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642722/ant-eclipse-1.0-jvm1.2.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642723/jackson-core-asl-1.8.8.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642724/parquet-jackson.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642725/xz-1.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642726/parquet-generator.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642727/slf4j-api-1.7.5.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642728/paranamer-2.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642729/mysql-connector-java-5.1.34-bin.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642730/commons-codec-1.4.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642731/jackson-annotations-2.3.0.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642732/opencsv-2.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642733/commons-io-1.4.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642734/snappy-java-1.0.4.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642735/parquet-format.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642736/jackson-core-2.3.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642737/parquet-common.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642738/kite-data-core.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642739/parquet-avro.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642740/parquet-column.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642741/kite-hadoop-compatibility.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642742/ant-contrib-1.0b3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642743/parquet-hadoop.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642744/commons-logging-1.1.3.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642745/commons-jexl-2.1.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642746/parquet-encoding.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642747/kite-data-hive.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642748/avro.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642749/hsqldb-1.8.0.10.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642750/kite-data-mapreduce.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642751/jackson-mapper-asl-1.8.8.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642752/commons-compress-1.4.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642753/jackson-databind-2.3.1.jar

16/09/25 19:40:44 INFO mapred.LocalDistributedCacheManager: file:/tmp/hadoop-wwx/mapred/local/1474803642754/avro-mapred-hadoop2.jar

16/09/25 19:40:44 INFO mapreduce.Job: The url to track the job: http://localhost:8080/

16/09/25 19:40:44 INFO mapreduce.Job: Running job: job_local491857971_0001

16/09/25 19:40:44 INFO mapred.LocalJobRunner: OutputCommitter set in config null

16/09/25 19:40:44 INFO output.FileOutputCommitter: File Output Committer Algorithm version is 1

16/09/25 19:40:44 INFO mapred.LocalJobRunner: OutputCommitter is org.apache.hadoop.mapreduce.lib.output.FileOutputCommitter

16/09/25 19:40:44 ERROR output.FileOutputCommitter: Mkdirs failed to create file:/data/sqoop/mysql/user_info/_temporary/0

16/09/25 19:40:44 INFO mapred.LocalJobRunner: Waiting for map tasks

16/09/25 19:40:44 INFO mapred.LocalJobRunner: Starting task: attempt_local491857971_0001_m_000000_0

16/09/25 19:40:44 INFO output.FileOutputCommitter: File Output Committer Algorithm version is 1

16/09/25 19:40:44 INFO mapred.Task: Using ResourceCalculatorProcessTree : [ ]

16/09/25 19:40:44 INFO db.DBInputFormat: Using read commited transaction isolation

16/09/25 19:40:44 INFO mapred.MapTask: Processing split: id >= '1' AND id <= '2'

16/09/25 19:40:44 INFO mapred.LocalJobRunner: map task executor complete.

16/09/25 19:40:44 WARN mapred.LocalJobRunner: job_local491857971_0001

java.lang.Exception: java.io.IOException: Mkdirs failed to create file:/data/sqoop/mysql/user_info/_temporary/0/_temporary/attempt_local491857971_0001_m_000000_0 (exists=false, cwd=file:/usr/lib/sqoop/bin)

at org.apache.hadoop.mapred.LocalJobRunner$Job.runTasks(LocalJobRunner.java:462)

at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:522)

Caused by: java.io.IOException: Mkdirs failed to create file:/data/sqoop/mysql/user_info/_temporary/0/_temporary/attempt_local491857971_0001_m_000000_0 (exists=false, cwd=file:/usr/lib/sqoop/bin)

at org.apache.hadoop.fs.ChecksumFileSystem.create(ChecksumFileSystem.java:442)

at org.apache.hadoop.fs.ChecksumFileSystem.create(ChecksumFileSystem.java:428)

at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:908)

at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:889)

at org.apache.hadoop.fs.FileSystem.create(FileSystem.java:786)

at org.apache.sqoop.mapreduce.RawKeyTextOutputFormat.getRecordWriter(RawKeyTextOutputFormat.java:98)

at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.(MapTask.java:647)

at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:767)

at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)

at org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:243)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

16/09/25 19:40:45 INFO mapreduce.Job: Job job_local491857971_0001 running in uber mode : false

16/09/25 19:40:45 INFO mapreduce.Job: map 0% reduce 0%

16/09/25 19:40:45 INFO mapreduce.Job: Job job_local491857971_0001 failed with state FAILED due to: NA

16/09/25 19:40:45 INFO mapreduce.Job: Counters: 0

16/09/25 19:40:45 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead

16/09/25 19:40:45 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 3.8725 seconds (0 bytes/sec)

16/09/25 19:40:45 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead

16/09/25 19:40:45 INFO mapreduce.ImportJobBase: Retrieved 0 records.

16/09/25 19:40:45 ERROR tool.ImportTool: Error during import: Import job failed!