[Docs] IN_ID_SET
Open
- 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
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