The example shows how to create a JOIN INDEX with portions of a JSON instance specified using JSON dot notation.
CREATE JOIN INDEX json_table_ji AS SELECT j.name AS Name, j.age AS Age FROM json_table;