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?)
# Example commands: sqoop list-tables --connect $CONN --username $USER --password $PASS -- --schema DB2INST2 sqoop import-all-tables --connect $CONN --username $USER --password $PASS -- --schema DB2INST2 I can't comment on when it will be released by Cloudera, though I can say that it will be in our next major release. Best Regards, Fero On Wed, Apr 25, 2018 at 2:26 PM, Greg Lindholm <[email protected]> wrote: > 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". > > > /Greg > > On Tue, Apr 24, 2018 at 11:02 AM, Dan Kjeldstrøm Hansen <[email protected]> > wrote: > >> Hi >> >> >> >> As I understand, the –schema option will be/is part of version 1.4.7 >> >> >> >> I the correct? I’ve looked through the documentation for 1.4.7 but this >> option isn’t mentioned here... >> >> >> >> The reason I ask, is that I use DB2 extensively and this particular >> option is very much needed for me in order to filter out tables for >> import/export, så I just wanted to be sure. >> >> >> >> Unfortunately our Cloudera platform currently only uses 1.4.6, and I >> don’t know when Cloudera will include version 1.4.7, but if my >> understanding is indeed correct, I will be looking forward to it. >> >> >> >> Med venlig hilsen / Best regards / Mit freundlichen Grüßen >> >> DAN KJELDSTRØM HANSEN >> Data Engineer >> Big Data & Hadoop Specialist >> >> M +45 21464152 >> [email protected] >> >> CONTENTOR APS >> www.contentor.dk >> Kochsgade 31C >> <https://maps.google.com/?q=Kochsgade+31C&entry=gmail&source=g>, 1., >> DK-5000 Odense C >> Tangmosevej 83, DK-4600 Køge >> <https://maps.google.com/?q=Tangmosevej+83,+DK-4600+K%C3%B8ge&entry=gmail&source=g> >> Innovation Cafe, A. Briána Street 9A, 228 LV1046 Riga Latvia >> Dalakrókur, FO-100 Tórshavn, Faroe Islands >> >> >> > > -- *Ferenc Szabo* | Software Engineer t. (+361) 701 1201 <+361+701+1201> cloudera.com <https://www.cloudera.com> [image: Cloudera] <https://www.cloudera.com/> [image: Cloudera on Twitter] <https://twitter.com/cloudera> [image: Cloudera on Facebook] <https://www.facebook.com/cloudera> [image: Cloudera on LinkedIn] <https://www.linkedin.com/company/cloudera> ------------------------------
