load teradata tales from hive external tables

Hadoop

load teradata tales from hive external tables

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

2 REPLIES
Highlighted
Teradata Employee

Re: load teradata tales from hive external tables

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.

https://www.info.teradata.com/doclist.cfm?Suite=107&Categ=123&Prod=1101&ProdName=QueryGrid&RelName=2...

 

eg)

 

 

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
;

 

 

Enthusiast

Re: load teradata tales from hive external tables