Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> OraOop


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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB