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

Jarcec

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?
>
> Thanks.