There's a bunch of privileges you need to give the user that Sqoop is connecting with - they are listed in the docs. It looks like you may have not configured all of them.
On Fri, Jun 26, 2015 at 3:11 PM, Kumar Jayapal <[email protected]> wrote: > 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 > >
