Hello Josh, I get the same error when I use --direct argument
Thanks Sajid Thanks Jay On Fri, Jun 26, 2015 at 1:57 AM, Joshua Baxter <[email protected]> wrote: > Hi Kumar, > > The oraoop connector has been included with sqoop since 1.4.5 and should > not need to be additionally installed but instead can be used with the > --direct argument. Firstly I would remove the manually installed connector > and try again using the one shipped within the sqoop jar. > > Regards > > Josh > > On Fri, 26 Jun 2015 00:49 Kumar Jayapal <[email protected]> wrote: > >> Hello All, >> >> I have installed Quest Data Connector for Oracle but is showing error >> while importing data using sqoop. >> >> I am import the same data from oracle when i disable it. I have copied >> debug logs and also searched net dint find any thing to resolve this issue. >> >> please let me know if any one had resolved this issue. >> >> >> Please set $ACCUMULO_HOME to the root of your Accumulo installation. >> 15/06/25 23:40:39 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.3.2 >> 15/06/25 23:40:39 DEBUG tool.BaseSqoopTool: Enabled debug logging. >> Enter password: >> 15/06/25 23:40:47 DEBUG util.ClassLoaderStack: Checking for existing >> class: com.quest.oraoop.OraOopManagerFactory >> 15/06/25 23:40:47 DEBUG util.ClassLoaderStack: Attempting to load jar >> through URL: >> jar:file:/opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/lib/oraoop-1.6.0.jar!/ >> 15/06/25 23:40:47 DEBUG util.ClassLoaderStack: Previous classloader is >> sun.misc.Launcher$AppClassLoader@3479404a >> 15/06/25 23:40:47 DEBUG util.ClassLoaderStack: Testing class in jar: >> com.quest.oraoop.OraOopManagerFactory >> 15/06/25 23:40:47 DEBUG util.ClassLoaderStack: Loaded jar into current >> JVM: >> jar:file:/opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/lib/oraoop-1.6.0.jar!/ >> 15/06/25 23:40:47 DEBUG util.ClassLoaderStack: Added classloader for jar >> /opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/lib/oraoop-1.6.0.jar: >> java.net.FactoryURLClassLoader@4cd9794b >> 15/06/25 23:40:47 DEBUG sqoop.ConnFactory: Added factory >> com.quest.oraoop.OraOopManagerFactory in jar >> /opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/lib/oraoop-1.6.0.jar >> specified by >> /opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/bin/../lib/sqoop/conf/managers.d/oraoop >> 15/06/25 23:40:47 DEBUG sqoop.ConnFactory: Loaded manager factory: >> com.quest.oraoop.OraOopManagerFactory >> 15/06/25 23:40:47 DEBUG sqoop.ConnFactory: Loaded manager factory: >> org.apache.sqoop.manager.oracle.OraOopManagerFactory >> 15/06/25 23:40:47 DEBUG sqoop.ConnFactory: Loaded manager factory: >> com.cloudera.sqoop.manager.DefaultManagerFactory >> 15/06/25 23:40:47 DEBUG sqoop.ConnFactory: Trying ManagerFactory: >> com.quest.oraoop.OraOopManagerFactory >> 15/06/25 23:40:48 DEBUG oraoop.OraOopUtilities: Enabled OraOop debug >> logging. >> 15/06/25 23:40:48 DEBUG oraoop.OraOopManagerFactory: Quest® Data >> Connector for Oracle and Hadoop can be called by Sqoop! >> 15/06/25 23:40:48 INFO manager.SqlManager: Using default fetchSize of 1000 >> 15/06/25 23:40:48 DEBUG oraoop.OraOopUtilities: The Oracle table context >> has been derived from: >> oracleConnectionUserName = edhdtaesvc >> tableStr = SAP.MS_MEMB >> as: >> owner : SAP >> table : MS_MEMB >> 15/06/25 23:40:48 WARN oraoop.OraOopManagerFactory: Unable to determine >> the Oracle-type of the object named MS_MEMB owned by SAP. >> Error: >> ORA-00942: table or view does not exist >> >> 15/06/25 23:40:48 WARN oraoop.OraOopManagerFactory: Unable to determine >> whether the Oracle table "SAP"."MS_MEMB" is an index-organized table. >> Error: >> ORA-00942: table or view does not exist >> >> 15/06/25 23:40:48 INFO oraoop.OraOopManagerFactory: >> *********************************************************************** >> *** Using Quest® Data Connector for Oracle and Hadoop 1.6.0-cdh4-20 *** >> *** Copyright 2012 Quest Software, Inc. *** >> *** ALL RIGHTS RESERVED. *** >> *********************************************************************** >> 15/06/25 23:40:48 DEBUG oraoop.OraOopUtilities: Updated >> mapred.child.java.opts from "-Xmx200m" to >> "-Djava.security.egd=file:///dev/urandom -Xmx200m" >> 15/06/25 23:40:48 INFO oraoop.OraOopManagerFactory: Oracle Database >> version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit >> Production >> 15/06/25 23:40:48 INFO oraoop.OraOopManagerFactory: This Oracle database >> is not a RAC. >> 15/06/25 23:40:48 INFO Configuration.deprecation: mapred.map.max.attempts >> is deprecated. Instead, use mapreduce.map.maxattempts >> 15/06/25 23:40:48 DEBUG sqoop.ConnFactory: Instantiated ConnManager >> com.quest.oraoop.OraOopConnManager@354a5255 >> 15/06/25 23:40:48 INFO tool.CodeGenTool: Beginning code generation >> 15/06/25 23:40:48 DEBUG oraoop.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/06/25 23:40:48 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 >> com.quest.oraoop.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:124) >> at >> com.quest.oraoop.OraOopConnManager.getSelectedColumnNamesInOracleTable(OraOopConnManager.java:135) >> at >> com.quest.oraoop.OraOopConnManager.getColTypesQuery(OraOopConnManager.java:198) >> at >> org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:225) >> at >> com.quest.oraoop.OraOopConnManager.getColumnTypes(OraOopConnManager.java:460) >> 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 >> com.quest.oraoop.OraOopOracleQueries.getTableColumns(OraOopOracleQueries.java:511) >> at >> com.quest.oraoop.OraOopOracleQueries.getTableColumns(OraOopOracleQueries.java:613) >> at >> com.quest.oraoop.OraOopOracleQueries.getTableColumnNames(OraOopOracleQueries.java:470) >> at >> com.quest.oraoop.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:115) >> >> >> >> >> >> >> Thanks >> Jay >> >
