Nondeterministic Queries | CREATE FOREIGN TABLE | Teradata Vantage - Queries on External Data are Nondeterministic - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qtb1554762060450.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

When you create a foreign table or use READ_NOS to read directly from external object storage, you must specify a key prefix as part of the USING...LOCATION parameter to identify specific data (one or more files that match the key prefix). However, the actual data queried in the external storage that correspond to the key prefix is determined when you make a foreign table query. Because data may be added or deleted to the external storage system at any time, identical queries against external storage may yield different results.