SELECT Statement | Spark SQL Initiator Connector | QueryGrid - SELECT Syntax for the Spark SQL Initiator Connector - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

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