The following table lists the available Foreign Server procedures and summarizes their purpose. It also indicates which host types each function is appropriate for.
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. |