Hi David, PFA for log file with "—verbose" added to sqoop command.
*Sqoop version: 1.4.5hadoop-2.6.0* Let me know if need other details. Regards Sanjiv Singh Mob : +091 9990-447-339 On Fri, Sep 25, 2015 at 6:04 AM, David Robson < [email protected]> wrote: > Hi Sanjiv, > > > > Could you please run the failing command again and add “—verbose” to > generate debug logging and post the full log file? > > > > David > > > > *From:* @Sanjiv Singh [mailto:[email protected]] > *Sent:* Thursday, 24 September 2015 10:10 PM > *To:* [email protected] > *Cc:* Sanjiv Singh > *Subject:* OraOop : Sqoop Direct Oracle import failed with error "Error: > java.io.IOException: SQLException in nextKeyValue" > > > > Hi Folks, > > > > I am trying to import partitioned Oracle table through "OraOop" - direct > mode to Hive and getting error. > > I tried with other permutation and combination of sqoop parameters, here > is what i have tried. > > > > *Worked (chunk.method=PARTITION and only 1 mapper): > *-Doraoop.import.partitions='OLD_DAYS,SYS_P41,SYS_P42,SYS,SYS_P68,SYS_P69,SYS_P70,SYS_P71' > \ > -Doraoop.chunk.method=PARTITION \ > --m 1 \ > --direct \ > > Worked *(chunk.method=PARTITION removed and 100 mappers):* > > -Doraoop.import.partitions='OLD_DAYS,SYS_P41,SYS_P42,SYS,SYS_P68,SYS_P69,SYS_P70,SYS_P71' > \ > --m 100 \ > --direct \ > > > > * Doesn't work (chunk.method=PARTITION and 100 mappers): > *-Doraoop.import.partitions='OLD_DAYS,SYS_P41,SYS_P42,SYS,SYS_P68,SYS_P69,SYS_P70,SYS_P71' > \ > -Doraoop.chunk.method=PARTITION \ > --m 100 \ > --direct \ > > *Through other combination are working , Can you please help me understand > why chunk.method=PARTITION with multiple mappers failing. ?* > > *Is there something need to be done on hive for partition ? * > > *please help me in resolving the issue ?* > > *Any help is highly appreciated * > > > > > See below full sqoop command which is failing. and error logs. > > *Sqoop Import command (which is failing): * > > $SQOOP_HOME/bin/sqoop import \ > > > > *-Doraoop.disabled=false \ > -Doraoop.import.partitions='OLD_DAYS,SYS_P41,SYS_P42,SYS,SYS_P68,SYS_P69,SYS_P70,SYS_P71' > \ -Doraoop.chunk.method=PARTITION \ -Doraoop.import.consistent.read=true \* > -Dmapred.child.java.opts="-Djava.security.egd=file:/dev/../dev/urandom" \ > --connect jdbc:oracle:thin:@host:port/db \ > --username ***** \ > --password ***** \ > --table DATE_DATA \ > *--direct \* > --hive-import \ > --hive-table tempDB.DATE_DATA \ > --split-by D_DATE_SK \ > *--m 100 \* > --delete-target-dir \ > --target-dir /tmp/34/DATE_DATA > > > *Error logs : * > > 2015-09-24 16:23:57,068 [myid:] - INFO [main:Job@1452] - Task Id : > attempt_1442839036383_0051_m_000006_0, Status : FAILED > Error: java.io.IOException: SQLException in nextKeyValue > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:277) > at > org.apache.sqoop.manager.oracle.OraOopDBRecordReader.nextKeyValue(OraOopDBRecordReader.java:351) > at > org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:553) > at > org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80) > at > org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91) > at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144) > at > org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:415) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not > properly ended > > at > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) > at > oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) > at > org.apache.sqoop.manager.oracle.OraOopDBRecordReader.executeQuery(OraOopDBRecordReader.java:417) > at > org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:235) > ... 13 more > > > > > Regards > Sanjiv Singh > Mob : +091 9990-447-339 >
Warning: /opt/IdwPlatform/sqoop/sqoop-1.4.5//../hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. Warning: /opt/IdwPlatform/sqoop/sqoop-1.4.5//../hcatalog does not exist! HCatalog jobs will fail. Please set $HCAT_HOME to the root of your HCatalog installation. Warning: /opt/IdwPlatform/sqoop/sqoop-1.4.5//../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. Warning: /opt/IdwPlatform/sqoop/sqoop-1.4.5//../zookeeper does not exist! Accumulo imports will fail. Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation. 2015-09-25 09:43:59,544 [myid:] - INFO [main:Sqoop@92] - Running Sqoop version: 1.4.5 2015-09-25 09:43:59,556 [myid:] - WARN [main:BaseSqoopTool@1009] - Setting your password on the command-line is insecure. Consider using -P instead. 2015-09-25 09:43:59,718 [myid:] - INFO [main:SqlManager@98] - Using default fetchSize of 1000 2015-09-25 09:44:00,036 [myid:] - INFO [main:OraOopLog@103] - ************************************************** *** Using Data Connector for Oracle and Hadoop *** ************************************************** 2015-09-25 09:44:00,041 [myid:] - INFO [main:OraOopLog@103] - Oracle Database version: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production 2015-09-25 09:44:00,045 [myid:] - INFO [main:OraOopLog@103] - Performing a consistent read using SCN: 19595159 2015-09-25 09:44:00,046 [myid:] - INFO [main:OraOopLog@103] - This Oracle database is not a RAC. 2015-09-25 09:44:00,053 [myid:] - INFO [main:Configuration@1049] - mapred.map.max.attempts is deprecated. Instead, use mapreduce.map.maxattempts 2015-09-25 09:44:00,056 [myid:] - INFO [main:CodeGenTool@92] - Beginning code generation 2015-09-25 09:44:00,071 [myid:] - INFO [main:SqlManager@749] - Executing SQL statement: SELECT "D_DATE_SK","D_DATE_ID","D_DATE","D_MONTH_SEQ","D_WEEK_SEQ","D_QUARTER_SEQ","D_YEAR","D_DOW","D_MOY","D_DOM","D_QOY","D_FY_YEAR","D_FY_QUARTER_SEQ","D_FY_WEEK_SEQ","D_DAY_NAME","D_QUARTER_NAME","D_HOLIDAY","D_WEEKEND","D_FOLLOWING_HOLIDAY","D_FIRST_DOM","D_LAST_DOM","D_SAME_DAY_LY","D_SAME_DAY_LQ","D_CURRENT_DAY","D_CURRENT_WEEK","D_CURRENT_MONTH","D_CURRENT_QUARTER","D_CURRENT_YEAR" FROM DATE_DATA WHERE 0=1 2015-09-25 09:44:00,075 [myid:] - INFO [main:SqlManager@749] - Executing SQL statement: SELECT D_DATE_SK,D_DATE_ID,D_DATE,D_MONTH_SEQ,D_WEEK_SEQ,D_QUARTER_SEQ,D_YEAR,D_DOW,D_MOY,D_DOM,D_QOY,D_FY_YEAR,D_FY_QUARTER_SEQ,D_FY_WEEK_SEQ,D_DAY_NAME,D_QUARTER_NAME,D_HOLIDAY,D_WEEKEND,D_FOLLOWING_HOLIDAY,D_FIRST_DOM,D_LAST_DOM,D_SAME_DAY_LY,D_SAME_DAY_LQ,D_CURRENT_DAY,D_CURRENT_WEEK,D_CURRENT_MONTH,D_CURRENT_QUARTER,D_CURRENT_YEAR FROM DATE_DATA WHERE 1=0 2015-09-25 09:44:00,092 [myid:] - INFO [main:CompilationManager@94] - HADOOP_MAPRED_HOME is /opt/IdwPlatform/hes/hadoop/hadoop-2.6.0 Note: /tmp/sqoop-root/compile/6158274dfaa748d79b84259e3a12162c/DATE_DATA.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details. 2015-09-25 09:44:01,178 [myid:] - INFO [main:CompilationManager@330] - Writing jar file: /tmp/sqoop-root/compile/6158274dfaa748d79b84259e3a12162c/DATE_DATA.jar 2015-09-25 09:44:01,324 [myid:] - WARN [main:NativeCodeLoader@62] - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 2015-09-25 09:44:01,846 [myid:] - INFO [main:ImportTool@527] - Destination directory /tmp/34/DATE_DATA deleted. 2015-09-25 09:44:01,848 [myid:] - INFO [main:ImportJobBase@216] - Beginning import of DATE_DATA 2015-09-25 09:44:01,857 [myid:] - INFO [main:Configuration@1049] - mapred.jar is deprecated. Instead, use mapreduce.job.jar 2015-09-25 09:44:01,858 [myid:] - INFO [main:SqlManager@749] - Executing SQL statement: SELECT D_DATE_SK,D_DATE_ID,D_DATE,D_MONTH_SEQ,D_WEEK_SEQ,D_QUARTER_SEQ,D_YEAR,D_DOW,D_MOY,D_DOM,D_QOY,D_FY_YEAR,D_FY_QUARTER_SEQ,D_FY_WEEK_SEQ,D_DAY_NAME,D_QUARTER_NAME,D_HOLIDAY,D_WEEKEND,D_FOLLOWING_HOLIDAY,D_FIRST_DOM,D_LAST_DOM,D_SAME_DAY_LY,D_SAME_DAY_LQ,D_CURRENT_DAY,D_CURRENT_WEEK,D_CURRENT_MONTH,D_CURRENT_QUARTER,D_CURRENT_YEAR FROM DATE_DATA WHERE 1=0 2015-09-25 09:44:01,887 [myid:] - INFO [main:Configuration@1049] - mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps 2015-09-25 09:44:01,944 [myid:] - INFO [main:RMProxy@98] - Connecting to ResourceManager at myhost:8032 2015-09-25 09:44:04,035 [myid:] - WARN [main:OraOopLog@176] - System property java.security.egd is not set to file:///dev/urandom - Oracle connections may time out. 2015-09-25 09:44:04,085 [myid:] - INFO [main:DBInputFormat@192] - Using read commited transaction isolation 2015-09-25 09:44:04,091 [myid:] - INFO [main:OraOopLog@103] - Session Time Zone set to GMT 2015-09-25 09:44:04,095 [myid:] - INFO [main:OraOopLog@103] - Initializing Oracle session with SQL : begin dbms_application_info.set_module(module_name => 'Data Connector for Oracle and Hadoop', action_name => 'import 20150925094400IST'); end; 2015-09-25 09:44:04,095 [myid:] - INFO [main:OraOopLog@103] - Initializing Oracle session with SQL : alter session disable parallel query 2015-09-25 09:44:04,096 [myid:] - INFO [main:OraOopLog@103] - Initializing Oracle session with SQL : alter session set "_serial_direct_read"=true 2015-09-25 09:44:04,096 [myid:] - INFO [main:OraOopLog@103] - Initializing Oracle session with SQL : alter session set tracefile_identifier=oraoop 2015-09-25 09:44:04,607 [myid:] - INFO [main:OraOopLog@103] - The table being imported by sqoop has 13312 blocks that have been divided into 100 chunks which will be processed in 100 splits. The chunks will be allocated to the splits using the method : ROUNDROBIN 2015-09-25 09:44:04,818 [myid:] - INFO [main:JobSubmitter@494] - number of splits:100 2015-09-25 09:44:05,101 [myid:] - INFO [main:JobSubmitter@583] - Submitting tokens for job: job_1442839036383_0059 2015-09-25 09:44:05,323 [myid:] - INFO [main:YarnClientImpl@251] - Submitted application application_1442839036383_0059 2015-09-25 09:44:05,350 [myid:] - INFO [main:Job@1300] - The url to track the job: http://myhost:8035/proxy/application_1442839036383_0059/ 2015-09-25 09:44:05,351 [myid:] - INFO [main:Job@1345] - Running job: job_1442839036383_0059 2015-09-25 09:44:10,427 [myid:] - INFO [main:Job@1366] - Job job_1442839036383_0059 running in uber mode : false 2015-09-25 09:44:10,429 [myid:] - INFO [main:Job@1373] - map 0% reduce 0% 2015-09-25 09:44:14,497 [myid:] - INFO [main:Job@1452] - Task Id : attempt_1442839036383_0059_m_000004_0, Status : FAILED Error: java.io.IOException: SQLException in nextKeyValue at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:277) at org.apache.sqoop.manager.oracle.OraOopDBRecordReader.nextKeyValue(OraOopDBRecordReader.java:351) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:553) at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80) at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) at org.apache.sqoop.manager.oracle.OraOopDBRecordReader.executeQuery(OraOopDBRecordReader.java:417) at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:235) ... 13 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) at org.apache.sqoop.manager.oracle.OraOopDBRecordReader.executeQuery(OraOopDBRecordReader.java:417) at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:235) ... 13 more 2015-09-24 21:15:43,321 [myid:] - INFO [main:Job@1452] - Task Id : attempt_1442839036383_0058_m_000009_0, Status : FAILED Error: java.io.IOException: SQLException in nextKeyValue at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:277) at org.apache.sqoop.manager.oracle.OraOopDBRecordReader.nextKeyValue(OraOopDBRecordReader.java:351) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:553) at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80) at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) at org.apache.sqoop.manager.oracle.OraOopDBRecordReader.executeQuery(OraOopDBRecordReader.java:417) at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:235) ... 13 more 2015-09-24 21:15:46,341 [myid:] - INFO [main:Job@1452] - Task Id : attempt_1442839036383_0058_m_000014_1, Status : FAILED Error: java.io.IOException: SQLException in nextKeyValue at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:277) at org.apache.sqoop.manager.oracle.OraOopDBRecordReader.nextKeyValue(OraOopDBRecordReader.java:351) at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:553) at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80) at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:111) at org.apache.sqoop.manager.oracle.OraOopDBRecordReader.executeQuery(OraOopDBRecordReader.java:417) at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:235) ... 13 more 2015-09-25 09:46:27,766 [myid:] - INFO [main:Job@1373] - map 100% reduce 0% 2015-09-25 09:46:27,772 [myid:] - INFO [main:Job@1386] - Job job_1442839036383_0060 failed with state FAILED due to: Task failed task_1442839036383_0060_m_000006 Job failed as tasks failed. failedMaps:1 failedReduces:0 2015-09-25 09:46:27,862 [myid:] - INFO [main:Job@1391] - Counters: 12 Job Counters Failed map tasks=44 Killed map tasks=26 Launched map tasks=70 Other local map tasks=70 Total time spent by all maps in occupied slots (ms)=3835878 Total time spent by all reduces in occupied slots (ms)=0 Total time spent by all map tasks (ms)=1917939 Total vcore-seconds taken by all map tasks=1917939 Total megabyte-seconds taken by all map tasks=7855878144 Map-Reduce Framework CPU time spent (ms)=0 Physical memory (bytes) snapshot=0 Virtual memory (bytes) snapshot=0 2015-09-25 09:46:27,869 [myid:] - WARN [main:AbstractCounters@234] - Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead 2015-09-25 09:46:27,870 [myid:] - INFO [main:ImportJobBase@174] - Transferred 0 bytes in 81.2152 seconds (0 bytes/sec) 2015-09-25 09:46:27,873 [myid:] - INFO [main:ImportJobBase@176] - Retrieved 0 records. 2015-09-25 09:46:27,873 [myid:] - ERROR [main:ImportTool@617] - Error during import: Import job failed!
