2.10 - INSERT Syntax for the Presto Connector - 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

You can use Presto to export data to a remote system by using an INSERT statement to place data into an existing table. The remote table can be empty or it can contain data. If the remote table already contains data, the exported data is appended to the existing table.

Example: Presto to Teradata INSERT

The example shows an export request initiated on Presto to insert data into a remote Teradata Database table.

INSERT INTO QG_TD1.DB1.TD_CARDATA SELECT * from hive.default.cardata;

QG_TD1 is the catalog used to reference the Presto-to-Teradata link, DB1 is the Teradata Database, and TD_CARDATA is the table to insert to on Teradata Database.