sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gwen Shapira <gshap...@cloudera.com>
Subject Re: Quest Data Connector for Oracle throws error.
Date Fri, 26 Jun 2015 23:26:31 GMT
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 <kjayapal17@gmail.com> 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 <joshuagbaxter@gmail.com>
> 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 <kjayapal17@gmail.com> 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
>
>

Mime
View raw message