aq (Athena Query CLI)

Command Line Tool for AWS Athena (bq command like)

Install by gem:

$ gem install aq

All commands need --bucket option because Athena stores query result into S3. You can specify it by AQ_DEFAULT_BUCKET environment variable.

Display command help

$ aq help
$ aq help [COMMAND]

Show databases or tables in specified database

$ aq ls
$ aq ls my_database_name

Show records in specified table

$ aq head my_db.my_table

Create database

$ aq mk my_database_name

Create table and load data

$ aq load my_db.my_table s3://my_bucket/my_object_key/ test/resource/schema.json --partitioning dt:string

Drop database or table

$ aq rm my_db
$ aq rm my_db.my_table

Run query

$ aq query 'SELECT * FROM "test"."test_logs" limit 10;'

todo: write

Bug reports and pull requests are welcome on GitHub at https://github.com/mia-0032/aq