Native Text Indices and LIKE Operator

This talk shall focus on the native FST and indices functionality in Pinot, its benefits, performance numbers, usage and future work. The talk shall also go over the LIKE operator, a new operator in Pinot which brings it closer to SQL Standard for powerful text searching capabilities.

00:00:00 Welcome
00:02:41 Nueva Text Capabilities in Pinot
00:04:12 What is text Query?
00:06:12 Enter the FST
00:14:15 Query Answering
00:18:55 Text Indexes in Pinot
00:24:00 Performance for LIKE Queries
00:27:22 Mutable FST
00:37:00 Future Work
00:35:09 End to End Flow
00:39:05 Q&A

------------------------
Speaker
------------------------
Atri Sharma is a Distinguished Engineer at Securonix and an ASF Member. He is a Pinot committer and has worked on various query performance improvements and new features. He is the author of Practical Apache Lucene 8.

------------------------
Pinot Resources:
------------------------
Website: http://pinot.apache.org/
Docs: https://docs.pinot.apache.org/
Slack: https://communityinviter.com/apps/apache-pinot/apache-pinot
Github project https://github.com/apache/incubator-pinot
Twitter: https://twitter.com/ApachePinot

Видео Native Text Indices and LIKE Operator канала StarTree