I am new to Cloudxlab, so request everyone to please guide me.
I am trying to import data from table emp_data in mysql
i run the below command and get error:
command:
sqoop import --connect “jdbc:mysql://ip-172-31-13-154:3306/sqoopex” --username=sqoopuser -P --table emp_data --target-dir /user/mittalvibhorvibhor28719/vibhor_hdfs/sqoop_v
Error:
18/06/04 06:04:46 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
18/06/04 06:04:46 INFO tool.CodeGenTool: Beginning code generation
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.4.0-3485/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.4.0-3485/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.4.0-3485/accumulo/lib/slf4j-log4j12.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]
18/06/04 06:04:47 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM emp_data AS t LIMIT 1
18/06/04 06:04:47 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM emp_data AS t LIMIT 1
18/06/04 06:04:47 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.3.4.0-3485/hadoop-mapreduce
Note: /tmp/sqoop-mittalvibhor28719/compile/811dfab6eb7a310a048fa3386f7dfadc/emp_data.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
18/06/04 06:04:48 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-mittalvibhor28719/compile/811dfab6eb7a310a048fa3386f7dfadc/emp_data.jar
18/06/04 06:04:48 WARN manager.MySQLManager: It looks like you are importing from mysql.
18/06/04 06:04:48 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
18/06/04 06:04:48 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
18/06/04 06:04:48 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
18/06/04 06:04:48 INFO mapreduce.ImportJobBase: Beginning import of emp_data
18/06/04 06:04:50 INFO impl.TimelineClientImpl: Timeline service address: http://ip-172-31-13-154.ec2.internal:8188/ws/v1/timeline/
18/06/04 06:04:50 INFO client.RMProxy: Connecting to ResourceManager at ip-172-31-53-48.ec2.internal/172.31.53.48:8050
18/06/04 06:04:52 INFO db.DBInputFormat: Using read commited transaction isolation
18/06/04 06:04:52 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(id), MAX(id) FROM emp_data
18/06/04 06:04:52 INFO mapreduce.JobSubmitter: number of splits:5
18/06/04 06:04:52 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1527045214830_1671
18/06/04 06:04:53 INFO impl.YarnClientImpl: Submitted application application_1527045214830_1671
18/06/04 06:04:53 INFO mapreduce.Job: Running job: job_1527045214830_1671
18/06/04 06:04:59 INFO mapred.ClientServiceDelegate: Application state is completed. FinalApplicationStatus=FAILED. Redirecting to job history server
18/06/04 06:04:59 INFO mapreduce.Job: Job job_1527045214830_1671 running in uber mode : false
18/06/04 06:04:59 INFO mapreduce.Job: map 0% reduce 100%
18/06/04 06:04:59 INFO mapreduce.Job: Job job_1527045214830_1671 failed with state FAILED due to:
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: The MapReduce job has already been retired. Performance
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: counters are unavailable. To get this information,
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: you will need to enable the completed job store on
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: the jobtracker with:
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.active = true
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.hours = 1
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: A jobtracker restart is required for these settings
18/06/04 06:04:59 INFO mapreduce.ImportJobBase: to take effect.
18/06/04 06:04:59 ERROR tool.ImportTool: Error during import: Import job failed!