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