Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tsqoopImport issue with postgresql

Hello,
i want to import a table (country) from postgresql to hdfs using tSqoopImport componant.
I had a error with my tsqoopImport "Ident authentication failed for user "postgres" :
Somebody had a idea ?
Thks for your help.
-----------------------------------------------------------------------------------------------
Starting job testsqoop at 16:08 18/03/2014.
connecting to socket on port 4016
connected
.--+-------+-----------.
| tLogRow_1 |
|=-+-------+----------=|
|id|isocode|countryname|
|=-+-------+----------=|
|1 |LU |Luxembourg |
|2 |FR |France |
|3 |BE |Belgique |
'--+-------+-----------'
: org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
: org.apache.sqoop.ConnFactory - Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory : org.apache.sqoop.

To see the whole post, download it here
Labels (4)
2 Replies
Anonymous
Not applicable
Author

Hi hvuong?
From error log,seems to be that you have no authentication.
If you talend product install not the same as postgreSQL DB Server,you must open remote connect in postgresSQL.
jjzhou
Anonymous
Not applicable
Author

hi jjzhou,
thks for your response.
But i m don't understand because in my job i had a tPostGreSqlConnection and it is ok, i can connect with my database.
I don't understand why my tSqoopImport doesnt work ?
See my screenshot below.
Thks.
0683p000009MD33.png