DataFusion Command-line Interface

DataFusion is an extensible query execution framework, written in Rust, that uses Apache Arrow as its in-memory format.

The DataFusion CLI allows SQL queries to be executed by an in-process DataFusion context.

```ignore USAGE: datafusion-cli [OPTIONS]

OPTIONS: -c, --batch-size The batch size of each query, or use DataFusion default -f, --file ... Execute commands from file(s), then exit --format [default: table] [possible values: csv, tsv, table, json, nd-json] -h, --help Print help information -p, --data-path Path to your data, default to current directory -q, --quiet Reduce printing other than the results and work quietly -r, --rc ... Run the provided files on startup instead of ~/.datafusionrc -V, --version Print version information ```

Example

Create a CSV file to query.

bash,ignore $ echo "1,2" > data.csv

```sql,ignore $ datafusion-cli

DataFusion CLI v8.0.0

CREATE EXTERNAL TABLE foo (a INT, b INT) STORED AS CSV LOCATION 'data.csv'; 0 rows in set. Query took 0.001 seconds.

SELECT * FROM foo; +---+---+ | a | b | +---+---+ | 1 | 2 | +---+---+ 1 row in set. Query took 0.017 seconds. ```

DataFusion-Cli

Build the datafusion-cli.

bash cd arrow-datafusion/datafusion-cli cargo build