Sqoop Hortonworks TDCH - Queryband option

[#1]

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!

[#2]

@Pierre Villard

Did you try --queryband

or try something like below (notice a dash):

--query-band DC=BP\?

[#3]

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.

[#4 · Accepted solution]

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

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

[#5]

Thanks a lot! It works like a charm.