sqoop stuck at No connection paramenters specified. Using regular API for making connection.

[#1]

Hi,

I am trying to run this import command:

sqoop import --connect jdbc:postgresql://[host]:[port]/[db] --username [user] --password-file [path_to_pass] -table [table] --hive-import -hive-drop-import-delims --as-parquetfile --parquet-configurator-implementation hadoop --hive-table district_startdates_test --target-dir [target_with_db] -m 1 --hs2-url="jdbc:hive2://[cdp]/;ssl=true;transportMode=http;httpPath=[path_to_proxy];user=[user];password=[cluster_passw]" --verbose

but it gets stuck at  

 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.

...any idea?

thanks

[#2 · Accepted solution]

Hi @mszurap , 

thanks for the tool

So, somehow the connection is now working , namely the command we tried to cloudera support, like:

`sqoop eval --connect ...`

or

 ` sqoop list-databases --connect` 

before running any sqoop command, we set up a ssh tunnel, with 

ssh -o ServerAliveInterval=60 -M -S mktemp -fN -L local_port:psql_fqdn:remote_p  user@host_IP 

(which I was doing also before, so not sure why now it works... 

I will mark it now as solved

thanks anyway,

Gr