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

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

The Spark SQL connector supports predicate pushdown.

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       |
+------+------------+