[GitHub] [pinot] richardstartin commented on issue #7842: feature request: `LIKE` operator in `JSON_MATCH`

[GitBox <gi...@apache.org>]

richardstartin commented on issue #7842:
URL: https://github.com/apache/pinot/issues/7842#issuecomment-982651511


   Hi @Eywek how slow is "very slow"? 
   
   Is there a natural way for you to filter the JSON documents before applying the `JSONEXTRACTSCALAR` and `REGEXP_LIKE` functions? Without an index structured to support these functions, they are naturally quite expensive.
   
   Have you considered extracting `$.demande_intention` into a text column during ingestion so you can create a text index on it, instead of storing it embedded in JSON?


-- 
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-unsubscribe@pinot.apache.org

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