PyAthena icon indicating copy to clipboard operation
PyAthena copied to clipboard

Support for struct types

Open laughingman7743 opened this issue 1 year ago • 4 comments

https://github.com/googleapis/python-bigquery-sqlalchemy/blob/main/sqlalchemy_bigquery/_struct.py

laughingman7743 avatar Jun 27 '23 09:06 laughingman7743

Does this mean we can use STRUCT from BigQuery to construct Table() in pyathena and run queries on them? @laughingman7743 ?

yuvi17 avatar Oct 08 '23 06:10 yuvi17

Or is this issue for an implementation similar to this?

yuvi17 avatar Oct 08 '23 06:10 yuvi17

https://docs.aws.amazon.com/athena/latest/ug/data-types.html Athena has Struct as a data type, and BigQuery's implementation of the Struct type should be helpful in implementing support for it.

laughingman7743 avatar Oct 08 '23 07:10 laughingman7743

Thanks @laughingman7743 I will try it out and post the results here. Might be helpful for others

yuvi17 avatar Oct 08 '23 07:10 yuvi17