Can the TDCH be used to load data into view (in teradata)

Hadoop
Enthusiast

Can the TDCH be used to load data into view (in teradata)

I was trying use TDCH connector to load the data from Hive table to Teradata table. But, I want to load the data into the targt table (in teradata) via VIEW instead of accessing the table directly. 

So, is there a way to load the data to target table through the VIEW?

There is an option called "tdch.output.teradata.data.dictionary.use.xview" but setting this option to true didn't help we either. i couldn't get much info.. in the use of this option (dch.output.teradata.data.dictionary.use.xview), so, I'm just curious what's the use of this option?

Below is a sample TDCH job I was using.

hadoop jar $TDCH_JAR \

com.teradata.connector.common.tool.ConnectorExportTool \

-Dmapred.job.queue.name=<queuename> \

-libjars $HIVE_LIB_JARS \

-classname com.teradata.jdbc.TeraDriver \

-url jdbc:teradata://<IPadress>/ \

-username xxxxx \

-password xxxxx \

-jobtype hive \

-fileformat textfile \

-nummappers 10 \

-method internal.fastload \

-separator "\u0009" \

-sourcedatabase <database> \

-sourcetable <table> \

-sourcefieldnames "<all the columns>" \

-targettable <target table> \

-targetfieldnames "<all the target columns>" \

-stagedatabase <stage database> \

-forcestage true

Tags (2)
2 REPLIES
Teradata Employee

Re: Can the TDCH be used to load data into view (in teradata)

Hi,

Please see the TDCH README for a description of the 'tdch.output.teradata.data.dictionary.use.xview' property.

You cannot use TDCH's internal.fastload method to load TD views; please try using batch.insert. See this stackoverflow response for more info (http://stackoverflow.com/questions/31887272/writing-data-through-view-using-tdch).

Thanks

Ryan

Re: Can the TDCH be used to load data into view (in teradata)

Which TDCH README are you reading?  The only one I can find is the Teradata Connector for Hadoop Tutorial v 1.0 which has nothing of which you speak.