Possibility to Change the Location of Clickhouse History File for Client Using Clickhouse_history_file Env

Why it matters

This feature allows users to specify a custom path for the ClickHouse client history file, enabling better control over where query history is stored. It is useful for managing configurations in environments where the default location is not suitable or for separating history files for different use cases or users.

How to use it

Set the environment variable CLICKHOUSE_HISTORY_FILE to the desired file path before running the ClickHouse client. For example:

export CLICKHOUSE_HISTORY_FILE=/path/to/custom_history_file
clickhouse-client