16.20 - Changes and Additions - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product

Teradata Database

Teradata Vantage NewSQL Engine

Release Number

16.20

Published

March 2019

Language

English (United States)

Last Update

2019-05-24

dita:mapPath

wkf1512081455740.ditamap

dita:ditavalPath

TD_DBS_16_20_Update1.ditaval

Date	Description
March 2019	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 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.
April 2018	Function Mapping (Alias Mechanism for Foreign Functions) Added CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING, DROP FUNCTION MAPPING, and SHOW FUNCTION MAPPING. Added Example: SHOW for a SELECT Request with a Function Mapping. Updated BEGIN LOGGING and Object for which to Log Access to add the FUNCTION MAPPING option. Updated END LOGGING and ON object Clause to add the FUNCTION MAPPING option. Always Fallback Updated CREATE TABLE FALLBACK option, CREATE TABLE (Queue Table Form) FALLBACK option, ALTER TABLE FALLBACK option, CREATE JOIN INDEX FALLBACK option, CREATE HASH INDEX FALLBACK option, CREATE DATABASE FALLBACK PROTECTION option, MODIFY DATABASE FALLBACK option, CREATE USER FALLBACK option, and MODIFY USER FALLBACK option. Flush Object Use Count Updated FLUSH QUERY LOGGING flush_option to add USECOUNT option. SET TRANSFORM GROUP Support for CDTs Added SET TRANSFORM GROUP FOR TYPE.
November 2017	CSV Format for DATASET Data Type Updated the data types syntax diagrams for the following statements to add CSV format to DATASET data type: CREATE TABLE, CREATE TABLE (Queue Table Form), ALTER TABLE, CREATE PROCEDURE and REPLACE PROCEDURE (External Form), CREATE PROCEDURE and REPLACE PROCEDURE (SQL Form), CREATE FUNCTION and REPLACE FUNCTION (SQL Form), CREATE FUNCTION and REPLACE FUNCTION (Table Form), CREATE FUNCTION and REPLACE FUNCTION (External Form), ALTER FUNCTION, and Data Types Syntax.

Date

Description

March 2019

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 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.

April 2018

Function Mapping (Alias Mechanism for Foreign Functions)

Added CREATE FUNCTION MAPPING and REPLACE FUNCTION MAPPING, DROP FUNCTION MAPPING, and SHOW FUNCTION MAPPING.

Added Example: SHOW for a SELECT Request with a Function Mapping.

Updated BEGIN LOGGING and Object for which to Log Access to add the FUNCTION MAPPING option. Updated END LOGGING and ON object Clause to add the FUNCTION MAPPING option.

Always Fallback

Updated CREATE TABLE FALLBACK option, CREATE TABLE (Queue Table Form) FALLBACK option, ALTER TABLE FALLBACK option, CREATE JOIN INDEX FALLBACK option, CREATE HASH INDEX FALLBACK option, CREATE DATABASE FALLBACK PROTECTION option, MODIFY DATABASE FALLBACK option, CREATE USER FALLBACK option, and MODIFY USER FALLBACK option.

Flush Object Use Count

Updated FLUSH QUERY LOGGING flush_option to add USECOUNT option.

SET TRANSFORM GROUP Support for CDTs

Added SET TRANSFORM GROUP FOR TYPE.

November 2017

CSV Format for DATASET Data Type

Updated the data types syntax diagrams for the following statements to add CSV format to DATASET data type: CREATE TABLE, CREATE TABLE (Queue Table Form), ALTER TABLE, CREATE PROCEDURE and REPLACE PROCEDURE (External Form), CREATE PROCEDURE and REPLACE PROCEDURE (SQL Form), CREATE FUNCTION and REPLACE FUNCTION (SQL Form), CREATE FUNCTION and REPLACE FUNCTION (Table Form), CREATE FUNCTION and REPLACE FUNCTION (External Form), ALTER FUNCTION, and Data Types Syntax.