jackluo923 opened a new issue, #10863:
URL: https://github.com/apache/pinot/issues/10863
We've seen many cases where a user wants to search for a substring in a
field with a text index. If all of the tokens in the query are complete words,
we can directly use a phrase search:
`SELECT * FROM table WHERE text_match("col", '"substring match query"')`
However, if the first or last token is a partial word (e.g., `"string match
que"`), the query will not return any results.
To work around the limitation, we can use this a query like this:
`SELECT * FROM table WHERE text_match("col", '".*string" AND match AND
"que*"') AND "col" LIKE "%string match que%"`
But this is very slow and computationally expensive due to the LIKE which is
necessary for validating the order of the tokens.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
