You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Running any query on Athena fails with the error message "UnicodeDecodeError: 'utf-8' codec can't decode byte 0x86 in position 2: invalid start byte " when workgroup encryption is turned ON using CSE_KMS
wr.athena.read_sql_query('select count(1) as num_records from mytable', database, workgroup)
leo4ever
changed the title
Athena read_sq;_query error: UnicodeDecodeError: 'utf-8' codec can't decode byte 0x86 in position 2: invalid start byte
Athena read_sq;_query error when workgroup encryption is turned ON using CSE_KMS
Aug 16, 2024
We don't support client-side decryption when reading from Athena. I think your workgroup is forcing Athena to return encrypted data, so it doesn't matter that you didn't set the encryption parameter.
LeonLuttenberger
changed the title
Athena read_sq;_query error when workgroup encryption is turned ON using CSE_KMS
Athena read_sql_query error when workgroup encryption is turned ON using CSE_KMS
Aug 29, 2024
Describe the bug
Running any query on Athena fails with the error message "UnicodeDecodeError: 'utf-8' codec can't decode byte 0x86 in position 2: invalid start byte " when workgroup encryption is turned ON using CSE_KMS
wr.athena.read_sql_query('select count(1) as num_records from mytable', database, workgroup)
Error stack trace:
How to Reproduce
Expected behavior
No response
Your project
No response
Screenshots
No response
OS
Linux
Python version
3.10.14
AWS SDK for pandas version
3.9.0
Additional context
No response
The text was updated successfully, but these errors were encountered: