Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Listing specific schema


+
Fatih Haltas 2013-07-22, 10:00
Copy link to this message
-
Re: Listing specific schema
Hi Fatih,
I've responded on the other thread, but let me respond also here.

The --schema parameter is extra argument specific for given connector (PostgreSQL in this case). It's not a usual Sqoop argument. As a result it needs to be specified in extra argument section of the command line, for example:

  sqoop import --connect ... -- --schema my_schema

Please do notice the extra "--" separating the normal Sqoop arguments and connector specific extra arguments.

Jarcec

On Mon, Jul 22, 2013 at 02:00:14PM +0400, Fatih Haltas wrote:
> Hi everyone,
>
> For couple of days, I am struggling to list/import tables under the
> spesific schema by sqoop but still I could not achieve.
>
> Jarek suggested me to use --schema optionthen I am using the command below
> but sqoop gives the help menu which means I am making a mistake at a point.
>
> Here is the command that I used so far.
>
> sqoop list-tables --connect
> jdbc:postgresql://192.168.194.158:5432/pgsql--username pgsql
> --password XXX  --schema fatih
>
>
> Any help is gonna be apprecatied.
>
> Thanks you all.
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB