DATASET Methods, Functions, and Table Operators | Teradata Vantage - 17.10 - DATASET Methods, Functions, and Table Operators - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1198-171K
Language
English (United States)

You can perform the following common operations on the DATASET data type to access or manipulate DATASET data.

Methods

  • AvroProject
  • AvroProjectToJSON
  • DATASET Constructor
  • ExtractValue
  • getRawData
  • getRawDataLob
  • getRawDataSize
  • getSchema
  • getSchemaSize
  • Header
  • numRecords
  • toAvro
  • toJSON
  • Validate

Functions and Table Operators

  • AVRO_CHECK
  • AvroContainerSplit
  • CreateDATASET
  • CSVSplit
  • CSV_TO_AVRO
  • CSV_TO_JSON
  • DATASET_KEYS
  • DATASET_TABLE
  • DataSize
  • SchemaEqual
  • SchemaMatch