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

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


Hi Venky,

Exception in thread "main"
> java.lang.NoSuchMethodError: com.cloudera.sqoop.manager.ImportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V
This is fixed in the upstream trunk. Please see SQOOP-480:
https://issues.apache.org/jira/browse/SQOOP-480. Unfortunately, there is no
official Sqoop release that include this fix, so you will have to apply the
patch and rebuild Sqoop.

Thanks,
Cheolsoo
On Wed, Jul 4, 2012 at 12:13 PM, Kathleen Ting <[EMAIL PROTECTED]> wrote:

> 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