Foreign Server Procedures (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The following table lists the available Foreign Server procedures and summarizes their purpose. It also indicates which host types each function is appropriate for.

Foreign Server Procedures
Function Description
ExecuteForeignSQL

(host type-Teradata)

Executes on a foreign Teradata server basic SQL that does not return data (such as a CREATE or DROP command). The procedure arguments are both strings, query_expression and server_name.

For more information, refer to the Teradata QueryGrid: Teradata Database-to-Teradata Database reference manual, B035-1188.

HCTAS

(host type-Hadoop)

This procedure creates an empty table schema in Hadoop. The procedure arguments are table_name, partition_columns_list, table_definition, foreign_ server_ name and hive_db_name.

For more information, refer to the Teradata QueryGrid: Teradata Database-to-Hadoop reference manual.

HDROP

(host type-Hadoop)

This procedure drops a Hadoop table on a foreign server. The procedure arguments are hive_db_name, hive_table_name and foreign_server_name.

For more information, refer to the Teradata QueryGrid: Teradata Database-to-Hadoop reference manual.