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".

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

2018-04-25 Thread Dan Kjeldstrøm Hansen
Thanks  it is for the import-all-tables tool. Med venlig hilsen / Best regards / Mit freundlichen Grüßen DAN KJELDSTRØM HANSEN Data Engineer Big Data & Hadoop Specialist M +45 21464152 d...@contentor.dk CONTENTOR APS www.contentor.dk Kochsgade 31C, 1., DK-5000 Odense C Tangmosevej 83, DK-4600

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?) #