16.20 - Changes and Additions - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product: Teradata Database; Teradata Vantage NewSQL Engine
Release Number: 16.20
Published: March 2019
Language: English (United States)
Last Update: 2019-05-03
dita:mapPath: zzu1512081120577.ditamap
dita:ditavalPath: TD_DBS_16_20_Update1.ditaval

Date	Description

March 2019	Added: AutoColumn added to ColumnsV[X] for JSON Auto Composition and Shredding feature. RowVersionNo added to ColumnsV[X]. IncrementalRestoreEnabled added to DatabasesV[X] and TablesV[X] for the incremental restore feature. DefaultDBCacheUsed and StepCacheHash added to QryLogV. FastAlterTable added to TablesV[X]. AvgRowSize added to TempTableStatsV, StatsV, and TableStatsV. TimeZoneHour and TimeZoneMinute added to UsersV. FunctionAliasType added to FunctionAliasV[X].
April 2018	Added: ReqAWTTime, MaxReqAwtTime, MinReqAWTTime, MaxReqAWTTimeAmpNum to QryLogV. AWTTime, MaxAWTTime, MinAWTTime, MaxAWTTimeAmpNum to QryLogStepsV. FunctionAliasInfoV[X] and FunctionAliasV[X] StmtDMLRowCount\| to QryLogV. Updated: ServerInfoV[X] and TableKind Column. JournalFlag in Usage Notes. Updated description for Grantee and GranteeKind. See Usage Notes. Also see Overview for information about which views are documented in this document. Additional values added to Possible Values for CacheFlag. See Usage Notes.
November 2017	Added: DBC.QryLogV.TDWMMSRCount CSV format added to DBC.ColumnsV[X].StorageFormat and DBC.DatasetSchemaInfoV.StorageFormat To support Bulk Qualification enhancements, the following column has been added: DBC.QryLogStepsV.InMemBulkQualStatus To support Time Series the following columns have been added: DBC.TablesV[X].TVMFlavor, DBC.ColumnsV[X].TSColumnType, DBC.IndicesV[X].TimeZero, DBC.IndicesV[X].TimeBucketUnit, DBC.IndicesV[X].TimeBucketValue, DBC.IndicesV[X].TSFlags Updated: System Calendar View