2.10 - Table Operators and Function - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

QGInitiatorImport

QGInitiatorImport is the initiator import function that is invoked when the query is initiated from Teradata and needs to access metadata and fetch data from a remote host. This initiator import connector function is used to import data from any remote host.

QGInitiatorExport

QGInitiatorExport is the initiator export function that is invoked when the query is initiated from Teradata to access metadata and export data to a remote host. This initiator export connector function is used to export data to any remote host.

Example: Using QGInitiatorImport and QGInitiatorExport

CREATE FOREIGN SERVER Presto_1
USING
 LINK(‘QG_presto1’)
DO IMPORT WITH TD_SYSFNLIB.QGInitiatorImport,
DO EXPORT WITH TD_SYSFNLIB.QGInitiatorExport;

QGRemoteImport

QGRemoteImport is the remote import function that is invoked when the query is initiated by a remote host to transfer data to the local Teradata system. This remote import function is used for data transfer from any remote data source.

QGRemoteExport

QGRemoteExport is the remote export function that is invoked when the query is initiated by a remote host to access data from the local Teradata system. This remote import function is used to export data to any remote host.

QGExecuteForeignQuery

QGExecuteForeignQuery is the function that is invoked when a stored procedure is invoked to execute a DDL or DML request on the remote system. This allows you to execute CREATE TABLE, DROP TABLE, GRANTs, and so on, from a local Teradata system on the remote host.

Example: Using QGExecuteForeignQuery

CREATE FOREIGN SERVER presto_efssp
USING
 LINK(‘QG_presto1’)
DO IMPORT WITH TD_SYSFNLIB.QGExecuteForeignQuery;