15.10 - About JSON Type Ordering - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

Ordering, comparison, or grouping are not allowed on a JSON type, so no default ordering is provided. If a JSON column is used in a SET table, it is not included in the determination of the uniqueness of a row. Therefore, if all other columns in a row are equivalent to another row, the two rows are deemed equivalent.

You cannot use a JSON type in these clauses: GROUP BY, ORDER BY, PARTITION BY, WHERE, ON, SET, DISTINCT, HAVING, QUALIFY, IN, CUBE, GROUPING SETS or ROLLUP.

You can use JSON methods to isolate individual portions of a JSON instance for comparison. You can also cast the JSON type to a predefined type that can have relational comparisons performed on it.