apache / apache/pinot

Single text index per segment

Open
#15,750 3 comments 1 reaction 0 assignees View on GitHub
enhancement index plugins stale
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 55m
Merged PRs (30d)
182

Description

We recently observed use cases with 100+ columns requiring text indices, which causes the issue of too many open files as current text index implementation is per column.

The proposal here is to allow one shared Lucene Index for Multiple Columns in Pinot.

## Changes
- One Lucene index directory per segment, not per column.
- Each text column is represented as a Lucene field within that shared index.
- TextMatch queries can specify which column (i.e., Lucene field) to search.

## Challenges
- Meanwhile the down side is also obvious, that whenever there are changes required for adding/removing column index, the process may take longer time for rebuilding the whole index.
- How to handle null/missing value
- shared index dir is a fixed path per segment

# #Future extentions
- Advanced queries: Support cross-field Lucene queries if needed later.

Contributor guide

Open the contributing guide

Research direction

No files or tests are named. Start by tracing Pinot's current per-column Lucene text-index implementation and how TextMatch queries select a column. Define completion as one Lucene index directory per segment, fields for each text column, supported null or missing values, and working column-specific TextMatch queries.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases, search
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.