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 arguments. You might be interested in taking a look into Apache Sqoop Cookbook [1] where 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? > > > > 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. > >> > > > >
signature.asc
Description: Digital signature
