We have external hive table created on orc file format. The data from Hive need to loaded into Teradata table in a nightly batch.
Please suggest some methods to the same
You can insert-select from hive to teradata via foreign erver if you have QueryGrid 2.0x.
If you don't have it, searching this keyword "Teradata Connector for Hadoop (TDCH)" or "QueryGrid" may help you.
CREATE FOREIGN SERVER hive_fs USING LINK(‘td_hive’) DO IMPORT WITH TD_SYSFNLIB.QGInitiatorImport, DO EXPORT WITH TD_SYSFNLIB.QGInitiatorExport ;
insert into td_db.td_table select * from hive_table@hive_fs ;
TDCH is the JDBC option
https://cwiki.apache.org/confluence/display/Hive/TeradataBinarySerde is the TPT option