The following are some disadvantages of JSON with the current version of the database. Teradata engineering must be working to resolve these disadvantages:
- GROUP BY, ORDER BY, PARTITION BY, WHERE, ON, SET, DISTINCT, HAVING, QUALIFY, IN, CUBE, GROUPING SETS, or ROLLUP are not allowed with a JSON column.
- Indexes (UPI/NUPI/USI/NUSI) cannot be defined in JSON.
- You can only update the JSON column, not individual portions of the JSON instance.
But the following are the advantages of JSON:
- Can be used to create a join index
- Statistics can be collected on the JSON column
- Functions can be defined using JSON
- ARRAY can be used
