Athena client to do query on Amazon Athena
Project description
PyAthena
A python client to query on Athena Database. Query results are formatted in pandas dataframe.
Install
pip install git+https://github.com/yardstick17/PyAthena.git
Usage
In [9]: from athena import Athena
In [10]: query = """SELECT col1, col2, col3, col3
FROM "database"."table1"
WHERE col1 = 'PI912A0CV-O12'
AND col2 = '2019-03-04'
AND schema='best_model_ever'
"""
In [11]: df = athena_client.execute_with_pandas(query=query)
In [12]: df.head()
Out[12]:
col1 col2 col3 col3
0 PI912A0CV-O12 2019-03-04 0.0 2.623155
1 PI912A0CV-O12 2019-03-04 0.0 2.095256
2 PI912A0CV-O12 2019-03-04 0.0 1.904961
3 PI912A0CV-O12 2019-03-04 0.0 0.829332
4 PI912A0CV-O12 2019-03-04 0.0 0.058469
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
python-athena-0.2.1.tar.gz
(1.7 kB
view hashes)
Built Distribution
Close
Hashes for python_athena-0.2.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a811c6cc6681ad2294bf60c83d6775adf686fe665ccb8f68d17c2caa03da2cc0 |
|
MD5 | 70da151253718fa39e98e6f9667b5212 |
|
BLAKE2b-256 | 6670fb9c38aa35c702fd0b1389facdb373c6156c62312879ca8c55a289cdea2a |