flightsqlclient is a small command line app to query a Flight SQL server. You can find instructions to run such a server here: notes on running java FlightSqlExample.
Using homebrew
bash
brew tap timvw/tap
brew install arrow-flight-sql-client
Using cargo
bash
cargo install arrow-flight-sql-client
Using docker
bash
docker run --rm ghcr.io/timvw/arrow-flight-sql-client:v0.4.0 get-tables --hostname 192.168.1.95
When you run the app without arguments, you will be greeted with it's usage:
```bash arrow-flight-sql-client
USAGE:
client
OPTIONS: -h, --help Print help information -V, --version Print version information
SUBCOMMANDS: execute get-catalogs get-exported-keys get-imported-keys get-primary-keys get-schemas get-table-types get-tables help Print this message or the help of the given subcommand(s) ```
Listing the available tables can be done as following:
``` arrow-flight-sql-client get-tables --hostname localhost --port 52358
+--------------+----------------+------------------+--------------+ | catalogname | dbschemaname | tablename | table_type | +--------------+----------------+------------------+--------------+ | | SYS | SYSALIASES | SYSTEM TABLE | ... (removed some lines to reduce output) | | APP | FOREIGNTABLE | TABLE | | | APP | INTTABLE | TABLE | +--------------+----------------+------------------+--------------+ ```
A query can be executed as following:
``` arrow-flight-sql-client execute --query "select * from app.inttable order by value desc"
+----+--------------+-------+-----------+ | ID | KEYNAME | VALUE | FOREIGNID | +----+--------------+-------+-----------+ | 1 | one | 1 | 1 | | 2 | zero | 0 | 1 | | 3 | negative one | -1 | 1 | +----+--------------+-------+-----------+ ```