9 posts tagged with "Settings"

Explain why ClickHouse developers chose to set a verbose log level by default

This article explains how to change the prompt in your Clickhouse client terminal window from :) to whatever you want.

Handing the an exception thrown when altering user settings

Resolve the TOO_MANY_PARTS error in ClickHouse during an `INSERT...SELECT` by tuning expert-level settings for larger blocks and increasing partition thresholds.

A collection of handy queries for troubleshooting ClickHouse, including monitoring table sizes, long-running queries, and errors.

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.

Learn how to define settings in ClickHouse for individual queries, client sessions, or specific users using `SET` and `ALTER USER` commands.

Learn how to use the `skip_check_for_incorrect_settings` option to allow ClickHouse to start even when user-level settings are specified incorrectly.

How to enforce limit on max query execution time