title_wip

Insert the data:

```
INSERT INTO football FROM INFILE 'football.parquet' FORMAT Parquet;
```

### Reading data[​](#reading-data "Direct link to Reading data")

Read data using the `Parquet` format:

```
SELECT *
FROM football
INTO OUTFILE 'football.parquet'
FORMAT Parquet
```

Tip

Parquet is a binary format that does not display in a human-readable form on the terminal. Use the `INTO OUTFILE` to output Parquet files.

To exchange data with Hadoop, you can use the [`HDFS table engine`](/docs/engines/table-engines/integrations/hdfs).

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

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `input_format_parquet_case_insensitive_column_matching` Ignore case when matching Parquet columns with CH columns. `0`| `input_format_parquet_preserve_order` Avoid reordering rows when reading from Parquet files. Usually makes it much slower. `0`| `input_format_parquet_filter_push_down` When reading Parquet files, skip whole row groups based on the WHERE/PREWHERE expressions and min/max statistics in the Parquet metadata. `1`| `input_format_parquet_bloom_filter_push_down` When reading Parquet files, skip whole row groups based on the WHERE expressions and bloom filter in the Parquet metadata. `0`| `input_format_parquet_allow_missing_columns` Allow missing columns while reading Parquet input formats `1`| `input_format_parquet_local_file_min_bytes_for_seek` Min bytes required for local read (file) to do seek, instead of read with ignore in Parquet input format `8192`| `input_format_parquet_enable_row_group_prefetch` Enable row group prefetching during parquet parsing. Currently, only single-threaded parsing can prefetch. `1`| `input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference` Skip columns with unsupported types while schema inference for format Parquet `0`| `input_format_parquet_max_block_size` Max block size for parquet reader. `65409`| `input_format_parquet_prefer_block_bytes` Average block bytes output by parquet reader `16744704`| `input_format_parquet_enable_json_parsing` When reading Parquet files, parse JSON columns as ClickHouse JSON Column. `1`| `output_format_parquet_row_group_size` Target row group size in rows. `1000000`| `output_format_parquet_row_group_size_bytes` Target row group size in bytes, before compression. `536870912`| `output_format_parquet_string_as_string` Use Parquet String type instead of Binary for String columns. `1`| `output_format_parquet_fixed_string_as_fixed_byte_array` Use Parquet FIXED\_LEN\_BYTE\_ARRAY type instead of Binary for FixedString columns. `1`| `output_format_parquet_version` Parquet format version for output format. Supported versions: 1.0, 2.4, 2.6 and 2.latest (default) `2.latest`| `output_format_parquet_compression_method` Compression method for Parquet output format. Supported codecs: snappy, lz4, brotli, zstd, gzip, none (uncompressed) `zstd`| `output_format_parquet_compliant_nested_types` In parquet file schema, use name 'element' instead of 'item' for list elements. This is a historical artifact of Arrow library implementation. Generally increases compatibility, except perhaps with some old versions of Arrow. `1`| `output_format_parquet_use_custom_encoder` Use a faster Parquet encoder implementation. `1`| `output_format_parquet_parallel_encoding` Do Parquet encoding in multiple threads. Requires output\_format\_parquet\_use\_custom\_encoder. `1`| `output_format_parquet_data_page_size` Target page size in bytes, before compression. `1048576`| `output_format_parquet_batch_size` Check page size every this many rows. Consider decreasing if you have columns with average values size above a few KBs. `1024`| `output_format_parquet_write_page_index` Add a possibility to write page index into parquet files. `1`| `input_format_parquet_import_nested` Obsolete setting, does nothing. `0`| `input_format_parquet_local_time_as_utc` true Determines the data type used by schema inference for Parquet timestamps with isAdjustedToUTC=false. If true: DateTime64(..., 'UTC'), if false: DateTime64(...). Neither behavior is fully correct as ClickHouse doesn't have a data type for local wall-clock time. Counterintuitively, 'true' is probably the less incorrect option, because formatting the 'UTC' timestamp as String will produce representation of the correct local time. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Data types matching](#data-types-matching-parquet)- [Example usage](#example-usage)
      - [Inserting data](#inserting-data)- [Reading data](#reading-data)- [Format settings](#format-settings)

Was this page helpful?