ClickHouse / ClickHouse/pg_clickhouse
Support JSONB Subscripting
- Dominant language
- C
- Stars
- 283
- Forks
- 21
- Avg merge
- 2d 6h
- Merged PRs (30d)
- 11
Description
#161 disabled subscripting for jsonb `col['name']` syntax. Investigate whether it can be modified to convert that syntax to ClickHouse's [sub-column syntax](https://clickhouse.com/docs/sql-reference/data-types/newjson#reading-json-paths-as-sub-columns). See #169 for inspiration.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reading #161 to understand why JSONB subscripting was disabled, then compare the proposed behavior with the ClickHouse JSON sub-column syntax in the linked documentation. Review #169 for the related approach. Done means determining whether col['name'] can be converted correctly and documenting or implementing the resulting behavior with appropriate validation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, postgresql, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100