4 releases
0.2.1 | Nov 1, 2020 |
---|---|
0.1.2 | Jul 14, 2019 |
0.1.0-SNAPSHOT | Apr 22, 2019 |
#2885 in Command line utilities
92KB
2.5K
SLoC
xpq
xpq is a simple command line program for analyzing parquet files.
Requirements
- Rust nightly
See Working with nightly Rust to install nightly toolchain and set it as default.
Installation
Binaries for Linux and macOS are available from Github.
To install the binary download the latest release.
curl -s https://api.github.com/repos/FabioBatSilva/xpq/releases/latest \
| grep "browser_download_url" \
| grep apple-darwin \
| cut -d : -f 2,3 \
| tr -d \" \
| wget -qi -
Make it executable
chmod +x ./xpq-*-apple-darwin
mv ./xpq-*-apple-darwin /usr/local/bin/xpq
Alternatively, you can compile and install using Cargo :
cargo install xpq
You can also compile from source using cargo
cargo install --git https://github.com/FabioBatSilva/xpq.git --force
Available commands
- read - Read rows.
- count - Show num of rows.
- schema - Show parquet schema.
- sample - Randomly sample rows from parquet.
- frequency - Show frequency counts for each value.
Quick tour
Grab some parquet data :
wget -O users.parquet https://github.com/apache/spark/blob/master/examples/src/main/resources/users.parquet?raw=true
Check the schema :
xpq schema users.parquet
message example.avro.User {
REQUIRED BYTE_ARRAY name (UTF8);
OPTIONAL BYTE_ARRAY favorite_color (UTF8);
REQUIRED group favorite_numbers (LIST) {
REPEATED INT32 array;
}
}
Check the number of rows :
xpq count users.parquet
count
2
Read some data :
xpq read users.parquet
name favorite_color favorite_numbers
"Alyssa" null [3, 9, 15, 20]
"Ben" "red" []
Dependencies
~24–34MB
~661K SLoC