Skip to content

Query Result Cache: Allows cached query results to disk#84041

Draft
zhongyuankai wants to merge 21 commits intoClickHouse:masterfrom
zhongyuankai:query_result_cache_on_disk
Draft

Query Result Cache: Allows cached query results to disk#84041
zhongyuankai wants to merge 21 commits intoClickHouse:masterfrom
zhongyuankai:query_result_cache_on_disk

Conversation

@zhongyuankai
Copy link
Copy Markdown
Contributor

@zhongyuankai zhongyuankai commented Jul 19, 2025

close #52141

Changelog category (leave one):

  • New Feature

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

Allow using cache disk for query result cache, the enable_writes_to_query_cache_disk setting control writes query results to disk, and the enable_reads_from_query_cache_disk setting control allows the cached results to be read from disk.

Documentation entry for user-facing changes

  • Documentation is written (mandatory for new features)

@zhongyuankai zhongyuankai marked this pull request as draft July 19, 2025 13:02
@alexey-milovidov alexey-milovidov added the can be tested Allows running workflows for external contributors label Jul 19, 2025
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Jul 19, 2025 •
edited
Loading

Workflow [PR], commit [629d2ab]

Summary: ❌

job_name test_name status info comment
Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, parallel) failure
03595_alter_drop_column_comment_if_exists FAIL
Lost s3 keys FAIL
S3_ERROR No such key thrown (in clickhouse-server.log or clickhouse-server.err.log) FAIL
Integration tests (amd_asan, old analyzer, 3/6) failure
test_filesystem_cache/test.py::test_max_size_ratio FAIL
Integration tests (amd_binary, 2/5) failure
test_filesystem_cache/test.py::test_max_size_ratio FAIL
Integration tests (arm_binary, distributed plan, 3/4) failure
test_filesystem_cache/test.py::test_max_size_ratio FAIL
Integration tests (amd_tsan, 3/6) failure
test_filesystem_cache/test.py::test_max_size_ratio FAIL
Integration tests (amd_tsan, 4/6) failure
test_refreshable_mv_skip_old_temp_table_ddls/test.py::test_refreshable_mv_skip_old_temp_tables_ddls[1-False-False] FAIL
Install packages (amd_debug) failure
Install clickhouse binary in deb failure
Stress test (amd_msan) failure
Server died FAIL
Hung check failed, possible deadlock found (see hung_check.log) FAIL
Killed by signal (in clickhouse-server.log) FAIL
Fatal message in clickhouse-server.log (see fatal_messages.txt) FAIL
Killed by signal (output files) FAIL
Found signal in gdb.log FAIL

@clickhouse-gh clickhouse-gh bot added the pr-feature Pull request with new product feature label Jul 19, 2025
@zhongyuankai zhongyuankai force-pushed the query_result_cache_on_disk branch from 7880208 to 14b83fd Compare July 20, 2025 03:43
@zhongyuankai zhongyuankai force-pushed the query_result_cache_on_disk branch from 14b83fd to f3cd624 Compare July 20, 2025 06:44
@zhongyuankai zhongyuankai force-pushed the query_result_cache_on_disk branch from 33bdf5a to 3e29f47 Compare July 27, 2025 04:59
@rschu1ze rschu1ze self-assigned this Aug 6, 2025
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Oct 21, 2025

Dear @zhongyuankai, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Oct 28, 2025

Dear @zhongyuankai, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

1 similar comment
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Dec 30, 2025

Dear @zhongyuankai, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@rschu1ze rschu1ze mentioned this pull request Dec 30, 2025
Closed
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Mar 3, 2026

Dear @zhongyuankai, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

@rschu1ze rschu1ze

Labels

can be tested Allows running workflows for external contributors pr-feature Pull request with new product feature

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

Allow using cache disk for query result cache.

3 participants

@zhongyuankai @alexey-milovidov @rschu1ze