Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Guru
Created on 05-12-2016 02:00 AM
Using Sqoop (Sql from/to Hadoop), you can use a password file instead of a plaintext password, which is more secure :
<arg>--password-file</arg> <arg>hdfs://NAMENODE/teradata.password</arg>
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 15.00.00.20] [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 0000011
You’ll have to delete your newline control character using tr :
[root@localhost ~]# tr -d '\n' < teradata.password > teradata.password.new [root@localhost ~]# od -c teradata.password.new 0000000 P a s s w o r d 0000010
1,992 Views
Comments
New Contributor
Created on 05-12-2016 10:44 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Nice post @Laurent Edel we can also use $ echo -n "password" > teredata.password