2.10 - INSERT Syntax for the Spark SQL Initiator 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 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")