Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

compatibility_* session settings

These settings are available in system.settings and are autogenerated from source.

compatibility

The compatibility setting causes ClickHouse to use the default settings of a previous version of ClickHouse, where the previous version is provided as the setting.

If settings are set to non-default values, then those settings are honored (only settings that have not been modified are affected by the compatibility setting).

This setting takes a ClickHouse version number as a string, like 22.3, 22.8. An empty value means that this setting is disabled.

Disabled by default.

compatibility_s3_presigned_url_query_in_path

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.120New setting.

Compatibility: when enabled, folds pre-signed URL query parameters (e.g. X-Amz-*) into the S3 key (legacy behavior), so ‘?’ acts as a wildcard in the path. When disabled (default), pre-signed URL query parameters are kept in the URL query to avoid interpreting ‘?’ as a wildcard.

Navigation