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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
