[
https://issues.apache.org/jira/browse/SQOOP-338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13105672#comment-13105672
]
Todd Lipcon commented on SQOOP-338:
-----------------------------------
{noformat}
[training@localhost ml-data]$ sqoop import --connect
jdbc:mysql://localhost/training --hive-import --table Movies
11/09/15 13:43:21 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for
output. You can override
11/09/15 13:43:21 INFO tool.BaseSqoopTool: delimiters with
--fields-terminated-by, etc.
11/09/15 13:43:21 INFO tool.CodeGenTool: Beginning code generation
11/09/15 13:43:21 ERROR manager.SqlManager: Error executing statement:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for
user ''@'localhost' to database 'training'
11/09/15 13:43:21 ERROR manager.SqlManager: Error executing statement:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for
user ''@'localhost' to database 'training'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for
user ''@'localhost' to database 'training'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at
com.cloudera.sqoop.manager.SqlManager.makeConnection(SqlManager.java:604)
at
com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:51)
at
com.cloudera.sqoop.manager.MySQLManager.execute(MySQLManager.java:201)
at
com.cloudera.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:112)
at
com.cloudera.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:96)
at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:924)
at com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)
11/09/15 13:43:21 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.NullPointerException
java.lang.NullPointerException
at
com.cloudera.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:889)
at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:951)
at com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)
{noformat}
> NPE after specifying incorrect JDBC credentials
> -----------------------------------------------
>
> Key: SQOOP-338
> URL: https://issues.apache.org/jira/browse/SQOOP-338
> Project: Sqoop
> Issue Type: Bug
> Environment: Sqoop 1.2.0-cdh3u0
> git commit id 455acc8dee10b6a3579358cccc3635241076391b
> Compiled by hudson@ubuntu-slave02 on Fri Mar 25 16:25:35 PDT 2011
> Reporter: Todd Lipcon
>
> I tried to do a sqoop import but forgot to specify a username and password.
> The command line used was:
> {code}
> sqoop import --connect jdbc:mysql://localhost/training --hive-import --table
> Movies
> {code}
> This resulted in an NPE being logged.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
