Do you have your full command for us? Also, is this a custom connector/manager? Try Sqoop2 for custom stuff!
On Wed, Jul 1, 2015 at 1:11 PM, Kumar Jayapal <[email protected]> wrote: > Hello All, > > I wanted to test my oracle data connector. when I execute sqoop import > command I get below errorr. my sqoop command works fine with single mapper. > > > Warning: > /opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/bin/../lib/sqoop/../accumulo > does not exist! Accumulo imports will fail. > Please set $ACCUMULO_HOME to the root of your Accumulo installation. > 15/07/01 18:45:21 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.3.2 > 15/07/01 18:45:21 DEBUG tool.BaseSqoopTool: Enabled debug logging. > 15/07/01 18:45:21 WARN tool.BaseSqoopTool: Setting your password on the > command-line is insecure. Consider using -P instead. > 15/07/01 18:45:21 DEBUG sqoop.ConnFactory: Loaded manager factory: > org.apache.sqoop.manager.oracle.OraOopManagerFactory > 15/07/01 18:45:21 DEBUG sqoop.ConnFactory: Loaded manager factory: > com.cloudera.sqoop.manager.DefaultManagerFactory > 15/07/01 18:45:21 DEBUG sqoop.ConnFactory: Trying ManagerFactory: > org.apache.sqoop.manager.oracle.OraOopManagerFactory > 15/07/01 18:45:21 DEBUG oracle.OraOopManagerFactory: Data Connector for > Oracle and Hadoop can be called by Sqoop! > 15/07/01 18:45:21 INFO manager.SqlManager: Using default fetchSize of 1000 > 15/07/01 18:45:21 DEBUG oracle.OraOopUtilities: The Oracle table context > has been derived from: > oracleConnectionUserName = TAESVC > tableStr = MSH_MEMS > as: > owner : TAESVC > table : MSH_MEMS > 15/07/01 18:45:22 WARN oracle.OraOopManagerFactory: Unable to determine > the Oracle-type of the object named MSH_MEMS owned by TAESVC. > Error: > ORA-00942: table or view does not exist > > 15/07/01 18:45:22 WARN oracle.OraOopManagerFactory: Unable to determine > whether the Oracle table "TAESVC"."MSH_MEMS" is an index-organized table. > Error: > ORA-00942: table or view does not exist > > 15/07/01 18:45:22 INFO oracle.OraOopManagerFactory: > ************************************************** > *** Using Data Connector for Oracle and Hadoop *** > ************************************************** > 15/07/01 18:45:22 DEBUG oracle.OraOopUtilities: Updated > mapred.child.java.opts from "-Xmx200m" to > "-Djava.security.egd=file:///dev/urandom -Xmx200m" > 15/07/01 18:45:22 INFO oracle.OraOopManagerFactory: Oracle Database > version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit > Production > 15/07/01 18:45:22 INFO oracle.OraOopManagerFactory: This Oracle database > is not a RAC. > 15/07/01 18:45:22 DEBUG oracle.OraOopManagerFactory: Setting mapper url > oraoop.mapper.jdbc.url.0 = jdbc:oracle:thin:@ > (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= > lorctt01a.qat.np.costco.com > )(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CT1))) > 15/07/01 18:45:22 DEBUG oracle.OraOopManagerFactory: Setting mapper url > oraoop.mapper.jdbc.url.1 = jdbc:oracle:thin:@ > (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= > lorctt01a.qat.np.costco.com > )(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CT1))) > 15/07/01 18:45:22 INFO Configuration.deprecation: mapred.map.max.attempts > is deprecated. Instead, use mapreduce.map.maxattempts > 15/07/01 18:45:22 DEBUG sqoop.ConnFactory: Instantiated ConnManager > org.apache.sqoop.manager.oracle.OraOopConnManager@2ee8b0bf > 15/07/01 18:45:22 INFO tool.CodeGenTool: Beginning code generation > 15/07/01 18:45:22 DEBUG oracle.OraOopOracleQueries: getTableColumns() : > sql = > SELECT column_name, data_type FROM dba_tab_columns WHERE owner = ? and > table_name = ? and (DATA_TYPE IN > ('BINARY_DOUBLE','BINARY_FLOAT','BLOB','CHAR','CLOB','DATE','FLOAT','LONG','NCHAR','NCLOB','NUMBER','NVARCHAR2','RAW','ROWID','URITYPE','VARCHAR2') > OR DATA_TYPE LIKE 'INTERVAL YEAR(%) TO MONTH' OR DATA_TYPE LIKE 'INTERVAL > DAY(%) TO SECOND(%)' OR DATA_TYPE LIKE 'TIMESTAMP(%)' OR DATA_TYPE LIKE > 'TIMESTAMP(%) WITH TIME ZONE' OR DATA_TYPE LIKE 'TIMESTAMP(%) WITH LOCAL > TIME ZONE') ORDER BY column_id > 15/07/01 18:45:22 ERROR sqoop.Sqoop: Got exception running Sqoop: > java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: > table or view does not exist > > java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: > table or view does not exist > > at > org.apache.sqoop.manager.oracle.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:133) > at > org.apache.sqoop.manager.oracle.OraOopConnManager.getSelectedColumnNamesInOracleTable(OraOopConnManager.java:144) > at > org.apache.sqoop.manager.oracle.OraOopConnManager.getColTypesQuery(OraOopConnManager.java:216) > at > org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:225) > at > org.apache.sqoop.manager.oracle.OraOopConnManager.getColumnTypes(OraOopConnManager.java:504) > at > org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295) > at > org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833) > at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645) > at > org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96) > at > org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478) > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) > at org.apache.sqoop.Sqoop.run(Sqoop.java:143) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) > at org.apache.sqoop.Sqoop.main(Sqoop.java:236) > Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does > not exist > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) > at > org.apache.sqoop.manager.oracle.OraOopOracleQueries.getTableColumns(OraOopOracleQueries.java:658) > at > org.apache.sqoop.manager.oracle.OraOopOracleQueries.getTableColumns(OraOopOracleQueries.java:767) > at > org.apache.sqoop.manager.oracle.OraOopOracleQueries.getTableColumnNames(OraOopOracleQueries.java:624) > at > org.apache.sqoop.manager.oracle.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:124) > ... 16 more > > > > > > > > > Thanks > Jay >
