Example: JSONExtractValue with NULL Results

Teradata Vantage™ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

This example shows the JSONExtractValue method returning NULL results. This query gets the job associated with each person.

JSONExtractLargeValue can be substituted for JSONExtractValue.
SELECT eno, edata.JSONExtractValue('$..job')
FROM my_table
ORDER BY 1;

Result:

ENO edata.JSONExtractValue(…)
---------------------------------
1   programmer
2   ?
3   CPA
4   small business owner