-Re: Data Import via Sqoop from Postgresql to HDFS
Jarek Jarcec Cecho 2013-07-21, 14:54
The list-database tool seems to be working with only one schema at the time. You can specify extra argument --schema to specify schema other than the default "public", for example:
sqoop list-tables --connect ... -- --schema private_schema
On Sun, Jul 21, 2013 at 03:18:53PM +0400, Fatih Haltas wrote:
> Hi everyone,
> I had another problem while trying to import or list tables on postgresql
> via sqoop.
> I am using this command
> ./sqoop list-databases --connect jdbc:postgresql://
> 192.168.194.158:5432/pgsql --username pgsql -P
> It does see only the tables under the public schema, other are not listed.
> i tried to change postgresql user settings now, actually is there any
> options to list all tables in my database in sqoop?
> OR I need to struggle with user-rights in postgresql?