apache / apache/pinot

[Docs] IN_ID_SET

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

Description

This is a note for me of something that needs documenting

```
xtrntr 1 day ago
will using IdSet with “NOT IN” clause have any unintended performance impact?
e.g. select * from table where userid not in IDSET(...)

Jackie 21 hours ago
This is not correct syntax. You should do select ... where IN_ID_SET(userid, ...) = 0
```

Contributor guide

Open the contributing guide

Research direction

Start by locating Pinot’s existing documentation for IN_ID_SET and review the syntax shown in the issue. Document the correct form for checking non-membership and clarify any performance implications of using IN_ID_SET with a NOT IN-style condition.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.