These enhancements were added:
Support for Virtual Columns in Foreign Tables
The PARTITION BY clause of CREATE FOREIGN TABLE now supports virtual columns for CSV, JSON, and Parquet table locations. The new MODIFY PARTITION BY clause of ALTER FOREIGN TABLE alters foreign table partitioning. SELECT and COLLECT STATISTICS support virtual columns. HELP TABLE and SHOW TABLE output identifies virtual columns. See:
- Teradata Vantage™ - SQL Data Definition Language Syntax and Examples
- Teradata Vantage™ - SQL Data Manipulation Language
- Teradata Vantage™ - SQL Operators and User-Defined Functions
WRITE_NOS Enhancement
Subquery in WRITE_NOS can include expression that generates destination path name to reference in PARTITION BY clause. See:
- Teradata Vantage™ - SQL Data Manipulation Language
- Teradata Vantage™ - SQL Operators and User-Defined Functions