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.
bash
brew tap timvw/tap
brew install arrow-flight-sql-client
bash
cargo install arrow-flight-sql-client
When you run the app without arguments, you will be greeted with it's usage:
```bash cargo run
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:
``` cargo run -- 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:
``` cargo run -- 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 | +----+--------------+-------+-----------+ ```