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.
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
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.