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


To be clear, SQOOP-480 applies to OraOop as well as MS connector. (I
encountered both myself.) I have a comment in the JIRA saying this also
occurs in OraOop although it might not be very visible.

Hope that nobody misunderstands.

Thanks,
Cheolsoo

On Wed, Jul 4, 2012 at 1:05 PM, Cheolsoo Park <[EMAIL PROTECTED]> wrote:

> 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.
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