How are text_match regex's performed? I'm looking ...
# general
p
How are text_match regex's performed? I'm looking for string contains type queries (eg. Text_match(column, '/.*partial_term. */')). Normally I would look for lucene ngram tokenization for this but see Pinot isn't using this. How are the partial term regex's completed? Is this essentially raw regex performed against all tokens?
m
@Playsted from my limited experience to do a partial match you just put in in quotes Text_match(column, ‘*partial_term*’)).
p
Without the regex it seems to only match on word tokens, regex with wildcard it will match of partial words but not sure how efficient the processing is
Partial term errors for me if using prefix wildcard
Without regex