Generic SqlManager.listDatabases() not implemented.

[#1]

Hi there,

I ran sqoop command to list-databases and I am getting error.

This is the sqoop command i ran:

sqoop list-databases --connect jdbc:netezza://xxxxxxxx/ --username xxxx --password xxx;

The error I am getting is :

ERROR manager.SqlManager: Generic SqlManager.listDatabases() not implemented.

For your Information, I added Netezza jar like

export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:<path to the jar>

Please share your knowledge on this. Thanks.

[#2 · Accepted solution]

Netezza list-databases command is not supported, please see the sqoop user guide for special note https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_example_invocations_8

I am curious whether using --direct mode implemented the list-databases option, please try and if you can report back.

Note
This only works with HSQLDB, MySQL and Oracle. When using with Oracle, it is necessary that the user connecting to the database has DBA privileges.