FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

Improve docs from user feedback: clarify direct vs. indirect source refs in MV JOINs by mintlify[bot] · Pull Request #121284 · ClickHouse/ClickHouse · GitHub

Improve docs from user feedback: clarify direct vs. indirect source refs in MV JOINs - #121284

Open
mintlify[bot] wants to merge 1 commit into
masterfrom
mintlify/816bcc9d
Open

mintlify[bot] wants to merge 1 commit into
masterfrom
mintlify/816bcc9d

Conversation

mintlify Bot commented Sep 21, 2026
edited by clickhouse-gh Bot
Loading

Copy link
Copy Markdown
Contributor

Summary

Clarifies how ClickHouse substitutes the source table inside an incremental materialized view's SELECT when it fires, so readers can predict mvw1 vs. mvw2 behavior without re-reading the section.

Changes

  • Rewrote the "Explanation" subsection of Using source table in filters and joins in /concepts/features/materialized-views/incremental-materialized-view.
  • Added an explicit direct reference vs. indirect reference definition, with a callout stating the substitution rule.
  • Added a side-by-side comparison table for mvw1 and mvw2 covering how each JOIN side is resolved on insert and the resulting counts after each INSERT.
  • Called out that wrapping the source name in a subquery does not force a full-table read; a wrapper VIEW (as with vt0) does.

Feedback basis

Recent contextual feedback on this page reported that the "Using source table in filters and joins" section was hard to understand, specifically around direct vs. indirect references to the source table, and suggested comparing the two example views side by side. The update adds that comparison and puts the substitution rule up front.


Workflow [PR]
Sync PR [sync-upstream/pr/121284]

mintlify Bot commented Sep 21, 2026
edited
Loading

Copy link
Copy Markdown
Contributor Author

Preview deployment for your docs. Learn more about Mintlify Previews.

Project Status Preview Updated
ClickHouse-docs 🟢 Ready View Preview Sep 21, 2026, 7:43 AM

clickhouse-gh Bot commented Sep 21, 2026
edited
Loading

Copy link
Copy Markdown
Contributor

Workflow [PR], commit [23f9b70]

Summary:

job_name test_name status info comment
Config Workflow FAIL
python3 ./ci/jobs/scripts/workflow_hooks/pr_labels_and_category.py FAIL
Finish Workflow FAIL
python3 ./ci/jobs/scripts/workflow_hooks/pr_body_check.py FAIL
Dockers Build (amd) DROPPED
Dockers Build (arm) DROPPED
Dockers Build (multiplatform manifest) DROPPED
Style check DROPPED
Code Review DROPPED
Docs check (Mintlify) DROPPED
Fast test DROPPED
Fast test (arm_darwin) DROPPED

This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

0 participants


Back | FazBrowse Home | New Git URL