Warning

The product is in closed beta and not open to the public.

clickhouse

vb clickhouse SUBCOMMAND [OPTIONS]

Description

Perform ClickHouse operations via HTTP interface.

Options

--url URL

ClickHouse HTTP endpoint URL. Defaults to the ckdb-server setting.

--user USER

ClickHouse user name. Defaults to the ckdb-user setting.

--password PASS

ClickHouse password. Defaults to the ckdb-password setting.

Subcommands

vb clickhouse query

vb clickhouse query [OPTIONS] [SQL-STATEMENT|--file FILE]

Description

Execute a SQL query against ClickHouse and print NDJSON events. JSONEachRow results are streamed as row events followed by a summary event.

Options

--file FILE

Read SQL statement from file instead of command line

--format FORMAT

ClickHouse response format e.g. TSV, CSV, JSONEachRow (default: JSONEachRow). The CLI output is always NDJSON.

vb clickhouse schema

vb clickhouse schema [OPTIONS] SQL-FILE

Description

Read a SQL file and execute DDL statements against ClickHouse. Statements are split by semicolons and executed sequentially. Each statement and final summary are printed as NDJSON events.

Options

--recreate

Drop tables before creating them