Skip to content
Download full logoDownload logomark

ClickHouse engineering resources

  • Run SQL across multiple CSV or Parquet files

    Query a whole directory of CSV or Parquet files as one table with clickhouse-local. A glob path reads them all, aggregates run across every file, and a virtual column tells you which file each row came from.

    Last updated: 2026年6月15日

  • Read Avro from a schema registry with clickhouse-local

    Read a plain .avro file with one command, and use the AvroConfluent format plus format_avro_schema_registry_url to read Confluent-framed Avro messages from a Kafka Schema Registry.

    Last updated: 2026年6月15日

  • How to query a mysqldump file without importing

    Run SQL against the tables inside a mysqldump .sql file directly with clickhouse-local. No MySQL server, no restore step — the INSERT statements are read as a table.

    Last updated: 2026年6月15日

  • How to convert Avro to JSON

    Convert an Avro file to JSON with one command using clickhouse-local. The schema is read from the Avro file itself, types are carried into JSON, and there is no upload and no server.

    Last updated: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

  • 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: 2026年6月15日

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