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
Is there any --schema option to be able to list schemas other than public,
because, I am not able to list other tables under non-public schemas?

On Mon, Jul 22, 2013 at 12:39 PM, Fatih Haltas <[EMAIL PROTECTED]> wrote:

> Hi Jarek,
>
> Thanks for your help. But I am using sqoop 1.4.3 but --schema version did
> not work for me.
>
>
> On Sun, Jul 21, 2013 at 6:54 PM, Jarek Jarcec Cecho <[EMAIL PROTECTED]>wrote:
>
>> 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.
>>
>
>