alamb commented on code in PR #3133: URL: https://github.com/apache/arrow-datafusion/pull/3133#discussion_r946024439
########## docs/source/user-guide/cli.md: ########## @@ -47,31 +33,125 @@ $ echo "1,2" > data.csv ```bash $ datafusion-cli +DataFusion CLI v11.0.0 +❯ CREATE EXTERNAL TABLE foo STORED AS CSV LOCATION 'data.csv'; +0 rows in set. Query took 0.017 seconds. +❯ select * from foo; ++----------+----------+ +| column_1 | column_2 | ++----------+----------+ +| 1 | 2 | ++----------+----------+ +1 row in set. Query took 0.012 seconds. +``` + +## Installation -DataFusion CLI v8.0.0 +### Install and run using Cargo -> CREATE EXTERNAL TABLE foo (a INT, b INT) STORED AS CSV LOCATION 'data.csv'; -0 rows in set. Query took 0.001 seconds. +The easiest way to install DataFusion CLI a spin is via `cargo install datafusion-cli`. -> SELECT * FROM foo; -+---+---+ -| a | b | -+---+---+ -| 1 | 2 | -+---+---+ -1 row in set. Query took 0.017 seconds. +### Install and run using Homebrew (on MacOS) + +DataFusion CLI can also be installed via Homebrew (on MacOS). Install it as any other pre-built software like this: + +```bash +brew install datafusion Review Comment: TIL the homebrew formuale is still updated 🎉 10.0.0 👍 ```bash alamb@MacBook-Pro-8 datafusion-cli % brew install datafusion Running `brew update --auto-update`... ==> Auto-updated Homebrew! Updated 3 taps (homebrew/core, homebrew/cask and homebrew/services). ==> New Formulae cargo-crev crytic-compile git-sync lucky-commit slither-analyzer censys gcc@11 [email protected] ouch solc-select cql-proxy gcem libvatek rush-parallel svt-av1 ==> New Casks aliwangwang imhex moderndeck playcover-community yubihsm2-sdk gittyup micromamba nanoem virtualbuddy You have 28 outdated formulae installed. You can upgrade them with brew upgrade or list them with brew outdated. ==> Downloading https://ghcr.io/v2/homebrew/core/datafusion/manifests/10.0.0 ######################################################################## 100.0% ==> Downloading https://ghcr.io/v2/homebrew/core/datafusion/blobs/sha256:030d1c76aabdc29cbb29c8538512ea5dd6e051 ==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:030d1c76aabdc29cbb29c85385 ######################################################################## 100.0% ==> Pouring datafusion--10.0.0.monterey.bottle.tar.gz 🍺 /usr/local/Cellar/datafusion/10.0.0: 9 files, 28.9MB ==> Running `brew cleanup datafusion`... ``` ########## docs/source/user-guide/cli.md: ########## @@ -47,31 +33,125 @@ $ echo "1,2" > data.csv ```bash $ datafusion-cli +DataFusion CLI v11.0.0 +❯ CREATE EXTERNAL TABLE foo STORED AS CSV LOCATION 'data.csv'; +0 rows in set. Query took 0.017 seconds. +❯ select * from foo; ++----------+----------+ +| column_1 | column_2 | ++----------+----------+ +| 1 | 2 | ++----------+----------+ +1 row in set. Query took 0.012 seconds. +``` + +## Installation -DataFusion CLI v8.0.0 +### Install and run using Cargo -> CREATE EXTERNAL TABLE foo (a INT, b INT) STORED AS CSV LOCATION 'data.csv'; -0 rows in set. Query took 0.001 seconds. +The easiest way to install DataFusion CLI a spin is via `cargo install datafusion-cli`. -> SELECT * FROM foo; -+---+---+ -| a | b | -+---+---+ -| 1 | 2 | -+---+---+ -1 row in set. Query took 0.017 seconds. +### Install and run using Homebrew (on MacOS) + +DataFusion CLI can also be installed via Homebrew (on MacOS). Install it as any other pre-built software like this: + +```bash +brew install datafusion +# ==> Downloading https://ghcr.io/v2/homebrew/core/datafusion/manifests/5.0.0 +# ######################################################################## 100.0% +# ==> Downloading https://ghcr.io/v2/homebrew/core/datafusion/blobs/sha256:9ecc8a01be47ceb9a53b39976696afa87c0a8 +# ==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:9ecc8a01be47ceb9a53b39976 +# ######################################################################## 100.0% +# ==> Pouring datafusion--5.0.0.big_sur.bottle.tar.gz +# 🍺 /usr/local/Cellar/datafusion/5.0.0: 9 files, 17.4MB + +datafusion-cli ``` -## DataFusion-Cli +### Run using Docker + +There is no officially published Docker image for the DataFusion CLI, so it is necessary to build from source +instead. -Build the `datafusion-cli`: +Use the following commands to clone this repository and build a Docker image containing the CLI tool. Note +that there is `.dockerignore` file in the root of the repository that may need to be deleted in order for +this to work. ```bash -cd arrow-datafusion/datafusion-cli -cargo build +git clone https://github.com/apache/arrow-datafusion +git checkout 8.0.0 Review Comment: It might make sense to update this version -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
