Skip to content

Optimize distinctJSONPaths aggregate function#92196

Merged
Avogar merged 12 commits intoClickHouse:masterfrom
Avogar:optimize-distinct-json-paths
Dec 19, 2025
Merged

Optimize distinctJSONPaths aggregate function#92196
Avogar merged 12 commits intoClickHouse:masterfrom
Avogar:optimize-distinct-json-paths

Conversation

@Avogar
Copy link
Copy Markdown
Member

@Avogar Avogar commented Dec 15, 2025 •
edited by fm4v
Loading

Changelog category (leave one):

  • Performance Improvement

Changelog entry (a user-readable short description of the changes that goes into CHANGELOG.md):

Optimize distinctJSONPaths aggregate function so it reads only JSON paths from data parts and not the whole JSON column

Documentation entry for user-facing changes

  • Documentation is written (mandatory for new features)

@Avogar Avogar added the 🎅 🎁 gift🎄 To make people wonder label Dec 15, 2025
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Dec 15, 2025 •
edited by Avogar
Loading

Workflow [PR], commit [3f1eae8]

Summary: ❌

job_name test_name status info comment
Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, sequential) failure
02943_rmt_alter_metadata_merge_checksum_mismatch FAIL cidb, issue ISSUE CREATED
Stateless tests (amd_tsan, s3 storage, parallel) failure
03737_text_index_materialization FAIL cidb, issue ISSUE EXISTS
Performance Comparison (amd_release, master_head, 3/6) failure
Check Results failure IGNORED

@clickhouse-gh clickhouse-gh bot added the pr-performance Pull request with some performance improvements label Dec 15, 2025
@antonio2368 antonio2368 self-assigned this Dec 16, 2025
@Avogar Avogar added this pull request to the merge queue Dec 19, 2025
Merged via the queue into ClickHouse:master with commit 5ff73a9 Dec 19, 2025
127 of 131 checks passed
@Avogar Avogar deleted the optimize-distinct-json-paths branch December 19, 2025 14:20
@robot-clickhouse robot-clickhouse added the pr-synced-to-cloud The PR is synced to the cloud repo label Dec 19, 2025
@robot-ch-test-poll4 robot-ch-test-poll4 added the pr-must-backport-synced The `*-must-backport` labels are synced into the cloud Sync PR label Dec 19, 2025
@robot-ch-test-poll1 robot-ch-test-poll1 mentioned this pull request Dec 19, 2025
Merged
robot-ch-test-poll1 added a commit that referenced this pull request Dec 19, 2025
@robot-ch-test-poll1
Merge pull request #92710 from ClickHouse/cherrypick/25.12/92196
2382125 
Cherry pick #92196 to 25.12: Optimize distinctJSONPaths aggregate function
robot-clickhouse added a commit that referenced this pull request Dec 19, 2025
@robot-clickhouse
Backport #92196 to 25.12: Optimize distinctJSONPaths aggregate function
3319fe9
@robot-ch-test-poll1 robot-ch-test-poll1 mentioned this pull request Dec 19, 2025
Merged
@robot-ch-test-poll2 robot-ch-test-poll2 added the pr-backports-created Backport PRs are successfully created, it won't be processed by CI script anymore label Dec 19, 2025
clickhouse-gh bot added a commit that referenced this pull request Dec 19, 2025
@clickhouse-gh
Merge pull request #92711 from ClickHouse/backport/25.12/92196
5c7774c 
Backport #92196 to 25.12: Optimize distinctJSONPaths aggregate function
@Avogar Avogar mentioned this pull request Jan 19, 2026
Open
56 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@antonio2368 antonio2368 antonio2368 approved these changes

Assignees

@antonio2368 antonio2368

Labels

🎅 🎁 gift🎄 To make people wonder pr-backports-created Backport PRs are successfully created, it won't be processed by CI script anymore pr-must-backport-synced The `*-must-backport` labels are synced into the cloud Sync PR pr-performance Pull request with some performance improvements pr-synced-to-cloud The PR is synced to the cloud repo v25.12-must-backport

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

5 participants

@Avogar @antonio2368 @robot-clickhouse @robot-ch-test-poll2 @robot-ch-test-poll4