RE: --schema option in connection to DB2 database.

2018-04-25 Thread Dan Kjeldstrøm Hansen
4600 Køge Innovation Cafe, A. Briána Street 9A, 228 LV1046 Riga Latvia Dalakrókur, FO-100 Tórshavn, Faroe Islands From: Fero Szabo <f...@cloudera.com> Sent: Wednesday, April 25, 2018 2:49:01 PM To: user@sqoop.apache.org Subject: Re: --schema option in connect

Re: --schema option in connection to DB2 database.

2018-04-25 Thread Fero Szabo
Hi Dan, Documentation somewhat lagged behind, as it wasn't expected in patches to add it whenever a new feature was implemented. SQOOP 1.4.7 contains the implementation of SQOOP-1905, though it only affects the import-all-tables tool and the list-tables tool. (Which tool are you using?) #

Re: --schema option in connection to DB2 database.

2018-04-25 Thread Greg Lindholm
>From the documentation it appears that the --schema option is only available for PostgreSQL and Microsoft SQL, there is no mention of it for DB2. I've been using Sqoop with DB2 and have not needed this option, you can qualify the table with the schema name like this "--table MYSCHEMA.MYTABLE".