sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fero Szabo <f...@cloudera.com>
Subject Re: --schema option in connection to DB2 database.
Date Wed, 25 Apr 2018 12:49:01 GMT
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>
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>
> 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
>>
>> 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>
------------------------------

Mime
View raw message