Skip to content
Download full logoDownload logomark

ClickHouse engineering resources

  • How to read an Avro file in Python

    Read an Avro file into a DataFrame with chDB and work with it using the pandas API you already know. The embedded schema is read for you, with no struct declarations and no reader loop.

    Last updated: 2026年6月15日

  • How to read an Avro file

    Read and query an Avro file from your terminal with one command, using clickhouse local. The schema is embedded in the file, so there is no structure to declare and no import step.

    Last updated: 2026年6月15日

  • How to convert Parquet to Avro

    Convert a Parquet file to Avro from your terminal with clickhouse-local — the schema is read from the Parquet footer and carried into Avro, with no server and no upload.

    Last updated: 2026年6月15日

  • How to convert ORC to JSON

    Convert an ORC file to JSON from your terminal with one clickhouse-local command — the schema is read from the ORC footer, nested columns become nested JSON, with no upload and no server.

    Last updated: 2026年6月15日

  • How to convert JSONL to CSV

    Convert a JSONL (NDJSON) file to CSV from your terminal with clickhouse-local — schema auto-inferred, nested objects and arrays flattened into columns, no upload and no server.

    Last updated: 2026年6月15日

  • How to convert CSV to JSONL

    Convert a CSV file to JSONL (one JSON object per line) in a single command with clickhouse-local — the schema is auto-inferred and the column types are carried into the JSON, with no upload and no server.

    Last updated: 2026年6月15日

  • How to convert CSV to Arrow

    Convert a CSV file to the Arrow IPC format in one command with clickhouse-local — the schema is inferred from the CSV and the column types are embedded in the Arrow file, with no server and no upload.

    Last updated: 2026年6月15日

  • How to convert Avro to Parquet

    Convert an Avro file to Parquet with one clickhouse-local command. The schema embedded in the Avro file is read automatically and carried into Parquet, with no server and no upload.

    Last updated: 2026年6月15日

  • How to convert Arrow to CSV

    Convert an Arrow (Arrow IPC / Feather) file to CSV with one clickhouse-local command. The schema is read from the file, types carry over, and there's no upload and no server.

    Last updated: 2026年6月15日

  • What is MessagePack?

    MessagePack is a compact binary serialization format that encodes the same data model as JSON in far fewer bytes. This page explains how it is laid out and proves it by reading a real .msgpack file.

    Last updated: 2026年6月15日

  • What is an .npy file?

    An .npy file is NumPy's simple binary format for storing a single numeric array: a small text header describing dtype and shape, followed by the raw bytes. This page explains its structure and proves it by reading one with clickhouse local.

    Last updated: 2026年6月15日

  • How to read an NPY file in Python

    Read a NumPy .npy array into a DataFrame with chDB and work with it using the pandas API you already know, without loading the whole array into memory.

    Last updated: 2026年6月15日

  • How to read a .npy (NumPy) file with SQL

    Query a NumPy .npy array file with SQL from your terminal using clickhouse local. The dtype is read from the file, with no Python and no import step.

    Last updated: 2026年6月15日

  • How to read a MessagePack file in Python

    Read a MessagePack (.msgpack) file into a DataFrame with chDB. MsgPack carries no schema, so you pass the column list once and then use the pandas API you already know, running on ClickHouse's engine.

    Last updated: 2026年6月15日

  • How to read a MessagePack file

    Read a MessagePack (.msgpack) file with SQL from your terminal using clickhouse local. MsgPack carries no schema, so you pass the column structure explicitly in one command.

    Last updated: 2026年6月15日

<-Prev
1
…
6
7
8
…
15
Next ->