laughingman7743 / PyAthena

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
MIT License
457 stars 102 forks source link

Latest PyAthena no longer compatible with SQLAlchemy 1.4 #526

Closed jasonamyers closed 3 months ago

jasonamyers commented 3 months ago
    from pyathena.sqlalchemy.base import AthenaDialect
  File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
  File "/Users/jasonmyers/.virtualenvs/health/lib/python3.10/site-packages/ddtrace/internal/module.py", line 192, in _exec_module
    self.loader.exec_module(module)
  File "/Users/jasonmyers/.virtualenvs/health/lib/python3.10/site-packages/pyathena/sqlalchemy/base.py", line 358, in <module>
    "double": types.DOUBLE,
AttributeError: module 'sqlalchemy.types' has no attribute 'DOUBLE'

SQLAlchemy 1.4 doesn't have a DOUBLE in the types module.