Retrieve a Dataset Object | Spark SQL Initiator Connector | QueryGrid - getDatasetFromSql - 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
lifecycle
latest
Product Category
Analytical Ecosystem

Use the getDataSetFromSql() method to perform a lazy evaluation of a SELECT query involving non-native tables. For example:

scala> ForeignServer.getDatasetFromSql("select * from default.nn1")
res0: org.apache.spark.sql.Dataset[org.apache.spark.sql.Row] = [number: int, name: string]

The query result DataSet (res0 in the example) is used like any other Spark SQL DataSet object and is only evaluated when an action is called.