jackluo923 opened a new issue, #10360: URL: https://github.com/apache/pinot/issues/10360
In the official Pinot documentation's JSON index [page](https://docs.pinot.apache.org/basics/indexing/json-index#value), the example hints that the boolean expression's right hand side can be either a STRING type (`'"<json path>"=''<string>'''`), INT type (`'"<json path>"=<int>'`) and FLOAT type (`'"<json path>":<float>'`). In reality, Pinot does not differentiate data type inside `JSON_MATCH` filter. Take the following table content as an example: ``` ---------------- | JSON_COL | ---------------- | {"key": 1} | ---------------- | {"key": "1"} | ---------------- ``` The following query would match **both** rows above: ``` SELECT * FROM TABLE WHERE CLP_MATCH("JSON_COL", '"$.key"=''1''') ``` If the JSON_MATCH filter applies type-specific filter, then we only expect `{"key": "1"}` to be returned. **Is this a bug or a feature?** Can we expect this behavior to stay as-is for the foreseeable future? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
