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.
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 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
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 wrote:
> Hi Jarek,
>
> Thanks for your help. But I am using sqoop 1.4.3 but --schema version did
> not
Hi Fatih,
the --schema extra parameter was added in 1.4.3 via SQOOP-601. It's however
extra parameter and not a normal Sqoop parameter. As a result it needs to be
specified in the extra argument section of the command line. For example:
sqoop list-tables --connect ... -- --schema private_schem