You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Cheolsoo Park (Updated) (JIRA)" <ji...@apache.org> on 2012/04/03 22:50:22 UTC

[jira] [Updated] (SQOOP-473) Sqoop import-all-tables fails with MySQL connector

     [ https://issues.apache.org/jira/browse/SQOOP-473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Cheolsoo Park updated SQOOP-473:
--------------------------------

    Attachment: SQOOP-473.patch
    
> Sqoop import-all-tables fails with MySQL connector
> --------------------------------------------------
>
>                 Key: SQOOP-473
>                 URL: https://issues.apache.org/jira/browse/SQOOP-473
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors
>    Affects Versions: 1.4.1-incubating
>            Reporter: Prashant Gokhale
>            Assignee: Cheolsoo Park
>         Attachments: SQOOP-473.patch
>
>
> Sqoop command 
> sqoop import-all-tables --connect jdbc:mysql://xxxx/mysqltestdb2 --username=xxxx --warehouse-dir output-dir/alltables
> Output:
> {noformat}
> 12/03/29 10:42:20 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
> 12/03/29 10:42:21 INFO tool.CodeGenTool: Beginning code generation
> 12/03/29 10:42:21 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `testtable` AS t LIMIT 1
> 12/03/29 10:42:21 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
> java.lang.NullPointerException
> 	at org.apache.sqoop.manager.ConnManager.getColumnTypeNames(ConnManager.java:306)
> 	at org.apache.sqoop.manager.MySQLManager.toJavaType(MySQLManager.java:237)
> 	at org.apache.sqoop.orm.ClassWriter.toJavaType(ClassWriter.java:253)
> 	at org.apache.sqoop.orm.ClassWriter.generateFields(ClassWriter.java:480)
> 	at org.apache.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1306)
> 	at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1138)
> 	at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> 	at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)
> 	at org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:64)
> 	at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> 	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:69)
> 	at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> 	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> 	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> 	at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> 	at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
> {noformat}
> I have not tested with other connectors.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira