BendSQL

Databend Native Command Line Tool

Install

sh cargo install bendsql

Usage

``` ❯ bendsql --help Databend Native Command Line Tool

Usage: bendsql [OPTIONS]

Options: --help Print help information --flight Using flight sql protocol --tls Enable TLS -h, --host Databend Server host, Default: 127.0.0.1 -P, --port Databend Server port, Default: 8000 -u, --user Default: root -p, --password [env: BENDSQLPASSWORD=] -D, --database Database name --set Settings --dsn Data source name [env: BENDSQLDSN=] -n, --non-interactive Force non-interactive mode -q, --query Query to execute -d, --data Data to load, @file or @- for stdin -f, --format Data format to load [default: csv] -o, --output

Output format [default: table] --progress Show progress for data loading in stderr -V, --version Print version ```

REPL

```sql ❯ bendsql Welcome to BendSQL. Connecting to localhost:8000 as user root.

bendsql> select avg(number) from numbers(10);

SELECT avg(number) FROM numbers(10);

┌───────────────────┐ │ avg(number) │ │ Nullable(Float64) │ ├───────────────────┤ │ 4.5 │ └───────────────────┘

1 row in 0.259 sec. Processed 10 rows, 10B (38.59 rows/s, 308B/s)

bendsql> show tables like 'd%';

SHOW TABLES LIKE 'd%';

┌───────────────────┐ │ tablesindefault │ │ String │ ├───────────────────┤ │ data │ │ data2 │ │ data3 │ │ data4 │ └───────────────────┘

4 rows in 0.106 sec. Processed 0 rows, 0B (0 rows/s, 0B/s)

bendsql> exit Bye ```

StdIn Pipe

bash ❯ echo "select number from numbers(3)" | bendsql -h localhost --port 8900 --flight 0 1 2

Put local files into stage

create stage s_temp; put fs:///tmp/a*.txt @s_temp/abc;

Features

• basic keywords highlight
• basic auto-completion
• select query support
• TBD