engine_file_* session settings

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.