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.
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).
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.