ClickHouse/clickhouse-docs-embeddings huggingface dataset:
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Pretty/PrettyMonoBlock.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✗ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Differs from the [`Pretty`](/docs/interfaces/formats/Pretty) format in that up to `10,000` rows are buffered,
and then output as a single table, and not by [blocks](/docs/development/architecture#block).

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `Pretty` formats:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_pretty_max_rows`](/docs/operations/settings/formats#output_format_pretty_max_rows) Row limit for Pretty formats. `10000`| [`output_format_pretty_max_column_pad_width`](/docs/operations/settings/formats#output_format_pretty_max_column_pad_width) Maximum width to pad all values in a column in Pretty formats. `250`| [`output_format_pretty_max_value_width`](/docs/operations/settings/formats#output_format_pretty_max_value_width) Maximum width of value to display in Pretty formats. If greater - it will be cut. `10000`| [`output_format_pretty_color`](/docs/operations/settings/formats#output_format_pretty_color) Use ANSI escape sequences to paint colors in Pretty formats. `true`| [`output_format_pretty_grid_charset`](/docs/operations/settings/formats#output_format_pretty_grid_charset) Charset for printing grid borders. Available charsets: ASCII, UTF-8. `UTF-8`| [`output_format_pretty_row_numbers`](/docs/operations/settings/formats#output_format_pretty_row_numbers) Add row numbers before each row for pretty output format. `true`| [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) Display column names in the footer if table contains many rows. `true`| [`output_format_pretty_display_footer_column_names_min_rows`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names_min_rows) Sets the minimum number of rows for which a footer will be displayed if [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) is enabled. `50` | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Pretty/PrettyNoEscapesMonoBlock.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✗ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Differs from the [`PrettyNoEscapes`](/docs/interfaces/formats/PrettyNoEscapes) format in that up to `10,000` rows are buffered,
and then output as a single table, and not by blocks.

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `Pretty` formats:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_pretty_max_rows`](/docs/operations/settings/formats#output_format_pretty_max_rows) Row limit for Pretty formats. `10000`| [`output_format_pretty_max_column_pad_width`](/docs/operations/settings/formats#output_format_pretty_max_column_pad_width) Maximum width to pad all values in a column in Pretty formats. `250`| [`output_format_pretty_max_value_width`](/docs/operations/settings/formats#output_format_pretty_max_value_width) Maximum width of value to display in Pretty formats. If greater - it will be cut. `10000`| [`output_format_pretty_color`](/docs/operations/settings/formats#output_format_pretty_color) Use ANSI escape sequences to paint colors in Pretty formats. `true`| [`output_format_pretty_grid_charset`](/docs/operations/settings/formats#output_format_pretty_grid_charset) Charset for printing grid borders. Available charsets: ASCII, UTF-8. `UTF-8`| [`output_format_pretty_row_numbers`](/docs/operations/settings/formats#output_format_pretty_row_numbers) Add row numbers before each row for pretty output format. `true`| [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) Display column names in the footer if table contains many rows. `true`| [`output_format_pretty_display_footer_column_names_min_rows`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names_min_rows) Sets the minimum number of rows for which a footer will be displayed if [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) is enabled. `50` | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Pretty/PrettySpace.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✗ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Differs from the [`PrettyCompact`](/docs/interfaces/formats/PrettyCompact) format in that whitespace
(space characters) is used for displaying the table instead of a grid.

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `Pretty` formats:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_pretty_max_rows`](/docs/operations/settings/formats#output_format_pretty_max_rows) Row limit for Pretty formats. `10000`| [`output_format_pretty_max_column_pad_width`](/docs/operations/settings/formats#output_format_pretty_max_column_pad_width) Maximum width to pad all values in a column in Pretty formats. `250`| [`output_format_pretty_max_value_width`](/docs/operations/settings/formats#output_format_pretty_max_value_width) Maximum width of value to display in Pretty formats. If greater - it will be cut. `10000`| [`output_format_pretty_color`](/docs/operations/settings/formats#output_format_pretty_color) Use ANSI escape sequences to paint colors in Pretty formats. `true`| [`output_format_pretty_grid_charset`](/docs/operations/settings/formats#output_format_pretty_grid_charset) Charset for printing grid borders. Available charsets: ASCII, UTF-8. `UTF-8`| [`output_format_pretty_row_numbers`](/docs/operations/settings/formats#output_format_pretty_row_numbers) Add row numbers before each row for pretty output format. `true`| [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) Display column names in the footer if table contains many rows. `true`| [`output_format_pretty_display_footer_column_names_min_rows`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names_min_rows) Sets the minimum number of rows for which a footer will be displayed if [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) is enabled. `50` | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Pretty/PrettySpaceMonoBlock.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✗ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Differs from the [`PrettySpace`](/docs/interfaces/formats/PrettySpace) format in that up to `10,000` rows are buffered,
and then output as a single table, and not by [blocks](/docs/development/architecture#block).

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `Pretty` formats:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_pretty_max_rows`](/docs/operations/settings/formats#output_format_pretty_max_rows) Row limit for Pretty formats. `10000`| [`output_format_pretty_max_column_pad_width`](/docs/operations/settings/formats#output_format_pretty_max_column_pad_width) Maximum width to pad all values in a column in Pretty formats. `250`| [`output_format_pretty_max_value_width`](/docs/operations/settings/formats#output_format_pretty_max_value_width) Maximum width of value to display in Pretty formats. If greater - it will be cut. `10000`| [`output_format_pretty_color`](/docs/operations/settings/formats#output_format_pretty_color) Use ANSI escape sequences to paint colors in Pretty formats. `true`| [`output_format_pretty_grid_charset`](/docs/operations/settings/formats#output_format_pretty_grid_charset) Charset for printing grid borders. Available charsets: ASCII, UTF-8. `UTF-8`| [`output_format_pretty_row_numbers`](/docs/operations/settings/formats#output_format_pretty_row_numbers) Add row numbers before each row for pretty output format. `true`| [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) Display column names in the footer if table contains many rows. `true`| [`output_format_pretty_display_footer_column_names_min_rows`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names_min_rows) Sets the minimum number of rows for which a footer will be displayed if [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) is enabled. `50` | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Pretty/PrettySpaceNoEscapes.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✗ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Differs from the [`PrettySpace`](/docs/interfaces/formats/PrettySpace) format in that [ANSI-escape sequences](https://en.wikipedia.org/wiki/ANSI_escape_code) are not used.
This is necessary for displaying this format in a browser, as well as for using the 'watch' command-line utility.

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `Pretty` formats:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_pretty_max_rows`](/docs/operations/settings/formats#output_format_pretty_max_rows) Row limit for Pretty formats. `10000`| [`output_format_pretty_max_column_pad_width`](/docs/operations/settings/formats#output_format_pretty_max_column_pad_width) Maximum width to pad all values in a column in Pretty formats. `250`| [`output_format_pretty_max_value_width`](/docs/operations/settings/formats#output_format_pretty_max_value_width) Maximum width of value to display in Pretty formats. If greater - it will be cut. `10000`| [`output_format_pretty_color`](/docs/operations/settings/formats#output_format_pretty_color) Use ANSI escape sequences to paint colors in Pretty formats. `true`| [`output_format_pretty_grid_charset`](/docs/operations/settings/formats#output_format_pretty_grid_charset) Charset for printing grid borders. Available charsets: ASCII, UTF-8. `UTF-8`| [`output_format_pretty_row_numbers`](/docs/operations/settings/formats#output_format_pretty_row_numbers) Add row numbers before each row for pretty output format. `true`| [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) Display column names in the footer if table contains many rows. `true`| [`output_format_pretty_display_footer_column_names_min_rows`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names_min_rows) Sets the minimum number of rows for which a footer will be displayed if [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) is enabled. `50` | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Pretty/PrettySpaceNoEscapesMonoBlock.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✗ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Differs from the [`PrettySpaceNoEscapes`](/docs/interfaces/formats/PrettySpaceNoEscapes) format in that up to `10,000` rows are buffered,
and then output as a single table, and not by [blocks](/docs/development/architecture#block).

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `Pretty` formats:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_pretty_max_rows`](/docs/operations/settings/formats#output_format_pretty_max_rows) Row limit for Pretty formats. `10000`| [`output_format_pretty_max_column_pad_width`](/docs/operations/settings/formats#output_format_pretty_max_column_pad_width) Maximum width to pad all values in a column in Pretty formats. `250`| [`output_format_pretty_max_value_width`](/docs/operations/settings/formats#output_format_pretty_max_value_width) Maximum width of value to display in Pretty formats. If greater - it will be cut. `10000`| [`output_format_pretty_color`](/docs/operations/settings/formats#output_format_pretty_color) Use ANSI escape sequences to paint colors in Pretty formats. `true`| [`output_format_pretty_grid_charset`](/docs/operations/settings/formats#output_format_pretty_grid_charset) Charset for printing grid borders. Available charsets: ASCII, UTF-8. `UTF-8`| [`output_format_pretty_row_numbers`](/docs/operations/settings/formats#output_format_pretty_row_numbers) Add row numbers before each row for pretty output format. `true`| [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) Display column names in the footer if table contains many rows. `true`| [`output_format_pretty_display_footer_column_names_min_rows`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names_min_rows) Sets the minimum number of rows for which a footer will be displayed if [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) is enabled. `50` | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Protobuf/ProtobufList.md)

Not supported in ClickHouse Cloud

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✔ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

The `ProtobufList` format is similar to the [`Protobuf`](/docs/interfaces/formats/Protobuf) format but rows are represented as a sequence of sub-messages contained in a message with a fixed name of "Envelope".

## Example usage[​](#example-usage "Direct link to Example usage")

For example:

```
SELECT * FROM test.table FORMAT ProtobufList SETTINGS format_schema = 'schemafile:MessageType'
```

```
cat protobuflist_messages.bin | clickhouse-client --query "INSERT INTO test.table FORMAT ProtobufList SETTINGS format_schema='schemafile:MessageType'"
```

Where the file `schemafile.proto` looks like this:

```
syntax = "proto3";
message Envelope {
  message MessageType {
    string name = 1;
    string surname = 2;
    uint32 birthDate = 3;
    repeated string phoneNumbers = 4;
  };
  MessageType row = 1;
};
```

## Format settings[​](#format-settings "Direct link to Format settings")

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Protobuf/ProtobufSingle.md)

