You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2021/04/08 07:46:06 UTC

[GitHub] [incubator-pinot] Jackie-Jiang commented on issue #6752: Enhancing JSON index to provide free text search on string value space

Jackie-Jiang commented on issue #6752:
URL: https://github.com/apache/incubator-pinot/issues/6752#issuecomment-815534588


   Json index only supports exact match. In order to do text match, you need to use `jsonExtractScalar`, e.g. `select ... where jsonExtractScalar(json_col, '$.message', 'STRING') like 'too.*'. The performance might not be very good because we have to scan and reconstruct the json from the json string.
   You can add text index on the json string column, but that will treat the json string as regular string.
   For the example above, extracting `message` field as a separate column will give much better performance.


-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org