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