All Forums Hadoop
ehbhaskar 2 posts Joined 06/15
07 Aug 2015
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

RyanBerti 5 posts Joined 07/13
12 Aug 2015

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

kmccarty 2 posts Joined 02/16
16 Jun 2016

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.

You must sign in to leave a comment.