Not supported in ClickHouse Cloud

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✔ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

The `ProtobufSingle` format is the same as the [`Protobuf`](/docs/interfaces/formats/Protobuf) format but it is intended for storing/parsing single Protobuf messages without length delimiters.

## Example usage[​](#example-usage "Direct link to Example usage")

## Format settings[​](#format-settings "Direct link to Format settings")

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?
title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/RawBLOB.md)

## Description[​](#description "Direct link to Description")

The `RawBLOB` formats reads all input data to a single value. It is possible to parse only a table with a single field of type [`String`](/docs/sql-reference/data-types/string) or similar.
The result is output as a binary format without delimiters and escaping. If more than one value is output, the format is ambiguous, and it will be impossible to read the data back.

### Raw formats comparison[​](#raw-formats-comparison "Direct link to Raw formats comparison")

Below is a comparison of the formats `RawBLOB` and [`TabSeparatedRaw`](/docs/interfaces/formats/TabSeparatedRaw).

`RawBLOB`:

- data is output in binary format, no escaping;
- there are no delimiters between values;
- no new-line at the end of each value.

`TabSeparatedRaw`:

- data is output without escaping;
- the rows contain values separated by tabs;
- there is a line feed after the last value in every row.

The following is a comparison of the `RawBLOB` and [RowBinary](/docs/interfaces/formats/RowBinary) formats.

`RawBLOB`:

- String fields are output without being prefixed by length.

`RowBinary`:

- String fields are represented as length in varint format (unsigned [LEB128] (<https://en.wikipedia.org/wiki/LEB128>)), followed by the bytes of the string.

When empty data is passed to the `RawBLOB` input, ClickHouse throws an exception:

```
Code: 108. DB::Exception: No data to insert
```

## Example usage[​](#example-usage "Direct link to Example usage")

```
$ clickhouse-client --query "CREATE TABLE {some_table} (a String) ENGINE = Memory;"
$ cat {filename} | clickhouse-client --query="INSERT INTO {some_table} FORMAT RawBLOB"
$ clickhouse-client --query "SELECT * FROM {some_table} FORMAT RawBLOB" | md5sum
```

```
f9725a22f9191e064120d718e26862a9  -
```

## Format settings[​](#format-settings "Direct link to Format settings")

- [Description](#description)
  - [Raw formats comparison](#raw-formats-comparison)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?