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.