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

Switch to Plain View
Sqoop >> mail # user >> Sqoop to HDFS error Cannot initialize cluster


+
Brenden Cobb 2014-01-30, 17:35
+
Brenden Cobb 2014-01-30, 18:36
+
Abraham Elmahrek 2014-01-30, 18:50
+
Brenden Cobb 2014-01-30, 19:02
+
Abraham Elmahrek 2014-01-30, 19:14
+
Brenden Cobb 2014-01-30, 19:18
+
Abraham Elmahrek 2014-01-30, 20:02
+
Brenden Cobb 2014-01-30, 23:10
+
Abraham Elmahrek 2014-01-30, 23:33
+
Brenden Cobb 2014-01-30, 23:58
+
Abraham Elmahrek 2014-01-31, 00:13
+
Brenden Cobb 2014-01-31, 18:58
Copy link to this message
-
Re: Sqoop to HDFS error Cannot initialize cluster
Awesome! Glad you're moving forward.

For your new exception. Have you verified the table you're trying to import
is owned by the SQOOP user? Also, you may not need the "SQOOP." prefix in
the table parameter.

-Abe
On Fri, Jan 31, 2014 at 10:57 AM, Brenden Cobb <[EMAIL PROTECTED]>wrote:

>  Hi Abe- thanks for your continued help on this issue. I changed my SQOOP
> env setting to point to .20 mapreduce and seem to have progressed (or
> stepped back?)
>
>  It appears I've moved beyond the Mapreduce error and into JDBC connector
> errors... Any thoughts are appreciated.
>
>
>  [$ sqoop import --connect
> jdbc:oracle:thin:@som-dmsandbox03.humedica.net:1521:DB11G --username
> SQOOP --password xx --table SQOOP.test --verbose
>
>  14/01/31 13:50:01 INFO sqoop.Sqoop: Running Sqoop version: 1.4.3-cdh4.5.0
> 14/01/31 13:50:01 DEBUG tool.BaseSqoopTool: Enabled debug logging.
> 14/01/31 13:50:01 WARN tool.BaseSqoopTool: Setting your password on the
> command-line is insecure. Consider using -P instead.
> 14/01/31 13:50:01 DEBUG util.ClassLoaderStack: Checking for existing
> class: com.quest.oraoop.OraOopManagerFactory
> 14/01/31 13:50:01 DEBUG util.ClassLoaderStack: Class is already available.
> Skipping jar /opt/cloudera/parcels/CDH/lib/sqoop/lib/oraoop-1.6.0.jar
> 14/01/31 13:50:01 DEBUG sqoop.ConnFactory: Added factory
> com.quest.oraoop.OraOopManagerFactory in jar
> /opt/cloudera/parcels/CDH/lib/sqoop/lib/oraoop-1.6.0.jar specified by
> /opt/cloudera/parcels/CDH-4.5.0-1.cdh4.5.0.p0.30/bin/../lib/sqoop/conf/managers.d/oraoop
> 14/01/31 13:50:01 DEBUG sqoop.ConnFactory: Loaded manager factory:
> com.quest.oraoop.OraOopManagerFactory
> 14/01/31 13:50:01 DEBUG sqoop.ConnFactory: Loaded manager factory:
> com.cloudera.sqoop.manager.DefaultManagerFactory
> 14/01/31 13:50:01 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
> com.quest.oraoop.OraOopManagerFactory
> 14/01/31 13:50:01 INFO manager.SqlManager: Using default fetchSize of 1000
> 14/01/31 13:50:02 INFO oraoop.OraOopManagerFactory:
> ***********************************************************************
> *** Using Quest(R) Data Connector for Oracle and Hadoop 1.6.0-cdh4-20 ***
> *** Copyright 2012 Quest Software, Inc.                             ***
> *** ALL RIGHTS RESERVED.                                            ***
> ***********************************************************************
> 14/01/31 13:50:02 INFO oraoop.OraOopManagerFactory: Oracle Database
> version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
> Production
> 14/01/31 13:50:02 INFO oraoop.OraOopManagerFactory: This Oracle database
> is not a RAC.
> 14/01/31 13:50:02 DEBUG sqoop.ConnFactory: Instantiated ConnManager
> com.quest.oraoop.OraOopConnManager@40f892a4
> 14/01/31 13:50:02 INFO tool.CodeGenTool: Beginning code generation
> 14/01/31 13:50:02 DEBUG manager.SqlManager: Execute getColumnTypesRawQuery
> : SELECT "FIRST","LAST","EMAIL" FROM SQOOP.test WHERE 0=1
> 14/01/31 13:50:02 DEBUG manager.SqlManager: Using fetchSize for next
> query: 1000
> 14/01/31 13:50:02 INFO manager.SqlManager: Executing SQL statement: SELECT
> "FIRST","LAST","EMAIL" FROM SQOOP.test WHERE 0=1
> 14/01/31 13:50:02 DEBUG manager.SqlManager: Using fetchSize for next
> query: 1000
> 14/01/31 13:50:02 INFO manager.SqlManager: Executing SQL statement: SELECT
> FIRST,LAST,EMAIL FROM SQOOP.test WHERE 1=0
> 14/01/31 13:50:02 DEBUG orm.ClassWriter: selected columns:
> 14/01/31 13:50:02 DEBUG orm.ClassWriter:   FIRST
> 14/01/31 13:50:02 DEBUG orm.ClassWriter:   LAST
> 14/01/31 13:50:02 DEBUG orm.ClassWriter:   EMAIL
> 14/01/31 13:50:02 DEBUG orm.ClassWriter: Writing source file:
> /tmp/sqoop-oracle/compile/95f371afda8b0247e432776caf5d5f4a/SQOOP_test.java
> 14/01/31 13:50:02 DEBUG orm.ClassWriter: Table name: SQOOP.test
> 14/01/31 13:50:02 DEBUG orm.ClassWriter: Columns: FIRST:12, LAST:12,
> EMAIL:12,
> 14/01/31 13:50:02 DEBUG orm.ClassWriter: sourceFilename is SQOOP_test.java
> 14/01/31 13:50:02 DEBUG orm.CompilationManager: Found existing

 
+
Brenden Cobb 2014-01-31, 20:42
+
Brenden Cobb 2014-01-31, 21:42
+
Abraham Elmahrek 2014-01-31, 21:59