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-unsubscr...@pinot.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
