Changes/Additions | Data Definition Language | Teradata Vantage - Changes and Additions - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
Date Description
January 2021
June 2020

UDF Search Path

Added SET SESSION UDFSEARCHPATH

Native Object Store

Added CREATE FOREIGN TABLE, including syntax, options, usage notes, and examples. Updated DROP TABLE to add the FOREIGN keyword. Updated COLLECT STATISTICS (Optimizer Form) to add Example: Collecting Statistics on a Foreign Table Column. Added Example: SHOW TABLE for a Foreign Table. Updated CREATE AUTHORIZATION and REPLACE AUTHORIZATION to include the USING clause, where you can specify security parameters for accessing remote repositories. Updated CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING to add the EXTERNAL SECURITY clause and Example: Function Mapping for READ_NOS. Updated CREATE storage_format SCHEMA to add Example: Schema for DATASET Type with CSV Storage Format.

Incremental Restore

Added LOGGING INCREMENTAL ARCHIVE ON FOR object_list, LOGGING INCREMENTAL ARCHIVE OFF FOR object_list, and INCREMENTAL RESTORE ALLOW WRITE FOR object_list.

JSON Auto Composition and Shredding

Updated CREATE TABLE and CREATE TABLE … AS column attributes to add the AUTO COLUMN option. Added AUTO COLUMN and Examples: Creating a Table with a JSON Auto Column.

Updated ALTER TABLE column attributes to add the AUTO COLUMN option. Added AUTO COLUMN and Examples: Adding and Removing the JSON Auto Column Option.

Added Example: HELP COLUMN for a JSON Column with the Auto Column Option and Example: HELP TABLE with a JSON Auto Column. Added Example: SHOW TABLE with an Auto Column.

Function Mapping Variable Substitution

Updated CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING.

Function Mapping for Native Functions

Updated CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING.

Algorithm 3 is the new default mode for DBQL Logging

The Database Query Log (DBQL) is enhanced for Advanced SQL Engine 17.00 with more complete and accurate logging. DBQL now uses Algorithm 3 by default, which includes collecting statistics on aborted and parallel steps, and results in more accurate resource usage statistics. Upgraded systems that were not previously using Algorithm 3 will not use Algorithm 3 until explicitly configured to do so. See BEGIN QUERY LOGGING m and REPLACE QUERY LOGGING m.