Hi, Do we have this feature https://github.com/apache/pinot/pull/6120#issue-717507183 documented on pinot docs? (couldn’t find) Is this recommended to speedup regexp queries?

didn’t find either. but found about the FST index. I also see in the PR there is a config examples to enable FST. As to whether it’d work for your datasets, would suggest to benchmark it a bit.

For some reason, the FST index documentation does not exist. @harnoor try creating a text index and using TEXT_MATCH for the regex search.

Thanks @Atri Sharma @Xiaobing.

try creating a text index and using TEXT_MATCH for the regex search

Regarding this, so our application receives graphQL request and it converts it into PinotSQL. So

regexp_like

operator is hardcoded. We can change it to

TEXT_MATCH

but it requires code level handling and not a simple pluggable index like other indexes. (As app needs to fallback to regexp_like if text index is not on a column).