I think the in clause should use single quote
# troubleshooting
x
I think the in clause should use single quote
m
Copy code
SELECT jsonExtractScalar(mapDim2json, '$.non-existing-key', 'INT') FROM FeatureTest1 WHERE bytesDimSV1 = 'deed0507' AND jsonExtractKey(mapDim2json, '$.*') in ('$[non-existing-key]')
or
Copy code
SELECT jsonExtractScalar(mapDim2json, '$.non-existing-key', 'INT') FROM FeatureTest1 WHERE bytesDimSV1 = 'deed0507' AND jsonExtractKey(mapDim2json, '$.*') in ('$[\'non-existing-key\']')
x
right
Pinot uses single quote for literals and double quote for identifiers
j
FYI use two single quotes to skip single quote
m
👍
thankyou