Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

RowBinaryWithNamesAndTypes

Input Output Alias

Description

Similar to the RowBinary format, but with added header:

  • LEB128-encoded number of columns (N).
  • N Strings specifying column names.
  • N Strings specifying column types.

Example usage

Format settings

The following settings are common to all RowBinary type formats.

Setting Description Default
format_binary_max_string_size The maximum allowed size for String in RowBinary format. 1GiB
output_format_binary_encode_types_in_binary_format Allows to write types in header using binary encoding instead of strings with type names in RowBinaryWithNamesAndTypes output format. false
input_format_binary_decode_types_in_binary_format Allows to read types in header using binary encoding instead of strings with type names in RowBinaryWithNamesAndTypes input format. false
output_format_binary_write_json_as_string Allows to write values of the JSON data type as JSON String values in RowBinary output format. false
input_format_binary_read_json_as_string Allows to read values of the JSON data type as JSON String values in RowBinary input format. false
Navigation