PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
MIT License
Bot releases are hidden (Show)
Published by laughingman7743 12 months ago
json_serializer
and json_deserializer
engine/dialect paremeters by @edgarrmondragon in https://github.com/laughingman7743/PyAthena/pull/486
Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.9...v3.0.10
Published by laughingman7743 over 2 years ago
Published by laughingman7743 almost 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 almost 4 years ago
na_values
in PandasCursor from None
to empty character
.na_values
to None
in the argument of the execute method.
import pyathena
from pyathena.pandas.cursor import PandasCursor
cursor = pyathena.connect(s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
region_name="us-west-2",
cursor_class=PandasCursor).cursor()
df = cursor.execute("SELECT * FROM many_rows",
na_values=None).as_pandas()
Thanks @EdwardJRoss. (#204)Published by laughingman7743 almost 4 years ago
na_values
in PandasCursor from None
to empty character
.na_values
to None
in the argument of the execute method.
import pyathena
from pyathena.pandas_cursor import PandasCursor
cursor = pyathena.connect(s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
region_name="us-west-2",
cursor_class=PandasCursor).cursor()
df = cursor.execute("SELECT * FROM many_rows",
na_values=None).as_pandas()
Thanks @EdwardJRoss. (#204)Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
pyathena.pandas
.execution_time_in_millis
field from the cursor and result set object. (Same as the engine_execution_time_in_millis
field)Published by laughingman7743 about 4 years ago
Published by laughingman7743 about 4 years ago
Published by laughingman7743 over 4 years ago
Published by laughingman7743 over 4 years ago
Published by laughingman7743 over 4 years ago
Published by laughingman7743 over 4 years ago