arrow_cli 0.5.0

A command line tool for interacting with server in Flight SQL protocol
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84

---
name: arrow-cli
description: Use `arrow_cli` to connect to a Flight SQL server and run SQL.
---

# arrow_cli

`arrow_cli` is a command-line client for connecting to a Flight SQL server and executing SQL queries.

## Install

```bash
cargo install arrow_cli
```

After installation, confirm that the binary is available:

```bash
arrow_cli --version
```

## Usage

### Execute one SQL statement and exit

```bash
arrow_cli --host localhost --port 8900 --user admin --password abc --command "select 1"
```

Output:

```text
+----------+
| Int64(1) |
+----------+
| 1        |
+----------+

1 rows in set (tickets received in 0.008 sec, rows received in 0.012 sec)
```

### Pipe SQL through standard input

```bash
echo "select 1" | arrow_cli --host localhost --port 8900 --user admin --password abc
```

### Option: print the result schema

```bash
arrow_cli --host localhost --port 8900 --user admin --password abc --print-schema --command "select 1"
```

Output:

```text
+----------+
| Int64(1) |
+----------+
| 1        |
+----------+

Schema {
    fields: [
        Field {
            name: "Int64(1)",
            data_type: Int64,
        },
    ],
    metadata: {},
}

1 rows in set (tickets received in 0.008 sec, rows received in 0.010 sec)
```

### Option: output formats

- `--output table`: pretty table output with row count and timing summary
- `--output json`: line-delimited JSON rows
- `--output csv`: comma-separated rows without headers
- `--output tsv`: tab-separated rows without headers
- `--output psv`: pipe-separated rows without headers

Run `arrow_cli --help` for more usage details.