SyntaxError when importing AthenaDialect about pyathena HOT 5 CLOSED

I have confirmed that the error occurs in SQLAlchemy 1.x. I will fix it.

from pyathena.

Awesome, thanks @laughingman7743!

FWIW I found this commit sqlalchemy/sqlalchemy@91501e0 which alludes to the cause of this issue:

Additionally, to support annotations for methods that
make use of @decorator, @Generative etc., modified
format_argspec_plus to no longer return "args", instead
returns "grouped_args" which is always grouped and
allows return annotations to format correctly.

This seems to be relevant since AthenaDialect.get_view_definition() is decorated with @sqlalchemy.engine.reflection.cache.

from pyathena.

Strange, all tests pass.
https://github.com/laughingman7743/PyAthena/actions/runs/6242621017
What version of SQLAlchemy are you using?

from pyathena.

https://github.com/laughingman7743/PyAthena/blob/v3.0.7/pyathena/sqlalchemy/base.py#L1108
It seems that an error is occurring with this type hint, so it may be possible to remove this type hint. I don't think the type hint is required.

from pyathena.

I'm having this issue with SQLAlchemy 1.4.49.

from pyathena.