Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
engine_file_allow_create_multiple_files

Enables or disables creating a new file on each insert in file engine tables if the format has the suffix (JSON, ORC, Parquet, etc.). If enabled, on each insert a new file will be created with a name following this pattern: data.Parquet -> data.1.Parquet -> data.2.Parquet, etc. Possible values:
  • 0 — INSERT query appends new data to the end of the file.
  • 1 — INSERT query creates a new file.

​
engine_file_empty_if_not_exists

Allows to select data from a file engine table without file. Possible values:
  • 0 — SELECT throws exception.
  • 1 — SELECT returns empty result.

​
engine_file_skip_empty_files

Enables or disables skipping empty files in File engine tables. Possible values:
  • 0 — SELECT throws an exception if empty file is not compatible with requested format.
  • 1 — SELECT returns empty result for empty file.

​
engine_file_truncate_on_insert

Enables or disables truncate before insert in File engine tables. Possible values:
  • 0 — INSERT query appends new data to the end of the file.
  • 1 — INSERT query replaces existing content of the file with the new data.
Last modified on July 23, 2026