Skip to content
Download full logoDownload logomark

ClickHouse engineering resources

  • How to convert CSV to ORC

    Convert a CSV file to columnar ORC with one clickhouse-local command — no upload and no server, the schema is inferred from the CSV and the types are carried into the ORC file.

    Last updated: Jun 8, 2026

  • How to convert CSV to JSON

    Convert a CSV file to JSON from your terminal with clickhouse-local — one object per line or a single JSON array, schema auto-inferred and types preserved, with no upload and no server.

    Last updated: Jun 8, 2026

  • What is a Parquet file?

    A Parquet file is an open, column-oriented, compressed storage format for tabular data, built for analytics. This page explains its internal structure and proves it by reading a real file's metadata.

    Last updated: Jun 8, 2026

  • What is NDJSON / JSON Lines?

    NDJSON (newline-delimited JSON), also called JSON Lines, stores one JSON object per line. This page explains the format, how it differs from a single JSON array, and proves it by reading a real file with clickhouse local.

    Last updated: Jun 8, 2026

  • What is clickhouse-local? Run SQL on any file or data source, no server

    clickhouse-local is a small, fast, standalone build of ClickHouse that runs full ClickHouse SQL over local and remote files (and external databases) from a single binary, with no server to install or start.

    Last updated: Jun 8, 2026

  • What is chDB? In-process ClickHouse for Python

    chDB is an in-process SQL OLAP engine for Python: an embedded build of ClickHouse you pip install and call directly, running full ClickHouse SQL over files, DataFrames, and remote sources with no server to start.

    Last updated: Jun 8, 2026

  • What is a TSV file?

    A TSV file is a plain-text table whose columns are separated by tab characters, optionally with a header row. This page explains the format, how it differs from CSV, and proves it by reading a real TSV with clickhouse local.

    Last updated: Jun 8, 2026

  • How to run SQL on a JSONL file

    Query a .jsonl file (one JSON object per line) with SQL straight from your terminal using clickhouse local. Keys become columns, types are inferred, no server and no import step.

    Last updated: Jun 8, 2026

  • How to query a JSON file with SQL

    Query a JSON file with SQL directly from your terminal using clickhouse local. Reads line-delimited JSON or a top-level array, infers nested objects and arrays, with no server and no import step.

    Last updated: Jun 8, 2026

  • How to run SQL on a CSV file

    Query a CSV file with SQL directly from your terminal using clickhouse-local — header and column types are auto-detected, with no database and no import step.

    Last updated: Jun 8, 2026

  • How to read a TSV file in Python (faster than pandas)

    Read a tab-separated file into a DataFrame with chDB, a drop-in replacement for pandas. Change one import line and your existing pandas code runs on ClickHouse's engine, so it stays fast as files grow.

    Last updated: Jun 8, 2026

  • How to read a semicolon-separated file

    Query a semicolon-delimited file (European-style CSV) with SQL from your terminal using clickhouse local — set the field delimiter to ";", with no database and no import step.

    Last updated: Jun 8, 2026

  • How to read a pipe-delimited file

    Query a pipe-delimited (|) file with SQL from your terminal using clickhouse local. Set the field delimiter to a pipe, let the header and types be detected, and run.

    Last updated: Jun 8, 2026

  • How to read a Parquet file in Python (faster than pandas)

    Read a Parquet file into a DataFrame with chDB, a drop-in replacement for pandas. Change one import line and your existing pandas code runs on ClickHouse's engine, so it stays fast as files grow.

    Last updated: Jun 8, 2026

  • How to read an NDJSON file in Python (faster than pandas)

    Read an NDJSON file into a DataFrame with chDB, a drop-in replacement for pandas. Change one import line and your existing pandas code runs on ClickHouse's engine, so it stays fast as files grow.

    Last updated: Jun 8, 2026

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