question Re: Sqoop Hortonworks TDCH - Queryband option in Archives of Support Questions (Read Only)

Sqoop Hortonworks TDCH - Queryband option

pvillard — Fri, 26 Aug 2016 23:53:06 GMT

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/ch_HortonworksConnectorForTeradata.html

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

Thanks!

Re: Sqoop Hortonworks TDCH - Queryband option

mqureshi — Sat, 27 Aug 2016 00:00:25 GMT

@Pierre Villard

Did you try --queryband

or try something like below (notice a dash):

--query-band DC=BP\?

Re: Sqoop Hortonworks TDCH - Queryband option

pvillard — Sat, 27 Aug 2016 01:25:12 GMT

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

vranganathan — Fri, 02 Sep 2016 13:33:50 GMT

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

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

Re: Sqoop Hortonworks TDCH - Queryband option

pvillard — Fri, 02 Sep 2016 15:11:17 GMT

Thanks a lot! It works like a charm.