Not able to import all tables in hive

Hold on, read this through before raising topic in this category
Hi Sir

I am using below command for import data from mysql to my hive directory but i am getting below error when i am trying to import through sqoop …please help me.

sqoop import-all-tables -m 12 --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” --username=retail_dba --password=itversity --as-avrodatafile --warehouse-dir=/apps/hive/warehouse/retail_stages.db
20/02/05 15:47:49 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.5.0-292
20/02/05 15:47:49 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
20/02/05 15:47:49 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
20/02/05 15:47:49 INFO tool.CodeGenTool: Beginning code generation
20/02/05 15:47:49 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM categories AS t LIMIT 1
20/02/05 15:47:49 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM categories AS t LIMIT 1
20/02/05 15:47:50 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.6.5.0-292/hadoop-mapreduce
Note: /tmp/sqoop-nitinbelote07/compile/b475aa68b37b71052874a974798758fd/categories.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
20/02/05 15:47:51 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-nitinbelote07/compile/b475aa68b37b71052874a974798758fd/categories.jar
20/02/05 15:47:51 WARN manager.MySQLManager: It looks like you are importing from mysql.
20/02/05 15:47:51 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
20/02/05 15:47:51 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
20/02/05 15:47:51 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
20/02/05 15:47:51 INFO mapreduce.ImportJobBase: Beginning import of categories
20/02/05 15:47:52 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM categories AS t LIMIT 1
20/02/05 15:47:52 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM categories AS t LIMIT 1
20/02/05 15:47:52 INFO mapreduce.DataDrivenImportJob: Writing Avro schema file: /tmp/sqoop-nitinbelote07/compile/b475aa68b37b71052874a974798758fd/categories.avsc
20/02/05 15:47:52 INFO client.RMProxy: Connecting to ResourceManager at rm01.itversity.com/172.16.1.106:8050
20/02/05 15:47:52 INFO client.AHSProxy: Connecting to Application History server at rm01.itversity.com/172.16.1.106:10200
20/02/05 15:48:00 INFO db.DBInputFormat: Using read commited transaction isolation
20/02/05 15:48:00 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(category_id), MAX(category_id) FROM categories
20/02/05 15:48:00 INFO db.IntegerSplitter: Split size: 4; Num splits: 12 from: 1 to: 58
20/02/05 15:48:01 INFO mapreduce.JobSubmitter: number of splits:12
20/02/05 15:48:01 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1565300265360_54095
20/02/05 15:48:01 INFO impl.YarnClientImpl: Submitted application application_1565300265360_54095
20/02/05 15:48:01 INFO mapreduce.Job: The url to track the job: http://rm01.itversity.com:19088/proxy/application_1565300265360_54095/
20/02/05 15:48:01 INFO mapreduce.Job: Running job: job_1565300265360_54095
20/02/05 15:48:08 INFO mapreduce.Job: Job job_1565300265360_54095 running in uber mode : false
20/02/05 15:48:08 INFO mapreduce.Job: map 0% reduce 0%
20/02/05 15:48:13 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000002_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:14 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000007_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000004_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000009_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000008_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000003_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000005_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000010_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000000_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000001_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:15 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000006_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:16 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000011_0, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:17 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000007_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:19 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000002_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:19 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000006_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:19 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000000_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:20 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000001_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:20 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000008_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:20 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000003_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:20 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000004_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:20 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000009_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:20 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000010_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:20 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000005_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:21 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000007_2, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:21 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000011_1, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:24 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000001_2, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:24 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000008_2, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:24 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000006_2, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
20/02/05 15:48:25 INFO mapreduce.Job: Task Id : attempt_1565300265360_54095_m_000005_2, Status : FAILED
Error: org.apache.avro.reflect.ReflectData.addLogicalTypeConversion(Lorg/apache/avro/Conversion;)V
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143.

20/02/05 15:48:26 INFO mapreduce.Job: map 100% reduce 0%
20/02/05 15:48:26 INFO mapreduce.Job: Job job_1565300265360_54095 failed with state FAILED due to: Task failed task_1565300265360_54095_m_000007
Job failed as tasks failed. failedMaps:1 failedReduces:0

20/02/05 15:48:26 INFO mapreduce.Job: Counters: 12
Job Counters
Failed map tasks=30
Killed map tasks=11
Launched map tasks=37
Other local map tasks=37
Total time spent by all maps in occupied slots (ms)=263642
Total time spent by all reduces in occupied slots (ms)=0
Total time spent by all map tasks (ms)=131821
Total vcore-milliseconds taken by all map tasks=131821
Total megabyte-milliseconds taken by all map tasks=269969408
Map-Reduce Framework
CPU time spent (ms)=0
Physical memory (bytes) snapshot=0
Virtual memory (bytes) snapshot=0
20/02/05 15:48:26 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
20/02/05 15:48:26 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 33.8907 seconds (0 bytes/sec)
20/02/05 15:48:26 INFO mapreduce.ImportJobBase: Retrieved 0 records.
20/02/05 15:48:26 ERROR tool.ImportAllTablesTool: Error during import: Import job failed!