Skip to content
Download full logoDownload logomark

ClickHouse engineering resources

  • How to read a RowBinary file

    Read a ClickHouse RowBinary file from your terminal with one command, using clickhouse local. RowBinaryWithNamesAndTypes is self-describing; plain RowBinary needs an explicit structure.

    Last updated: Jun 15, 2026

  • How to read a ClickHouse Native format file

    Open and query a ClickHouse Native (.native) file from your terminal with one command, using clickhouse local. The file carries its own schema, so reads need no types and lose no precision.

    Last updated: Jun 15, 2026

  • How to convert TSV to JSON

    Convert a TSV file to JSON from your terminal with clickhouse-local — the header becomes the keys and types are inferred, with no upload and no server.

    Last updated: Jun 15, 2026

  • How to convert NDJSON to CSV

    Convert a line-delimited NDJSON file to CSV from your terminal with clickhouse-local — schema auto-inferred, nested objects flattened, no server and no upload.

    Last updated: Jun 15, 2026

  • How to convert JSONL to JSON

    Turn a line-delimited JSONL file into a single JSON array from your terminal with clickhouse-local. Schema auto-inferred, types preserved, no server and no upload.

    Last updated: Jun 15, 2026

  • How to convert JSON to TSV

    Convert a JSON file to a tab-separated file from your terminal with clickhouse-local — schema auto-inferred, types preserved, nested objects flattened, no upload and no server.

    Last updated: Jun 15, 2026

  • How to convert JSON to JSONL

    Turn a top-level JSON array into JSONL (one object per line) with one clickhouse-local command — no upload, schema auto-inferred, and nested fields preserved.

    Last updated: Jun 15, 2026

  • How to convert CSV to NDJSON

    Convert a CSV file to NDJSON (newline-delimited JSON) in one command with clickhouse-local — schema auto-detected, types carried into the JSON, no upload and no server.

    Last updated: Jun 15, 2026

  • How to convert CSV to Avro

    Convert a CSV file to Avro with one clickhouse-local command. The Avro schema is derived from the column types inferred from the CSV, with no server and no upload.

    Last updated: Jun 15, 2026

  • How to convert Avro to CSV

    Convert an Avro file to CSV with one clickhouse-local command. No upload, no server, and the Avro schema is read straight from the file so types carry over.

    Last updated: Jun 15, 2026

  • What is an Avro file?

    An Avro file is a row-oriented, binary data format that embeds its own JSON schema in the file header, built for schema evolution. This page explains its structure and proves it by reading the embedded schema with clickhouse local.

    Last updated: Jun 15, 2026

  • 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: Jun 15, 2026

  • 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: Jun 15, 2026

  • 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: Jun 15, 2026

  • 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: Jun 15, 2026

<-Prev
1
…
4
5
6
…
14
Next ->