Why is ClickHouse logging so verbose by default?
Learn why the ClickHouse developers chose to set a verbose logging level by default.
· 2 min read
9 posts tagged with "Settings"
Change the prompt in clickhouse-client
This article explains how to change the prompt in your Clickhouse client terminal window from :) to whatever you want.
· 2 min read
Alter User Settings Exception
Handing the an exception thrown when altering user settings
· One min read
How do I solve TOO MANY PARTS error during an INSERT...SELECT?
Resolve the TOO_MANY_PARTS error in ClickHouse during an `INSERT...SELECT` by tuning expert-level settings for larger blocks and increasing partition thresholds.
· 2 min read
Useful queries for troubleshooting
A collection of handy queries for troubleshooting ClickHouse, including monitoring table sizes, long-running queries, and errors.
· 4 min read
Synchronous data reading
The new setting `allow_asynchronous_read_from_io_pool_for_merge_tree` allows the number of reading threads (streams) to be higher than the number of threads in the rest of the query execution pipeline.
· 4 min read
How to Configure Settings for a User in ClickHouse
Learn how to define settings in ClickHouse for individual queries, client sessions, or specific users using `SET` and `ALTER USER` commands.
· 2 min read
How to Ignore Incorrect Settings in ClickHouse
Learn how to use the `skip_check_for_incorrect_settings` option to allow ClickHouse to start even when user-level settings are specified incorrectly.
· One min read
Setting a limit on query execution time
How to enforce limit on max query execution time
· One min read