hdfs@hdpmaster:/usr/hdp/2.6.0.3-8/sqoop/lib$ sqoop import --connect "jdbc:mysql://192.168.1.23:3306/blp" --username root --password Root@123 --table emp --hive-import -m 1
Warning: /usr/hdp/2.6.0.3-8/hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /usr/hdp/2.6.0.3-8/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
18/06/04 17:04:18 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.0.3-8
18/06/04 17:04:18 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
18/06/04 17:04:18 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
18/06/04 17:04:18 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
18/06/04 17:04:18 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
18/06/04 17:04:18 INFO tool.CodeGenTool: Beginning code generation
Mon Jun 04 17:04:18 IST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
18/06/04 17:04:19 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `emp` AS t LIMIT 1
18/06/04 17:04:19 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `emp` AS t LIMIT 1
18/06/04 17:04:19 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.6.0.3-8/hadoop-mapreduce
Note: /tmp/sqoop-hdfs/compile/f8f2c5ef51b268f0c6e39c770c1995ef/emp.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
18/06/04 17:04:20 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-hdfs/compile/f8f2c5ef51b268f0c6e39c770c1995ef/emp.jar
18/06/04 17:04:20 WARN manager.MySQLManager: It looks like you are importing from mysql.
18/06/04 17:04:20 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
18/06/04 17:04:20 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
18/06/04 17:04:20 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
18/06/04 17:04:20 INFO mapreduce.ImportJobBase: Beginning import of emp
18/06/04 17:04:21 INFO client.RMProxy: Connecting to ResourceManager at hdpcluster2.blpclean.com/192.168.1.12:8050
18/06/04 17:04:21 INFO client.AHSProxy: Connecting to Application History server at hdpmaster.blpclean.com/192.168.1.10:10200
Mon Jun 04 17:04:29 IST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
18/06/04 17:04:30 INFO db.DBInputFormat: Using read commited transaction isolation
18/06/04 17:04:30 INFO mapreduce.JobSubmitter: number of splits:1
18/06/04 17:04:30 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1528094305283_0011
18/06/04 17:04:31 INFO impl.YarnClientImpl: Submitted application application_1528094305283_0011
18/06/04 17:04:31 INFO mapreduce.Job: The url to track the job: http://hdpcluster2.blpclean.com:8088/proxy/application_1528094305283_0011/
18/06/04 17:04:31 INFO mapreduce.Job: Running job: job_1528094305283_0011
18/06/04 17:04:57 INFO mapreduce.Job: Job job_1528094305283_0011 running in uber mode : false
18/06/04 17:04:57 INFO mapreduce.Job:  map 0% reduce 0%
18/06/04 17:04:57 INFO mapreduce.Job: Job job_1528094305283_0011 failed with state FAILED due to: Application application_1528094305283_0011 failed 2 times due to AM Container for appattempt_1528094305283_0011_000002 exited with  exitCode: -1000
For more detailed output, check the application tracking page: http://hdpcluster2.blpclean.com:8088/cluster/app/application_1528094305283_0011 Then click on links to logs of each attempt.
Diagnostics: ExitCodeException exitCode=2:
gzip: /hadoop/yarn/local/filecache/18_tmp/tmp_mapreduce.tar.gz: unexpected end of file
tar: Unexpected EOF in archive
tar: Unexpected EOF in archive
tar: Error is not recoverable: exiting now

Failing this attempt. Failing the application.
18/06/04 17:04:57 INFO mapreduce.Job: Counters: 0
18/06/04 17:04:57 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
18/06/04 17:04:57 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 35.8778 seconds (0 bytes/sec)
18/06/04 17:04:57 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
18/06/04 17:04:57 INFO mapreduce.ImportJobBase: Retrieved 0 records.
18/06/04 17:04:57 ERROR tool.ImportTool: Error during import: Import job failed!