create Method | Spark SQL Initiator Connector | QueryGrid - create - 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

You can use the create method to create non-native tables (permanent or temporary) to represent target tables. If the non-native table name is in the form of db.tb1 (default.nn1 in the example), a permanent non-native table is created. If the database is not part of the non-native name, a temporary non-native table is created (nn2 in the example). Temporary tables in Spark SQL only exist during the current session and cannot be associated with a database.

The following example shows the Spark SQL initiator using the CREATE statement to create non-native tables:
scala> s1.create("default.nn1","user1.players")

scala> s1.create("nn2","default.test")