Xiang Fu
Ming Liang
03/04/2021, 12:38 AMSELECT jsonExtractScalar(mapDim2json, '$.non-existing-key', 'INT') FROM FeatureTest1 WHERE bytesDimSV1 = 'deed0507' AND jsonExtractKey(mapDim2json, '$.*') in ('$[non-existing-key]')
Ming Liang
03/04/2021, 12:39 AMSELECT jsonExtractScalar(mapDim2json, '$.non-existing-key', 'INT') FROM FeatureTest1 WHERE bytesDimSV1 = 'deed0507' AND jsonExtractKey(mapDim2json, '$.*') in ('$[\'non-existing-key\']')
Xiang Fu
Xiang Fu
Xiang Fu
Jackie
03/04/2021, 2:44 AMMing Liang
03/04/2021, 5:43 AMMing Liang
03/04/2021, 5:43 AM