Skip to main content
These settings are autogenerated from source.

​
schema_inference_hints

The list of column names and types to use as hints in schema inference for formats without schema. Example: Query:
Result:
If the schema_inference_hints is not formatted properly, or if there is a typo or a wrong datatype, etc… the whole schema_inference_hints will be ignored.

​
schema_inference_make_columns_nullable

Controls making inferred types Nullable in schema inference. Possible values:
  • 0 - the inferred type will never be Nullable (use input_format_null_as_default to control what do do with null values in this case),
  • 1 - all inferred types will be Nullable,
  • 2 or auto - the inferred type will be Nullable only if the column contains NULL in a sample that is parsed during schema inference or file metadata contains information about column nullability,
  • 3 - the inferred type nullability will match file metadata if the format has it (e.g. Parquet), always Nullable otherwise (e.g. CSV).

​
schema_inference_make_json_columns_nullable

Controls making inferred JSON types Nullable in schema inference. If this setting is enabled together with schema_inference_make_columns_nullable, inferred JSON type will be Nullable.

​
schema_inference_mode

Mode of schema inference. ‘default’ - assume that all files have the same schema and schema can be inferred from any file, ‘union’ - files can have different schemas and the resulting schema should be the a union of schemas of all files
Last modified on July 23, 2026