topic Re: tsqoopImport issue with postgresql in Talend Studio

tsqoopImport issue with postgresql

Anonymous — Sat, 16 Nov 2024 11:42:57 GMT

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

Re: tsqoopImport issue with postgresql

Anonymous — Wed, 19 Mar 2014 03:28:24 GMT

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

Re: tsqoopImport issue with postgresql

Anonymous — Wed, 19 Mar 2014 10:06:38 GMT

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.