Changes & Additions | SQL Operators & User-Defined Functions | Teradata Vantage - Changes and Additions - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
fsi1592016213432.ditamap
dita:ditavalPath
fsi1592016213432.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™
Date Description
April 2023 Setting Memory Limits

Added more information and a full example: Setting Memory Limits

July 2021
  • Added new examples to show the LOCAL line in the PopulateFsysInfoTable mactro output.
  • Added AUTHORIZATION syntax element to READ_NOS.
  • Added READNOS_SCHEMA option to RETURNTYPE syntax element of READ_NOS.
  • Added Google Native Connector support to READ_NOS.
  • Fallback subtables are no longer compressed by default.
  • Updated Azure LOCATION syntax.
  • Updated WRITE_NOS ACCESS_ID and ACCESS_KEY information.
June 2020
  • Updated the Installation of R Components and Packages under R Table Operator to support the R in-database distribution.
  • Updated Setting Memory Limits under SCRIPT to show the steps to configure the ScriptMemLimit field in GDO to limit available memory.
  • Added READ_NOS table operator, which allows access to external files in JSON or CSV format.