Rules and Restrictions - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
des1556232910526.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢
These rules are for the Avro schema.

The two values passed into this function must be valid Avro schemas.

The SchemaEqual function imposes a more strict set of rules than SchemaMatch. To be equal, one of the following must occur:
  • Both schemas are arrays whose item types are equivalent (recursively determined if not primitive types).
  • Both schemas are maps whose value types are equivalent (recursively determined if not primitive types).
  • Both schemas are enums whose names or symbols match.
  • Both schemas are fixed with sizes and names that match.
  • Both schemas are records with the same name.

    Fields of both records must be declared in the same order, have the same names, and the same data types (recursively determined if not primitive types).

  • Both schemas are unions whose possible schema types are equivalent (recursively determined if not primitive types).
  • Both schemas have the same primitive type.
A schema's "doc" fields are ignored for the purposes of schema equivalence evaluation.