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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Date Description
September 2020 Amazon S3 paths have been changed to virtual-hosted style paths.
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 MODE = m and REPLACE QUERY LOGGING MODE=m.