sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Kjeldstrøm Hansen <...@contentor.dk>
Subject RE: --schema option in connection to DB2 database.
Date Wed, 25 Apr 2018 12:52:27 GMT
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
dan@contentor.dk

CONTENTOR APS
www.contentor.dk
Kochsgade 31C, 1., DK-5000 Odense C
Tangmosevej 83, DK-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 <fero@cloudera.com>
Sent: Wednesday, April 25, 2018 2:49:01 PM
To: user@sqoop.apache.org
Subject: Re: --schema option in connection to DB2 database.

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 <greg.lindholm@gmail.com<mailto:greg.lindholm@gmail.com>>
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 <dan@contentor.dk<mailto:dan@contentor.dk>>
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
dan@contentor.dk<mailto:dan@contentor.dk>

CONTENTOR APS
www.contentor.dk<http://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<tel:+361+701+1201>
cloudera.com<https://www.cloudera.com>

[Cloudera]<https://www.cloudera.com/>



[Cloudera on Twitter]<https://twitter.com/cloudera>     [Cloudera on Facebook] <https://www.facebook.com/cloudera>
     [Cloudera on LinkedIn] <https://www.linkedin.com/company/cloudera>





________________________________


Mime
View raw message