question Re: Generic SqlManager.listDatabases() not implemented. in Archives of Support Questions (Read Only)

Generic SqlManager.listDatabases() not implemented.

JeevaKrish — Tue, 28 Feb 2017 23:38:17 GMT

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.

aervits — Wed, 01 Mar 2017 09:31:33 GMT

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.