2.06 - INSERT Syntax for the Spark SQL Initiator Connector - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty

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

Example: Using INSERT with Spark SQL as the Initiator Connector

scala> ForeignServer.sql("insert into default.nn1 values (8, 'user1')")
scala> ForeignServer.sql("insert into default.nn1 select * from players2")