There's more...

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