kotharironak opened a new issue #6752:
URL: https://github.com/apache/incubator-pinot/issues/6752
I tried the JSON index support in the latest `apache-pinot-0.7.0`and I
observed that I was not able to do a free text search on `json` value space.
As shown in the below example, I was able to do an equality search as in Q1.
But, I was not able to do the `text_match` kind of search as in Q2.
```
Table = json_doc_example
Example data with 3 rows:
id_col, json_doc_col
"1234", {"message": "too many retries"}
"1235", {"message": "error sql timeout"}
"1236", {"message": "too large filter"}
```
Query Q1: returns -> [1236]
```
select * from json_doc_example JSON_MATCH(json_doc_col, 'message=''too lareg
filter''')
```
Query Q2: returns empty result (was expecting it to return : [1234, 1236])
```
select * from json_doc_example JSON_MATCH(json_doc_col, 'message=''too''')
```
- Can we add similar `text_match` support on `json` value space ? or
- is it recommended to use both text index + json index for such use case on
that column?
--
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.
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
