The following table lists the available DATASET methods, and a description of their purpose:
| Method | Description |
|---|---|
| AvroProject | AvroProject allows for reading specified portions of an Avro instance, without having to read the entire instance. |
| AvroProjectToJSON | AvroProjectToJSON is similar to the AvroProject method, but returns a JSON-encoded Avro value instead of an Avro instance as its result. |
| ExtractValue | Some queries on a DATASET instance are not possible using dot notation. These queries might contain a dot notation expression too large to be expressed in Teradata-SQL, or use characters or words not permitted in the syntax. Additionally, some queries have results that are too large to be returned by a dot notation expression. The ExtractValue method is provided for these types of queries. |
| getRawData | getRawData retrieves the raw data of any DATASET data type instance, returning as a non-LOB type. |
| getRawDataLob | getRawDataLob retrieves the raw data of any DATASET data type instance and returns it as a LOB type. |
| getRawDataSize | getRawDataSize retrieves the size of the raw data for any instance of the DATASET data type. |
| getSchema | getSchema retrieves the schema of any instance of the DATASET data type. |
| getSchemaSize | getSchemaSize retrieves the size of the schema for any instance of a DATASET data type. |
| toJSON | toJSON converts any instance of the DATASET data type into a JSON text instance. |
| Validate | Invokes the Validation method on a DATASET type instance to report back whether data is valid. |