Project

aq

0.0
No commit activity in last 3 years
No release in over 3 years
Command Line Tool for AWS Athena (bq command like)
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

Runtime

~> 1.0
~> 1.0
~> 0.0
 Project Readme

aq (Athena Query CLI)

Command Line Tool for AWS Athena (bq command like)

Installation

Install by gem:

$ gem install aq

Usage

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

help

Display command help

$ aq help
$ aq help [COMMAND]

ls

Show databases or tables in specified database

$ aq ls
$ aq ls my_database_name

head

Show records in specified table

$ aq head my_db.my_table

mk

Create database

$ aq mk my_database_name

load

Create table and load data

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

rm

Drop database or table

$ aq rm my_db
$ aq rm my_db.my_table

query

Run query

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

Development

todo: write

Contributing

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