Skip to content
Download full logoDownload logomark

ClickHouse engineering resources

  • How to query a Parquet file from the command line

    Open and query a Parquet file from your terminal with one command, using clickhouse local. No server, no schema declaration, no import step.

    Last updated: 2026年6月8日

  • How to flatten nested JSON in Python

    Flatten JSON with nested objects and arrays-of-objects into a tidy pandas DataFrame using chDB. Change one import line and the pandas code you already write keeps working on large files.

    Last updated: 2026年6月8日

  • How to convert TSV to Parquet

    Convert a tab-separated file to Parquet from your terminal with clickhouse-local — schema inferred from the TSV, types carried into Parquet, zstd compression by default. No upload, no server.

    Last updated: 2026年6月8日

  • How to convert TSV to CSV

    Convert a tab-separated file to comma-separated from your terminal with clickhouse-local — one command, header preserved, types inferred, no upload and no row limit.

    Last updated: 2026年6月8日

  • How to convert Parquet to TSV

    Convert a Parquet file to tab-separated values with one clickhouse-local command. Types are read from the Parquet footer, nothing is uploaded, and files larger than RAM stream through.

    Last updated: 2026年6月8日

  • How to convert Parquet to NDJSON

    Convert a Parquet file to NDJSON from your terminal with clickhouse-local — one command, no server and no upload, with the Parquet schema read straight from the file footer.

    Last updated: 2026年6月8日

  • How to convert Parquet to JSONL

    Convert a Parquet file to newline-delimited JSON (JSONL) with one clickhouse-local command — schema read from the Parquet footer, types carried into JSON, nested columns preserved. No server, no upload.

    Last updated: 2026年6月8日

  • How to convert Parquet to JSON

    Convert a Parquet file to JSON from your terminal with clickhouse-local — the schema is read from the Parquet footer, and typed and nested columns carry straight into JSON. No server, no upload.

    Last updated: 2026年6月8日

  • How to convert Parquet to CSV

    Convert a Parquet file to CSV from your terminal with clickhouse-local — one command, schema read from the file, types written as text, no upload and no server.

    Last updated: 2026年6月8日

  • How to convert NDJSON to Parquet

    Convert an NDJSON (or JSONL) file to Parquet with one clickhouse-local command — the schema is auto-inferred and nested objects and arrays are carried straight into Parquet, with no upload and no server.

    Last updated: 2026年6月8日

  • How to convert JSONL to Parquet

    Convert a JSONL file to Parquet with one command using clickhouse-local — column types are inferred automatically and nested objects become real Parquet structs, with no server and no upload.

    Last updated: 2026年6月8日

  • How to convert JSON to Parquet

    Convert a JSON or NDJSON file to Parquet with one clickhouse-local command — schema is inferred automatically and types are carried across, including nested objects, with no server and no upload.

    Last updated: 2026年6月8日

  • How to convert CSV to TSV

    Convert a CSV file to tab-separated values in one command with clickhouse-local. The header is kept, column types are carried over, and nothing is uploaded.

    Last updated: 2026年6月8日

  • How to convert CSV to Parquet

    Convert a CSV file to Parquet with one command using clickhouse-local — types are inferred from the CSV, you choose the compression codec, and there is no upload and no server.

    Last updated: 2026年6月8日

  • How to analyze log files with SQL

    Query raw nginx, Apache, or application logs in place with clickhouse-local. No server, no pipeline, no import step: one binary, SQL, and the file on disk.

    Last updated: 2026年6月8日

<-Prev
1
…
10
11
12
…
15
Next ->