How it works...

We can see that a JSON data type can be used in the same way as any other datatype in Teradata Database. This feature brings power of Information of Things (IoT) into Teradata Database with ease.

We can perform the following DML operations with the JSON datatype defined in a table:

• INSERT
• INSERT-SELECT
• MERGE
• UPDATE (UPSERT)

Moreover, if you try to insert the following row in an existing JSON table, it will return a duplicate error:

If a SET table has a JSON column defined, the JSON column is not used in the determination of uniqueness of the row or table. For that reason, all other columns in a row are equivalent to another row; the two rows are deemed equivalent.