JSONEXTRACTSCALAR(jsonField, 'jsonPath', 'resultsType', [defaultValue])
jsonField
'jsonPath'
'results_type'
INT, LONG, FLOAT, DOUBLE, BOOLEAN, TIMESTAMP, STRING,
INT_ARRAY, LONG_ARRAY, FLOAT_ARRAY, DOUBLE_ARRAY, STRING_ARRAY
.
'jsonPath'
and`` ``
'results_type'
are literals. Pinot uses single quotes to distinguish them from identifiers.WHERE id = 7044874109
:JSONEXTRACTSCALAR
function: