Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop Hortonworks TDCH - Queryband option

Solved Go to solution
Highlighted

Sqoop Hortonworks TDCH - Queryband option

Hi,

What is the syntax to use the queryband option with TDCH?

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.6/bk_HortonworksConnectorForTeradata/content/...

I tried a lot of -D syntax combinations without any luck...

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sqoop Hortonworks TDCH - Queryband option

Rising Star

Teradata connector specific options have to be delineated from the sqoop options with --

So you would add -- --queryband ...

4 REPLIES 4

Re: Sqoop Hortonworks TDCH - Queryband option

Super Guru

@Pierre Villard

Did you try --queryband

or try something like below (notice a dash):

--query-band DC=BP\?

Re: Sqoop Hortonworks TDCH - Queryband option

Yes I did try the two options but if I do that this is interpreted as a Sqoop parameter and not as a parameter of the Teradata connector and the Sqoop command fails. In the documentation, it is recommended to use -Dteradata.db.input.* for import parameters and -Dteradata.db.output.* for export parameters, but no indication for the common parameters described at the end of the documentation.

Re: Sqoop Hortonworks TDCH - Queryband option

Rising Star

Teradata connector specific options have to be delineated from the sqoop options with --

So you would add -- --queryband ...

Re: Sqoop Hortonworks TDCH - Queryband option

Thanks a lot! It works like a charm.

Don't have an account?
Coming from Hortonworks? Activate your account here