PyAthena

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.

MIT License

Downloads
11.4M
Stars
459
Committers
23
View Code on GitHub
Ecosystems: Amazon Web Services, Python

Bot releases are visible (Hide)

PyAthena - v1.11.1

Published by laughingman7743 about 4 years ago

  • Add keep_default_na, na_values and quoting arguments to the PandasCursor execute method.
PyAthena - v1.11.0

Published by laughingman7743 over 4 years ago

  • Support for canceling query execution on KeyboardInterrupt.
PyAthena - v1.10.8

Published by laughingman7743 over 4 years ago

  • Fix types mismatch in the pandas.DataFrame.to_sql method.
    Thanks @RiccardoDiGuida, @thibault-ketterer. (laughingman7743/PyAthena/issues/145, laughingman7743/PyAthena/issues/146)
PyAthena - v1.10.7

Published by laughingman7743 over 4 years ago

  • Fix an overflow error in PandaCursor.
    Thanks @juviasuisei @KneeShard. (laughingman7743/PyAthena/issues/141)
PyAthena - v1.10.6

Published by laughingman7743 over 4 years ago

  • Add the following query execution statistics.
    Thanks @navi86. (laughingman7743/PyAthena/pull/140)
    • query_queue_time_in_millis
    • total_execution_time_in_millis
    • query_planning_time_in_millis
    • service_processing_time_in_millis
    • data_manifest_location
PyAthena - v1.10.5

Published by laughingman7743 over 4 years ago

  • Fix invalid requests when only workgroups are specified.
    Thanks @kanga333. (laughingman7743/PyAthena/issues/136)
  • Support partitioning with to_sql method in utility package.
PyAthena - v1.10.4

Published by laughingman7743 over 4 years ago

  • Support China region endpoints.
    Thanks @liangruibupt. (laughingman7743/PyAthena/issues/134)
PyAthena - v1.10.3

Published by laughingman7743 over 4 years ago

  • Fix work_group condition when referencing query cache.
    Thanks @Jason-Crowe. (laughingman7743/PyAthena/issues/130)
  • Changed date and datetime type conversion in query parameter format to use literal values in all cases.
    Thanks @EdwardJRoss. (laughingman7743/PyAthena/issues/126)
PyAthena - v1.10.2

Published by laughingman7743 over 4 years ago

  • Fix parameter format of Decimal type.
    Thanks @EdwardJRoss. (laughingman7743/PyAthena/issues/121)
PyAthena - v1.10.1

Published by laughingman7743 over 4 years ago

  • Fix PandasCursor to not ignore rows containing only null values.
    Thanks @EdwardJRoss. (laughingman7743/PyAthena/issues/117)
  • Support utility queries in PandaCursor
    Thanks @radcheb. (laughingman7743/PyAthena/issues/114)
  • Implement to_sql method in utility package.
PyAthena - v1.10.0

Published by laughingman7743 almost 5 years ago

  • Support pandas.to_sql.
    See README for details.
    Thanks @kismsu, @DyfanJones. (laughingman7743/PyAthena/issues/101, laughingman7743/PyAthena/pull/110)
  • Support executemany method with Cursor and PandasCursor.
PyAthena - v1.9.0

Published by laughingman7743 almost 5 years ago

  • Redesign Formatter and Converter classes.
    You can now customize dtypes and converters for the Dataframe object.
    See README for details.
  • Support Bool column NA value in PandasCursor.
    Thanks @tanguycdls, @mzhang13. (laughingman7743/PyAthena/issues/100, laughingman7743/PyAthena/issues/102, laughingman7743/PyAthena/pull/103)
  • Change s3_staging_dir argument to optional.
    Thanks @nitin-kakkar. (laughingman7743/PyAthena/issues/99)
PyAthena -

Published by laughingman7743 about 5 years ago

  • Implement query result caching.
    See README for details.

    You can attempt to re-use the results from a previously run query to help save time and money in the cases where your underlying data isn't changing.
    Set the cache_size parameter of cursor.execute() to a number larger than 0 to enable cacheing. (Cacheing is turned off by default.)

    Thanks @kbrose. (laughingman7743/PyAthena/pull/96)

PyAthena -

Published by laughingman7743 about 5 years ago

  • Check that column_default is not nan.
    Thanks @capitancambio. (laughingman7743/PyAthena/pull/94)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Support SQLAlchemy 1.3.0.
  • Exclude tests from dist package.
    Thanks @gaqzi. (laughingman7743/PyAthena/pull/86)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Implement AsyncPandasCursor.
    Thanks @JivanRoquet. (/issues/81)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Fix Pandas to lazy import.
    Thanks @sroussi. (laughingman7743/PyAthena/issues/82)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Support integer NA values in PnadasCursor.
    Restrict the allowable version of Pandas(>=0.24.0).
    Thanks @austinlostinboston, @mckeown12 and @xinluo-gogovan. (laughingman7743/PyAthena/issues/60)
  • Drop Python 3.4 support.
    It will work with Python 3.4 unless you use PandasCusrsor.
PyAthena -

Published by laughingman7743 over 5 years ago

  • Support Python 3.7.
PyAthena -

Published by laughingman7743 over 5 years ago

  • Allow s3_staging_dir to be overridden in query execution.
    Thanks @aidin36. (laughingman7743/PyAthena/issues/53)
  • Support work_group parameter in query execution.
    Thanks @sharath-thirunagaru. (laughingman7743/PyAthena/issues/69)
  • Fix cursor constructor argument to be overridden by cursor method kwargs.
  • Aggregate retry settings into RetryConfig object.
  • Restrict the allowable version of SQLAlchemy(>=1.0.0, <1.3.0).
Package Rankings
Top 1.64% on Pypi.org
Top 24.98% on Conda-forge.org
Related Projects
py-data-api

A user-friendly client for AWS Aurora Serverless's Data API

03 Jun 2019 40
aws-sdk-pandas

pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, Qu...

26 Feb 2019 3,791