apache / apache/pinot

Support for case-sensitive like in Pinot

Open
#10,609 10 comments 0 reactions 0 assignees View on GitHub
feature
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
1d 21h
Merged PRs (30d)
189

Description

At present, the `LIKE` command is case-insensitive while returning results. Are we planning to support case-sensitivity search in future with `LIKE`? Will this change the behaviour of `LIKE` that exists at present?
Other engines have 2 functions - `LIKE` and `ILIKE` where `ILIKE` is for case-insensitivity - https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-like/
Are we planning something similar?

Contributor guide

Open the contributing guide

Research direction

No implementation file or test is named in the issue. Start by locating Pinot's current LIKE query handling and its case-sensitivity tests, then establish whether the intended result is a new case-sensitive operation, changed LIKE behavior, or a separate ILIKE-style operation; done requires an agreed semantic and corresponding coverage.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.