1 Answer
- Newest
- Most votes
- Most comments
0
Probably makes sense to try from_base64() built-in function that Athena supports
answered a year ago
Relevant content
- Accepted Answerasked 4 years ago
- asked a year ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 years ago
from_base64() will give me the zipped binary. I also need ability to unzip the data. Any built-in function to do that?
I see, apologies, i thought you have data in gz file and one of columns is base64 encoded. there's no built-in function in Athena that would extract the data in this case. If you plan to query that data multiple times i suggest to process that data before you query it with Athena.