跳至主要内容

settings_changes

包含有关先前 ClickHouse 版本中设置更改的信息。

列

  • version (字符串) — 更改设置的 ClickHouse 版本
  • changes (数组 of 元组) — 设置更改的描述：(设置名称，先前值，新值，更改原因)

示例

SELECT *
FROM system.settings_changes
WHERE version = '23.5'
FORMAT Vertical
Row 1:
──────
version: 23.5
changes: [('input_format_parquet_preserve_order','1','0','Allow Parquet reader to reorder rows for better parallelism.'),('parallelize_output_from_storages','0','1','Allow parallelism when executing queries that read from file/url/s3/etc. This may reorder rows.'),('use_with_fill_by_sorting_prefix','0','1','Columns preceding WITH FILL columns in ORDER BY clause form sorting prefix. Rows with different values in sorting prefix are filled independently'),('output_format_parquet_compliant_nested_types','0','1','Change an internal field name in output Parquet file schema.')]

另请参阅