Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Data Import via Sqoop from Postgresql to HDFS

Copy link to this message
Re: Data Import via Sqoop from Postgresql to HDFS
Hi Fatih,
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://
> --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?
> Thanks.