Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - OraOop


Copy link to this message
-
OraOop
Kathleen Ting 2012-07-04, 19:13
Dear Venky,

For faster resolution of Sqoop support issues, please subscribe to the
Sqoop User mailing list by emailing: [EMAIL PROTECTED]

Regarding your issue below, it could be that your version of Hadoop is
not compatible with OraOop - what is your Hadoop version?

Regards, Kathleen

sqoop import  --connect
jdbc:oracle:thin:@lyisdb01.dev.sgp.avagotech.net:1523:OPTCH --username
system --password clone --table VENK -verbose
12/07/04 05:39:14 WARN tool.BaseSqoopTool: Setting your password on
the command-line is insecure. Consider using -P instead.
12/07/04 05:39:14 DEBUG oraoop.OraOopUtilities: Enabled OraOop debug logging.
12/07/04 05:39:14 DEBUG oraoop.OraOopManagerFactory: Quest® Data
Connector for Oracle and Hadoop can be called by Sqoop!
12/07/04 05:39:14 INFO manager.SqlManager: Using default fetchSize of 1000
12/07/04 05:39:15 DEBUG oraoop.OraOopUtilities: The Oracle table
context has been derived from:
        oracleConnectionUserName = system
        tableStr = VENK
        as:
        owner : SYSTEM
        table : VENK
12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory:
***************************************************************
*** Using Quest® Data Connector for Oracle and Hadoop 1.5.0 ***
*** Copyright 2012 Quest Software, Inc.                     ***
*** ALL RIGHTS RESERVED.                                    ***
***************************************************************
12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: Oracle Database
version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 -
64bit Production
12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: This Oracle
database is not a RAC.
12/07/04 05:39:15 WARN conf.Configuration: mapred.map.max.attempts is
deprecated. Instead, use mapreduce.map.maxattempts
12/07/04 05:39:15 INFO tool.CodeGenTool: Beginning code generation
12/07/04 05:39:15 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
12/07/04 05:39:15 INFO manager.SqlManager: Executing SQL statement:
SELECT "A","B" FROM VENK WHERE 0=1
12/07/04 05:39:15 INFO manager.SqlManager: Executing SQL statement:
SELECT A,B FROM VENK WHERE 1=0
12/07/04 05:39:15 INFO orm.CompilationManager: HADOOP_HOME is /usr/lib/hadoop
Note: /tmp/sqoop-root/compile/8817da7c72ed005d42065edefc806224/VENK.java
uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
12/07/04 05:39:18 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-root/compile/8817da7c72ed005d42065edefc806224/VENK.jar
12/07/04 05:39:18 DEBUG oraoop.OraOopConnManager: The output directory
for the sqoop table import is : VENK
Exception in thread "main" java.lang.NoSuchMethodError:
com.cloudera.sqoop.manager.ImportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V
        at com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:248)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)