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

Switch to Plain View
Sqoop, mail # user - OraOop


+
Kathleen Ting 2012-07-04, 19:13
+
Cheolsoo Park 2012-07-04, 20:05
Copy link to this message
-
Re: OraOop
Cheolsoo Park 2012-07-04, 20:21
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.
+
David Robson 2012-07-05, 00:19
+
Cheolsoo Park 2012-07-05, 05:43
+
Cheolsoo Park 2012-07-05, 05:46
+
Cheolsoo Park 2012-07-05, 06:24
+
Cheolsoo Park 2012-07-05, 06:26
+
Cheolsoo Park 2012-07-05, 07:43
+
Cheolsoo Park 2012-07-05, 08:16
+
Cheolsoo Park 2012-07-05, 05:09