Skip to content
Advertisement

How to parsing Json in AWS Athena?

I want to parse the JSON column in Athena but I have a problem in one column. The column includes an escape character. I don’t know if this problem. I want to reach to Message. You can see below sample data and Message under Return. Thanks

This is the JSON.

Advertisement

Answer

If you take only the object which contains return you can parse return into json with json_parse since it contains an encoded string not an json object:

Output:

_col0
Do not person you have called
User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement