Changes/Additions | Data Definition Language | Teradata Vantage - 17.10 - 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.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
Date Description
July 2021

New Statement: ALTER FOREIGN TABLE

Support for Named JSON Arrays

Updated JSON External Files.

Error Tables for Foreign Tables

Updated CREATE FOREIGN TABLE.

Google Cloud Authorizations for Foreign Tables

Added Example: Creating a Google Cloud Authorization.

Fallback Subtables Not Compressed by Default

FAST MODE for ALTER TABLE Statement

Updated ALTER TABLE.

Azure LOCATION Syntax for NOS

AUTHORIZATION for READ_NOS

Updated CREATE AUTHORIZATION and REPLACE AUTHORIZATION.

USING Clause for CREATE AUTHORIZATION

Updated CREATE AUTHORIZATION and REPLACE AUTHORIZATION.

INVOKER and DEFINER, which appear in the syntax of the following statements, are deprecated for NOS:
Miscellaneous Changes
17.05 syntax is deprecated (supported but not recommended).
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 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 . 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.