2.10 - SELECT 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

Spark SQL SELECT queries with Spark SQL as the initiator are used to import data from a target data source into Spark SQL.

Example: Using SELECT with Spark SQL as the Initiator Connector

scala> ForeignServer.sql("select * from default.nn1")
+------+------------+
|number|name        |
+------+------------+
|9     |user1       |
|10    |user2       |
|11    |user3       |
+------+------------+