[
https://issues.apache.org/jira/browse/SQOOP-2534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14716311#comment-14716311
]
Rakesh Sharma commented on SQOOP-2534:
--------------------------------------
After some investigation , I found out that when Sqoop is reading password from
file , it is appending \n to the password. Other databases like db2, mysql
oracle etc are ignoring that but in case of teradata, it is throwing exception.
> --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
> Assignee: 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)
