sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "arvind@cloudera.com" <arv...@cloudera.com>
Subject Re: [sqoop-user] sqoop-export
Date Thu, 04 Aug 2011 18:12:18 GMT
[bcc:sqoop-user@cloudera.org, to:sqoop-user@incubator.apache.org.
Please move the conversation over to Apache mailing list].

Hi Sonal,

You are likely running into [SQOOP-222]. Try specifying the
username/password for the user that is associated with the EMP table
instead of scott/tiger.

[SQOOP-222] https://issues.cloudera.org/browse/SQOOP-222

Thanks,
Arvind


On Thu, Aug 4, 2011 at 3:46 AM, Sonal <imsonalkumar@gmail.com> wrote:
> Hi,
>
> Am trying for the sqoop-export with following command:
> sqoop-export --connect jdbc:oracle:thin:@adc2190481.us.oracle.com:
> 1521:qooptry --username scott --password tiger --table "EMP" --export-
> dir SQOOP_TEST
>
> scoop version:
> Sqoop 1.3.0-cdh3u1
> git commit id 3a60cc809b14d538dd1eb0e90ffa9767e8d06a43
> Compiled by jenkins@ubuntu-slave01 on Mon Jul 18 08:38:49 PDT 2011
>
> It is failing with
> ERROR manager.OracleManager: Failed to rollback transaction
> ERROR manager.OracleManager: Failed to list columns
> 11/08/04 03:39:49 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.IllegalArgumentException: Field names must be greater than 0
>
> 11/08/04 03:39:47 WARN tool.BaseSqoopTool: Setting your password on
> the command-line is insecure. Consider using -P instead.
> 11/08/04 03:39:47 INFO manager.SqlManager: Using default fetchSize of
> 1000
> 11/08/04 03:39:47 INFO tool.CodeGenTool: Beginning code generation
> 11/08/04 03:39:47 INFO manager.OracleManager: Time zone has been set
> to GMT
> 11/08/04 03:39:47 INFO manager.SqlManager: Executing SQL statement:
> SELECT t.* FROM EMP t WHERE 1=0
> 11/08/04 03:39:47 WARN manager.SqlManager: SQLException closing
> ResultSet: java.sql.SQLException: Could not commit with auto-commit
> set on
> 11/08/04 03:39:47 ERROR manager.OracleManager: Failed to rollback
> transaction
> java.sql.SQLException: Could not rollback with auto-commit set on
>        at
> oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:
> 3988)
>        at
> com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:
> 669)
>        at
> com.cloudera.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:
> 1154)
>        at
> com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:1029)
>        at
> com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
>        at
> com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:64)
>        at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
> 11/08/04 03:39:47 ERROR manager.OracleManager: Failed to list columns
> java.sql.SQLException: Could not commit with auto-commit set on
>        at
> oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:
> 3926)
>        at
> oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:
> 3973)
>        at
> com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:
> 666)
>        at
> com.cloudera.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:
> 1154)
>        at
> com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:1029)
>        at
> com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
>        at
> com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:64)
>        at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
> 11/08/04 03:39:47 INFO orm.CompilationManager: HADOOP_HOME is /usr/lib/
> hadoop
> 11/08/04 03:39:47 INFO orm.CompilationManager: Found hadoop core jar
> at: /usr/lib/hadoop/hadoop-0.20.2+737-core.jar
> Note: /tmp/sqoop-sonkumar/compile/a51ce8fa8e7e85f00e02dbd1e0ea38b6/
> EMP.java uses or overrides a deprecated API.
> Note: Recompile with -Xlint:deprecation for details.
> 11/08/04 03:39:49 ERROR orm.CompilationManager: Could not rename /tmp/
> sqoop-sonkumar/compile/a51ce8fa8e7e85f00e02dbd1e0ea38b6/EMP.java to /
> net/adc2190481/scratch/sonkumar/view_storage/sonkumar_sqooptry/work/./
> EMP.java
> java.io.IOException: Destination '/net/adc2190481/scratch/sonkumar/
> view_storage/sonkumar_sqooptry/work/./EMP.java' already exists
>        at org.apache.commons.io.FileUtils.moveFile(FileUtils.java:
> 1811)
>        at
> com.cloudera.sqoop.orm.CompilationManager.compile(CompilationManager.java:
> 227)
>        at
> com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:83)
>        at
> com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:64)
>        at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
> 11/08/04 03:39:49 INFO orm.CompilationManager: Writing jar file: /tmp/
> sqoop-sonkumar/compile/a51ce8fa8e7e85f00e02dbd1e0ea38b6/EMP.jar
> 11/08/04 03:39:49 INFO mapreduce.ExportJobBase: Beginning export of
> EMP
> 11/08/04 03:39:49 ERROR manager.OracleManager: Failed to rollback
> transaction
> java.lang.NullPointerException
>        at
> com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:
> 669)
>        at
> com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java:
> 84)
>        at
> com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:
> 331)
>        at
> com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java:
> 375)
>        at
> com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73)
>        at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
> 11/08/04 03:39:49 ERROR manager.OracleManager: Failed to list columns
> java.sql.SQLException: Could not rollback with auto-commit set on
>        at
> oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:
> 3988)
>        at com.cloudera.sqoop.manager.OracleManager
> $ConnCache.getConnection(OracleManager.java:179)
>        at
> com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java:
> 268)
>        at
> com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:
> 51)
>        at
> com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:
> 656)
>        at
> com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java:
> 84)
>        at
> com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:
> 331)
>        at
> com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java:
> 375)
>        at
> com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73)
>        at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
> 11/08/04 03:39:49 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.IllegalArgumentException: Field names must be greater than 0
> java.lang.IllegalArgumentException: Field names must be greater than 0
>        at
> com.cloudera.sqoop.mapreduce.db.DBOutputFormat.setOutput(DBOutputFormat.java:
> 205)
>        at
> com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java:
> 86)
>        at
> com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:
> 331)
>        at
> com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java:
> 375)
>        at
> com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73)
>        at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
>
> can anyone help , what is the cause for it?
>
> Thanks & Regards,
> Sonal
>
> --
> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of Apache Sqoop
mailing list sqoop-user@incubator.apache.org. Please subscribe to it by sending an email to
incubator-sqoop-user-subscribe@apache.org.
>

Mime
View raw message