|September 2020||Amazon S3 paths have been changed to virtual-hosted style paths.|
UDF Search Path
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.
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.
Function Mapping Variable Substitution
Function Mapping for Native Functions
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.