Hello, on the documentation (<https://docs.pinot.a...
# troubleshootinge
eywek
10/21/2021, 2:04 PMHello, on the documentation (https://docs.pinot.apache.org/basics/indexing/text-search-support#co-existence-with-other-indexes) you’re explaining that text indexes aren’t supported with dictionary encoded columns. Do you know when we will be able to do it?
I would use an inverted index + a text index
Thank you
k
Kishore G
10/21/2021, 2:31 PM
We have a PR out.. @Atri Sharma @Richard Startin
e
eywek
11/05/2021, 1:45 PMI haven’t found the PR, could you give me the link? Additionally I’ve seen you’re trying to implement native text search with the LIKE operator, do you have any idea when you plan to release it? Thank you
a
Atri Sharma
11/05/2021, 1:55 PM@eywek I am slightly confused. We already support LIKE using FST indices today. The optimization to be done is to use text index in case its present and the query is a wildcard (LIKE foo%).
Atri Sharma
11/05/2021, 1:55 PMWhat is your specific ask, please?
Atri Sharma
11/05/2021, 1:55 PMAnd the dictionary encoding PR is merged. It will be released in next release
e
eywek
11/05/2021, 1:57 PMI would like to use TEXT_MATCH (or LIKE with wildcard) with text indexes & inverted indexes (which is currently not supported based on the doc)
eywek
11/05/2021, 1:57 PMOkay thank you, so in the next release it will be possible right? Do you know when this release will be done?
a
Atri Sharma
11/05/2021, 1:58 PMThe branch is being cut next week, IIRC.
Atri Sharma
11/05/2021, 1:59 PMFor LIKE with text indexes, I will push out the PR early next week. Targeting 0.9 release
e
eywek
11/05/2021, 2:00 PMOh great! And do you have any idea on when the 0.9 release will be out?
a
Atri Sharma
11/05/2021, 2:00 PM@Xiang Fu can you please help here, since you are the RM for 0.9?
x
Xiang Fu
11/05/2021, 5:38 PM
plan to be cut by next Tue(Nov 9)