You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Rakesh Sharma (JIRA)" <ji...@apache.org> on 2015/09/07 10:13:45 UTC
[jira] [Updated] (SQOOP-2534) --password-file option doesn't work
Teradata jdbc driver
[ https://issues.apache.org/jira/browse/SQOOP-2534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rakesh Sharma updated SQOOP-2534:
---------------------------------
Assignee: (was: Rakesh Sharma)
> --password-file option doesn't work Teradata jdbc driver
> --------------------------------------------------------
>
> Key: SQOOP-2534
> URL: https://issues.apache.org/jira/browse/SQOOP-2534
> Project: Sqoop
> Issue Type: New Feature
> Affects Versions: 1.4.5
> Reporter: Rakesh Sharma
> Priority: Minor
> Fix For: 1.4.7
>
>
> When we use --password-file option while importing with Teradata jdbc driver , we get an exception saying invalid username/password:
> sqoop import --driver com.teradata.jdbc.TeraDriver --connect jdbc:teradata://10.187.82.34/LOGMECH=LDAP,tmode=ANSI,charset=UTF8 --username raksharma --password-file /user/root/td_dev_pswd --table L_PLTScratchpad.test_employee --split-by id --create-hcatalog-table --verbose --hcatalog-table test_employee_tera
> Exception thrown :
> 15/08/27 08:55:01 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.05] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.
> java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.05] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.
> at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:301)
> at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:502)
> at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208)
> at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)
> at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)
> at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)
> at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)
> at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)
> at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)
> at java.sql.DriverManager.getConnection(DriverManager.java:571)
> at java.sql.DriverManager.getConnection(DriverManager.java:215)
> at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:877)
> at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:736)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759)
> at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269)
> at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
> at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226)
> at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295)
> at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:491)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:641)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
> 15/08/27 08:55:01 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1651)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:491)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:641)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)