Re: Data Import via Sqoop from Postgresql to HDFS

2013-07-22 Thread Fatih Haltas
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 jar...@apache.orgwrote: Hi Fatih, The list-database tool seems to be working with only one schema at the time. You can specify extra

Re: Data Import via Sqoop from Postgresql to HDFS

2013-07-22 Thread Fatih Haltas
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 fatih.hal...@nyu.edu wrote: Hi Jarek, Thanks for your help. But I am using sqoop 1.4.3 but --schema

Re: Data Import via Sqoop from Postgresql to HDFS

2013-07-22 Thread Jarek Jarcec Cecho
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

Data Import via Sqoop from Postgresql to HDFS

2013-07-21 Thread Fatih Haltas
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