Example: Use COLLECT STATISTICS with JSONExtractValue

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
The example uses COLLECT STATISTICS with portions of a JSON instance extracted by JSONExtractValue.
COLLECT STATISTICS COLUMN j.JSONExtractValue('$.name') AS name_stats ON json_table;