What is the required index to use like and regex l...
# generalz
Zhuangda Z
06/15/2023, 8:27 PMWhat is the required index to use like and regex like operators? (native text index?) https://github.com/apache/pinot/pull/9654
Also curious how it performs comparing to TEXT_CONTAINS?(PR)
r
Richard
06/15/2023, 9:09 PMFST index
z
Zhuangda Z
06/15/2023, 9:10 PMSorry it’s one of these indexes or something not documented?
Zhuangda Z
06/16/2023, 2:02 PMThis FST link directs me to native text index.
Zhuangda Z
06/16/2023, 3:01 PMIt shows it is run with full_scan though even with native text index enabled
Copy code
FILTER_FULL_SCAN(operator:REGEXP_LIKE,predicate:regexp_like(indexedString0,'html'))s
Satish Mittal
07/05/2023, 4:49 PM• REGEXP_LIKE operator doesn't use any index. It results in full segment scan.
• TEXT_MATCH operator uses Lucene index.
• TEXT_CONTAINS operator uses Native index.
🙏 1