Alexey MilovidovandClaude Opus 5.5
0479a7a742
An alias `json` of the select list, such as `{$project: {json: ...}}`, captured the document
column in the `WHERE` of a preceding `$match`, so the filter read the projected value rather
than the stored document. The paths of the document are now qualified with the input table
whenever the select binds `json` or `_id`, the same way the object id already was.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
ClickHouse® is an open-source column-oriented database management system that allows generating analytical data reports in real-time.
How To Install (Linux, macOS, FreeBSD)
curl https://clickhouse.com/ | sh
Or skip the install: try ClickHouse Cloud for free and start querying in minutes.
Useful Links
- Official website has a quick high-level overview of ClickHouse on the main page.
- ClickHouse Cloud ClickHouse as a service, built by the creators and maintainers.
- Tutorial shows how to set up and query a small ClickHouse cluster.
- Documentation provides more in-depth information.
- YouTube channel has a lot of content about ClickHouse in video format.
- Slack and Telegram allow chatting with ClickHouse users in real-time.
- Blog contains various ClickHouse-related articles, as well as announcements and reports about events.
- (https://x.com/ClickHouseDB) and LinkedIn for short news.
- Code Browser (github.dev) with syntax highlighting, powered by github.dev.
- Contact us to discuss your use case with a ClickHouse expert.
Monthly Release & Community Call
The ClickHouse 26.9 Release Call took place on September 17, 2026 — watch the recording and the slides.
The ClickHouse 26.8 Release Call took place on August 27, 2026 — watch the recording and the slides.
The ClickHouse 26.7 Release Call took place on July 23, 2026 — watch the recording and the slides.
The ClickHouse 26.6 special "10 Year Anniversary" Release Call — recording and slides.
Watch all release presentations and videos at ClickHouse Theater and YouTube Playlist.
Upcoming Events
Keep an eye out for upcoming meetups and events around the world. Want to speak? Apply here You can also peruse ClickHouse Events for a list of all upcoming trainings, meetups, speaking engagements, etc.
Upcoming meetups
- AI Builders and Databases Tel Aviv - October 12th, 2026
- Hands-on training: Agent Observability with Langfuse in New York - October 15th, 2026
- Hands-on training: Agent Observability with Langfuse in Menlo Park - October 19th, 2026
- AI Builders and Databases London - October 21st, 2026
- AI Builders and Databases Dubai - October 22nd, 2026
- AI Builders Night New York @ Modal - November 3rd, 2026
- LibreChat Meetup New York - November 5th, 2026
- Observability with ClickStack Fundamentals Kubecon Training - November 9th, 2026
- San Francisco Data Engineering Meetup with ClickHouse - November 17th, 2026
- Toronto Data Engineering Meetup with ClickHouse - November 18th, 2026
Recent meetups
- Open House London - September 30th, 2026
- Grok Bot Montreal Build Day - October 3rd, 2026
- Open House Munich - October 6th, 2026
- SF Tech Week AI Night - October 6th, 2026
- AI Builders and Databases Stockholm - October 8th, 2026
- Mountain View Meetup - October 8th, 2026
Recent Recordings
- Recent Meetup Videos: Meetup Playlist Whenever possible recordings of the ClickHouse Community Meetups are edited and presented as individual talks.
Interested in joining ClickHouse and making it your full-time job?
ClickHouse is a nice DBMS, and it's a good place to work.
Check out our current openings here: https://clickhouse.com/company/careers
Email: careers@clickhouse.com!