Working on JSON predicate pushdown for the Trino-Pinot connector:
contains((1,2,3), json_extract_scalar(json, '$.key`)) -> json_match(json, '$.key in (1,2,3)')
json_array_contains(json_extract(json, '$.array'), value) -> json_match(json, '$.array[*] = value')
json_match uses Pinot's JSON index
12 months ago