Storing Non-Scalar Data

• Does not support indexing of whole JSON fields

• Indexing of JSON fields are done through generated columns

• Can't index multi-value JSON fields (arrays)

Create virtual column:



ALTER TABLE whisky ADD COLUMN abv FLOAT *GENERATED ALWAYS AS (properties->"$.abv");*

Create index:



CREATE INDEX abv_idx ON whisky (abv);