sqoop1教程日志说明

Last updated on November 20, 2024 am
🧙 Questions

☄️ Ideas

Warning: /u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/log4j-slf4j-impl-2.8.2.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]
22/02/22 16:43:09 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7-cdh6.2.0
22/02/22 16:43:09 DEBUG tool.BaseSqoopTool: Enabled debug logging.
22/02/22 16:43:09 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
22/02/22 16:43:09 DEBUG tool.BaseSqoopTool: Parquet job configurator implementation is not set, using default value: KITE
22/02/22 16:43:09 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
22/02/22 16:43:09 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.DefaultManagerFactory
22/02/22 16:43:09 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
22/02/22 16:43:09 DEBUG oracle.OraOopUtilities: Enabled OraOop debug logging.
22/02/22 16:43:09 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop can be called by Sqoop!
22/02/22 16:43:09 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.DefaultManagerFactory
22/02/22 16:43:09 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:mysql:
22/02/22 16:43:10 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
22/02/22 16:43:10 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.MySQLManager@52e677af
22/02/22 16:43:10 INFO tool.CodeGenTool: Beginning code generation
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
22/02/22 16:43:10 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
22/02/22 16:43:11 DEBUG manager.SqlManager: Using fetchSize for next query: -2147483648
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column id of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column vin of type [12, 32, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column car_flag of type [12, 255, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column imei of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column plate of type [12, 20, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column factory_id of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column model_id of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column office_id of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column latest_register of type [93, 19, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column remarks of type [12, 200, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column create_date of type [93, 19, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column create_by of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column update_date of type [93, 19, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column update_by of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column del_flag of type [-6, 3, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column version_id of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column own_account_id of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column pay_account_id of type [12, 64, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column serviceStatus of type [1, 50, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column produceDate of type [91, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column vehicleStatus of type [4, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_open_time of type [91, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_pause_time of type [91, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_recovery_time of type [91, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_certification_time of type [91, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column authenticationc_code of type [12, 255, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column historyTrajectory of type [4, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column isshowcar of type [12, 1, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column ecall_status of type [12, 1, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column MP5online of type [4, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column owner_change_date of type [93, 19, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column bolt_date of type [93, 19, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column mark of type [12, 1, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column tServe_term of type [12, 5, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column cp_term of type [12, 5, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column monitor_status of type [12, 2, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column credit_lock of type [12, 2, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_photo_name of type [12, 255, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_lon of type [12, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_lat of type [12, 10, 0]
22/02/22 16:43:11 DEBUG manager.SqlManager: Using fetchSize for next query: -2147483648
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column id
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column vin
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column car_flag
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column imei
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column plate
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column factory_id
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column model_id
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column office_id
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column latest_register
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column remarks
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column create_date
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column create_by
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column update_date
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column update_by
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column del_flag
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column version_id
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column own_account_id
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column pay_account_id
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column serviceStatus
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column produceDate
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column vehicleStatus
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_open_time
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_pause_time
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_recovery_time
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_certification_time
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column authenticationc_code
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column historyTrajectory
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column isshowcar
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column ecall_status
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column MP5online
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column owner_change_date
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column bolt_date
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column mark
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column tServe_term
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column cp_term
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column monitor_status
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column credit_lock
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_photo_name
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_lon
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_lat
22/02/22 16:43:11 DEBUG orm.ClassWriter: selected columns:
22/02/22 16:43:11 DEBUG orm.ClassWriter: id
22/02/22 16:43:11 DEBUG orm.ClassWriter: vin
22/02/22 16:43:11 DEBUG orm.ClassWriter: car_flag
22/02/22 16:43:11 DEBUG orm.ClassWriter: imei
22/02/22 16:43:11 DEBUG orm.ClassWriter: plate
22/02/22 16:43:11 DEBUG orm.ClassWriter: factory_id
22/02/22 16:43:11 DEBUG orm.ClassWriter: model_id
22/02/22 16:43:11 DEBUG orm.ClassWriter: office_id
22/02/22 16:43:11 DEBUG orm.ClassWriter: latest_register
22/02/22 16:43:11 DEBUG orm.ClassWriter: remarks
22/02/22 16:43:11 DEBUG orm.ClassWriter: create_date
22/02/22 16:43:11 DEBUG orm.ClassWriter: create_by
22/02/22 16:43:11 DEBUG orm.ClassWriter: update_date
22/02/22 16:43:11 DEBUG orm.ClassWriter: update_by
22/02/22 16:43:11 DEBUG orm.ClassWriter: del_flag
22/02/22 16:43:11 DEBUG orm.ClassWriter: version_id
22/02/22 16:43:11 DEBUG orm.ClassWriter: own_account_id
22/02/22 16:43:11 DEBUG orm.ClassWriter: pay_account_id
22/02/22 16:43:11 DEBUG orm.ClassWriter: serviceStatus
22/02/22 16:43:11 DEBUG orm.ClassWriter: produceDate
22/02/22 16:43:11 DEBUG orm.ClassWriter: vehicleStatus
22/02/22 16:43:11 DEBUG orm.ClassWriter: service_open_time
22/02/22 16:43:11 DEBUG orm.ClassWriter: service_pause_time
22/02/22 16:43:11 DEBUG orm.ClassWriter: service_recovery_time
22/02/22 16:43:11 DEBUG orm.ClassWriter: service_certification_time
22/02/22 16:43:11 DEBUG orm.ClassWriter: authenticationc_code
22/02/22 16:43:11 DEBUG orm.ClassWriter: historyTrajectory
22/02/22 16:43:11 DEBUG orm.ClassWriter: isshowcar
22/02/22 16:43:11 DEBUG orm.ClassWriter: ecall_status
22/02/22 16:43:11 DEBUG orm.ClassWriter: MP5online
22/02/22 16:43:11 DEBUG orm.ClassWriter: owner_change_date
22/02/22 16:43:11 DEBUG orm.ClassWriter: bolt_date
22/02/22 16:43:11 DEBUG orm.ClassWriter: mark
22/02/22 16:43:11 DEBUG orm.ClassWriter: tServe_term
22/02/22 16:43:11 DEBUG orm.ClassWriter: cp_term
22/02/22 16:43:11 DEBUG orm.ClassWriter: monitor_status
22/02/22 16:43:11 DEBUG orm.ClassWriter: credit_lock
22/02/22 16:43:11 DEBUG orm.ClassWriter: park_photo_name
22/02/22 16:43:11 DEBUG orm.ClassWriter: park_lon
22/02/22 16:43:11 DEBUG orm.ClassWriter: park_lat
22/02/22 16:43:11 DEBUG manager.SqlManager: Using fetchSize for next query: -2147483648
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column id of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column vin of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column car_flag of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column imei of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column plate of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column factory_id of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column model_id of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column office_id of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column latest_register of type DATETIME
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column remarks of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column create_date of type DATETIME
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column create_by of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column update_date of type DATETIME
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column update_by of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column del_flag of type TINYINT
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column version_id of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column own_account_id of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column pay_account_id of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column serviceStatus of type CHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column produceDate of type DATE
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column vehicleStatus of type INT
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_open_time of type DATE
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_pause_time of type DATE
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_recovery_time of type DATE
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column service_certification_time of type DATE
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column authenticationc_code of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column historyTrajectory of type INT
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column isshowcar of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column ecall_status of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column MP5online of type INT
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column owner_change_date of type DATETIME
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column bolt_date of type DATETIME
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column mark of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column tServe_term of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column cp_term of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column monitor_status of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column credit_lock of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_photo_name of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_lon of type VARCHAR
22/02/22 16:43:11 DEBUG manager.SqlManager: Found column park_lat of type VARCHAR
22/02/22 16:43:11 DEBUG orm.ClassWriter: Writing source file: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult.java
22/02/22 16:43:11 DEBUG orm.ClassWriter: Table name: null
22/02/22 16:43:11 DEBUG orm.ClassWriter: Columns: id:12, vin:12, car_flag:12, imei:12, plate:12, factory_id:12, model_id:12, office_id:12, latest_register:93, remarks:12, create_date:93, create_by:12, update_date:93, update_by:12, del_flag:-6, version_id:12, own_account_id:12, pay_account_id:12, serviceStatus:1, produceDate:91, vehicleStatus:4, service_open_time:91, service_pause_time:91, service_recovery_time:91, service_certification_time:91, authenticationc_code:12, historyTrajectory:4, isshowcar:12, ecall_status:12, MP5online:4, owner_change_date:93, bolt_date:93, mark:12, tServe_term:12, cp_term:12, monitor_status:12, credit_lock:12, park_photo_name:12, park_lon:12, park_lat:12,
22/02/22 16:43:11 DEBUG orm.ClassWriter: sourceFilename is QueryResult.java
22/02/22 16:43:11 DEBUG orm.CompilationManager: Found existing /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/
22/02/22 16:43:11 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /u01/cloudera/parcels/CDH/lib/hadoop-mapreduce
22/02/22 16:43:11 DEBUG orm.CompilationManager: Returning jar file path /u01/cloudera/parcels/CDH/lib/hadoop-mapreduce/hadoop-mapreduce-client-core.jar:/u01/cloudera/parcels/CDH/lib/hadoop-mapreduce/hadoop-mapreduce-client-core-3.0.0-cdh6.2.0.jar
22/02/22 16:43:11 DEBUG orm.CompilationManager: Adding source file: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult.java
22/02/22 16:43:11 DEBUG orm.CompilationManager: Invoking javac with args:
22/02/22 16:43:11 DEBUG orm.CompilationManager: -encoding
22/02/22 16:43:11 DEBUG orm.CompilationManager: UTF-8
22/02/22 16:43:11 DEBUG orm.CompilationManager: -sourcepath
22/02/22 16:43:11 DEBUG orm.CompilationManager: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/
22/02/22 16:43:11 DEBUG orm.CompilationManager: -d
22/02/22 16:43:11 DEBUG orm.CompilationManager: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/
22/02/22 16:43:11 DEBUG orm.CompilationManager: -classpath
22/02/22 16:43:16 DEBUG orm.CompilationManager: moving file from /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult.java to /home/ispong/./QueryResult.java
22/02/22 16:43:16 ERROR orm.CompilationManager: Could not rename /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult.java to /home/ispong/./QueryResult.java. Error: Destination '/home/ispong/./QueryResult.java' already exists
22/02/22 16:43:16 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult.jar
22/02/22 16:43:16 DEBUG orm.CompilationManager: Scanning for .class files in directory: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$1.class -> QueryResult$1.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$10.class -> QueryResult$10.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$11.class -> QueryResult$11.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$12.class -> QueryResult$12.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$13.class -> QueryResult$13.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$14.class -> QueryResult$14.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$15.class -> QueryResult$15.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$16.class -> QueryResult$16.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$17.class -> QueryResult$17.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$18.class -> QueryResult$18.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$19.class -> QueryResult$19.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$2.class -> QueryResult$2.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$20.class -> QueryResult$20.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$21.class -> QueryResult$21.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$22.class -> QueryResult$22.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$23.class -> QueryResult$23.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$24.class -> QueryResult$24.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$25.class -> QueryResult$25.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$26.class -> QueryResult$26.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$27.class -> QueryResult$27.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$28.class -> QueryResult$28.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$29.class -> QueryResult$29.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$3.class -> QueryResult$3.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$30.class -> QueryResult$30.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$31.class -> QueryResult$31.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$32.class -> QueryResult$32.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$33.class -> QueryResult$33.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$34.class -> QueryResult$34.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$35.class -> QueryResult$35.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$36.class -> QueryResult$36.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$37.class -> QueryResult$37.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$38.class -> QueryResult$38.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$39.class -> QueryResult$39.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$4.class -> QueryResult$4.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$40.class -> QueryResult$40.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$5.class -> QueryResult$5.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$6.class -> QueryResult$6.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$7.class -> QueryResult$7.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$8.class -> QueryResult$8.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$9.class -> QueryResult$9.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult$FieldSetterCommand.class -> QueryResult$FieldSetterCommand.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult.class -> QueryResult.class
22/02/22 16:43:16 DEBUG orm.CompilationManager: Finished writing jar file /tmp/sqoop-ispong/compile/adb72e634d7f8e7ed61d11b98ed59bf4/QueryResult.jar
22/02/22 16:43:18 INFO tool.ImportTool: Destination directory /user/hive/warehouse/ispong_test.db/ods_rtm_vehicle deleted.
22/02/22 16:43:18 INFO mapreduce.ImportJobBase: Beginning query import.
22/02/22 16:43:18 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar
22/02/22 16:43:18 DEBUG db.DBConfiguration: Securing password into job credentials store
22/02/22 16:43:18 DEBUG mapreduce.DataDrivenImportJob: Using table class: QueryResult
22/02/22 16:43:18 DEBUG mapreduce.DataDrivenImportJob: Using InputFormat: class org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat
22/02/22 16:43:18 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/sqoop-1.4.7-cdh6.2.0.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/usr/share/java/mysql-connector-java.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/sqoop-1.4.7-cdh6.2.0.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/jars/sqoop-1.4.7-cdh6.2.0.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jackson-annotations-2.9.8.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/parquet-jackson.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/guava-11.0.2.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/kite-data-hive.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/datanucleus-core-4.1.6.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jetty-http-9.3.25.v20180904.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jackson-core-asl-1.9.13.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/kite-data-core.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jackson-databind-2.9.8.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-compress-1.18.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/parquet-common.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/ojdbc7.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-io-2.4.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-pool-1.6.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jetty-util-9.3.25.v20180904.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/ant-eclipse-1.0-jvm1.2.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/opencsv-2.3.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/avro-mapred.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/transaction-api-1.1.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-logging-1.2.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/paranamer-2.8.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jsr305-2.0.1.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-lang3-3.4.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/javax.servlet-api-3.1.0.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-collections-3.2.2.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/javax.jdo-3.2.0-m3.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/avro.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/datanucleus-api-jdo-4.2.1.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/xz-1.6.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/datanucleus-rdbms-4.1.7.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jetty-security-9.3.25.v20180904.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/avro-ipc.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/ant-contrib-1.0b3.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/parquet-format.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jackson-core-2.9.8.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/re2j-1.0.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-jexl-2.1.1.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/fastutil-7.2.1.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/parquet-column.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jetty-io-9.3.25.v20180904.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/bonecp-0.8.0.RELEASE.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/parquet-avro.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/kite-data-mapreduce.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/parquet-encoding.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-codec-1.9.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/kite-hadoop-compatibility.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/snappy-java-1.1.4.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/slf4j-api-1.7.25.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jetty-servlet-9.3.25.v20180904.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jetty-server-9.3.25.v20180904.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/parquet-hadoop.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/derby-10.14.1.0.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/audience-annotations-0.7.0.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/hsqldb-1.8.0.10.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/commons-lang-2.6.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/netty-3.10.6.Final.jar
22/02/22 16:43:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/u01/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/sqoop/lib/jackson-mapper-asl-1.9.13-cloudera.1.jar
22/02/22 16:43:18 INFO client.RMProxy: Connecting to ResourceManager at cdh-master/192.168.21.71:8032
22/02/22 16:43:19 INFO mapreduce.JobResourceUploader: Disabling Erasure Coding for path: /user/ispong/.staging/job_1645175159718_0722
22/02/22 16:43:23 DEBUG db.DBConfiguration: Fetching password from job credentials store
22/02/22 16:43:23 INFO db.DBInputFormat: Using read commited transaction isolation
22/02/22 16:43:23 DEBUG db.DataDrivenDBInputFormat: Creating input split with lower bound '1=1' and upper bound '1=1'
22/02/22 16:43:23 INFO mapreduce.JobSubmitter: number of splits:1
22/02/22 16:43:23 INFO Configuration.deprecation: yarn.resourcemanager.system-metrics-publisher.enabled is deprecated. Instead, use yarn.system-metrics-publisher.enabled
22/02/22 16:43:23 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1645175159718_0722
22/02/22 16:43:23 INFO mapreduce.JobSubmitter: Executing with tokens: []
22/02/22 16:43:24 INFO conf.Configuration: resource-types.xml not found
22/02/22 16:43:24 INFO resource.ResourceUtils: Unable to find 'resource-types.xml'.
22/02/22 16:43:24 INFO impl.YarnClientImpl: Submitted application application_1645175159718_0722
22/02/22 16:43:24 INFO mapreduce.Job: The url to track the job: http://cdh-master:8088/proxy/application_1645175159718_0722/
22/02/22 16:43:24 INFO mapreduce.Job: Running job: job_1645175159718_0722
22/02/22 16:43:35 INFO mapreduce.Job: Job job_1645175159718_0722 running in uber mode : false
22/02/22 16:43:35 INFO mapreduce.Job: map 0% reduce 0%
22/02/22 16:45:51 INFO mapreduce.Job: Task Id : attempt_1645175159718_0722_m_000000_0, Status : FAILED
Error: java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at org.apache.sqoop.mapreduce.db.DBInputFormat.setDbConf(DBInputFormat.java:167)
at org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:158)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:77)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:137)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:763)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1875)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168)
Caused by: java.lang.RuntimeException: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220)
at org.apache.sqoop.mapreduce.db.DBInputFormat.setDbConf(DBInputFormat.java:165)
... 10 more
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300)
at org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213)
... 11 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
at com.mysql.cj.NativeSession.connect(NativeSession.java:144)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
... 18 more
Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
... 21 more
22/02/22 16:47:02 INFO mapreduce.Job: map 100% reduce 0%
22/02/22 16:47:02 INFO mapreduce.Job: Job job_1645175159718_0722 completed successfully
22/02/22 16:47:02 INFO mapreduce.Job: Counters: 34
File System Counters
FILE: Number of bytes read=0
FILE: Number of bytes written=245391
FILE: Number of read operations=0
FILE: Number of large read operations=0
FILE: Number of write operations=0
HDFS: Number of bytes read=85
HDFS: Number of bytes written=49593299
HDFS: Number of read operations=6
HDFS: Number of large read operations=0
HDFS: Number of write operations=2
HDFS: Number of bytes read erasure-coded=0
Job Counters
Failed map tasks=1
Launched map tasks=2
Other local map tasks=2
Total time spent by all maps in occupied slots (ms)=203510
Total time spent by all reduces in occupied slots (ms)=0
Total time spent by all map tasks (ms)=203510
Total vcore-milliseconds taken by all map tasks=203510
Total megabyte-milliseconds taken by all map tasks=208394240
Map-Reduce Framework
Map input records=166224
Map output records=166224
Input split bytes=85
Spilled Records=0
Failed Shuffles=0
Merged Map outputs=0
GC time elapsed (ms)=231
CPU time spent (ms)=13020
Physical memory (bytes) snapshot=432394240
Virtual memory (bytes) snapshot=2654416896
Total committed heap usage (bytes)=569376768
Peak Map Physical memory (bytes)=451690496
Peak Map Virtual memory (bytes)=2654416896
File Input Format Counters
Bytes Read=0
File Output Format Counters
Bytes Written=49593299
22/02/22 16:47:02 INFO mapreduce.ImportJobBase: Transferred 47.2959 MB in 223.8728 seconds (216.3325 KB/sec)
22/02/22 16:47:02 INFO mapreduce.ImportJobBase: Retrieved 166224 records.
🔗 Links

sqoop website
sqoop
sqoop1教程日志说明
https://ispong.isxcode.com/hadoop/sqoop/sqoop1教程日志说明/
Author
ispong
Posted on
February 24, 2022
Licensed under
antdesign 安装 Previous
java 校招面试 Next
sqoop1教程 日志说明

🧙 Questions

☄️ Ideas

🔗 Links

sqoop1教程日志说明
