15.10 - About JSON Type Ordering - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

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.