Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
Received-SPF: error (athena.apache.org: local policy)
Date: Mon, 22 Jul 2013 07:50:06 -0700
From: Jarek Jarcec Cecho <jarcec@apache.org>
To: user@sqoop.apache.org
Cc: "user@hadoop.apache.org" <user@hadoop.apache.org>
Subject: Re: Data Import via Sqoop from Postgresql to HDFS
Message-ID: <20130722145005.GK15412@localhost>
References: 
 <CAMe0HzR7W=o8EqPdt2mzY61+vKsHsB-+EB2-oq2k+cB6CgPG_Q@mail.gmail.com>
 <20130721145409.GA4846@localhost>
 <CAMe0HzSXC0KzmXKiT_-wUFLcg8PUJq854xA4GN18aDqOHTcTBw@mail.gmail.com>
 <CAMe0HzT_UdZ8_HYqOsY_bBxJ=1wScuT3fUQjEHx5wWHZodzVfw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="q6M0GVIna3Wg/yP0"
Content-Disposition: inline
In-Reply-To: 
 <CAMe0HzT_UdZ8_HYqOsY_bBxJ=1wScuT3fUQjEHx5wWHZodzVfw@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)


--q6M0GVIna3Wg/yP0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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_schema

Please do notice the extra "--" between normal sqoop arguments and extra ar=
guments.

You might be interested in taking a look into Apache Sqoop Cookbook [1] whe=
re all different types of parameters are further described.

Jarcec

Links:
1: http://shop.oreilly.com/product/0636920029519.do

On Mon, Jul 22, 2013 at 01:18:22PM +0400, Fatih Haltas wrote:
> 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?
>=20
>=20
>=20
> On Mon, Jul 22, 2013 at 12:39 PM, Fatih Haltas <fatih.haltas@nyu.edu> wro=
te:
>=20
> > Hi Jarek,
> >
> > Thanks for your help. But I am using sqoop 1.4.3 but --schema version d=
id
> > not work for me.
> >
> >
> > On Sun, Jul 21, 2013 at 6:54 PM, Jarek Jarcec Cecho <jarcec@apache.org>=
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.
> >>
> >
> >

--q6M0GVIna3Wg/yP0
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQIcBAEBAgAGBQJR7UadAAoJEEk45sAabwqG30kQAJhjJy5r7+Go/FQuV6WhaJMc
eD+sMMBO+VP664bigVQCAiwQwCWUbq9+q0EP3GJlcvMsaTzNXsnus6LSNb26Yhil
qZAcPKCrfTtF0sxmS1lUsChhoeWexKd4g3g8g+QhK51bSwwm1knYjuLmEU7UtsvQ
B3qPMHP2BlFoY/p7rJXzeeH8UMkLJ4rTnywiIS6vpkRP7XN0DyW6ufqFh/bnH4x5
sdKXy1mTnd1RIhYrXetvbPvDM22DhhdpI4lPT+D+9F1YWwuqfmf++ucOQfLspWSF
uwVPcPBGA9E1Lx2ubC69ujxyZ+Fkzf6fDiutt7lH8zUzoN6uIz6z3sP7sluUPwUh
Jx4YdiCF5t4fJDLqJA0f75FMsUBQNOMVZTRykfR13vGjhGaelRAEWPMIxZr+C56G
w0IH4NLv8Rwp9cSPF0ICDQCJSFt8P8a4Ch7DepjZa3N2TdH1oFo1eTQzBwe56SuU
566t/W4mHum/co/cWbpGWMB9sgTxYfELZLI71rj6zKcEanBVCbWAZaWKq/sgh70b
Vobnia1lmm34gS02/5e+TAKJSBOOQS+jkv4asd7nmnnyjx5xNJHc36hDX8EvKmHn
I2mZg2kdCXZvV40w9u9a0LvLyu4aEP02gI4npmiunbVQbgCIZTpUC+mlupfw6/EJ
K+6PiH8zUSoLu2gZt4jJ
=yxIB
-----END PGP SIGNATURE-----

--q6M0GVIna3Wg/yP0--