Any suggestion for speeding up a query that uses R...
# troubleshootinga
Aaron Wishnick
06/18/2021, 8:58 PMAny suggestion for speeding up a query that uses REGEX_LIKE to filter on a dimension? I see string operations being super slow. Even if I rewrite my regex as
SUBSTR(foo, ..., ...) = barm
Mayank
06/18/2021, 8:58 PM
Have you tried text index?
Mayank
06/18/2021, 8:58 PM
a
Aaron Wishnick
06/18/2021, 8:59 PMDoes it play nice with star tree index?
Aaron Wishnick
06/18/2021, 8:59 PM(To be more precise, I want my query to be accelerated by the use of the star tree index, and I also want to quickly filter by regex for one of the dimensions)
m
Mayank
06/18/2021, 9:00 PM
Should work
a
Aaron Wishnick
06/18/2021, 9:02 PMOk, that's really neat
Aaron Wishnick
06/18/2021, 9:02 PMHow can a text index accelerate a regex to be faster than table scan?
m
Mayank
06/18/2021, 9:02 PM
It leverages lucene index internally
a
Aaron Wishnick
06/18/2021, 9:03 PMCool