Community Articles

Find and share helpful community-sourced technical articles.
Labels (1)

Using Sqoop (Sql from/to Hadoop), you can use a password file instead of a plaintext password, which is more secure :


You may end with error like

3737 [main] ERROR org.apache.sqoop.teradata.TeradataSqoopExportHelper  - Exception running Teradata export job
com.teradata.connector.common.exception.ConnectorException: java.sql.SQLException: [Teradata Database] [TeraJDBC] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid. 

If you set your “Password” pass with vi you’ll end with a line feed control character, making the password invalid.

To find if there’s a LF ending the password file, use od (display file in octal format):

[root@localhost ~]# od -c teradata.password 
0000000    P   a   s   s   w   o   r   d  \n 

You’ll have to delete your newline control character using tr :

[root@localhost ~]# tr -d '\n' < teradata.password > 
[root@localhost ~]# od -c 
0000000    P   a   s   s   w   o   r   d 
Not applicable

Nice post @Laurent Edel we can also use $ echo -n "password" > teredata.password

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎05-12-2016 02:00 AM
Updated by:
Top Kudoed Authors