sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rakesh Sharma (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-2534) --password-file option doesn't work Teradata jdbc driver
Date Mon, 07 Sep 2015 08:13:45 GMT

     [ 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)

Mime
View raw message