Example: Use JOIN INDEX with a JSON Entity Reference

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 shows how to use JOIN INDEX with portions of a JSON instance specified in a JSON Entity Reference.
CREATE JOIN INDEX json_table_ji AS
 SELECT j.name AS Name, 
   j.age AS Age 
 FROM json_table;