How do I Query Nested JSON Objects in Athena without ETL | JsonSerDe |

How do I Query Nested JSON Objects in Athena without ETL | JsonSerDe |

**************WATCH**************

How to repartition AWS S3 (Datalake) from string date column to year, month| Athena CTAS

How to repartition AWS S3 (Datalake) from string date column to year, month| Athena CTAS

SQL code Snippets

select date_format(cast( date_parse('2022-08-09','%Y-%m-%d') as date), '%m') as year

Using CTAS and INSERT INTO for ETL and data analysis | partition

How can I set the number or size of files when I run a CTAS query in Athena?

How do I add Partition to the already existing table in athena to speed up and improve performance?

How to Monitor Athena Usage to Understand Your Operations, and Control Security and Costs with Code

How we got 50X faster Speed for querying Data Lake using Athena Query & saved Thousands of dollars | Case Study

How to Flatten Complex JSON into Separate Folders for Athena Query |Glue Job | Glue Notebook

Finding PII Data in Datalake &creating Reports & Dashboard with AWS Macie and Athena & Quick Sight

Reading Simple Article assisted us in doubling or tripling the speed of Athena queries.

Setting up and using AWS Athena federated queries| Query DynamoDB with SQL Via Athena Tutorial

------ Connect With Me --------

-------------------------------------

[Amarjeet-fblk]

What if the financial array contains more than 1 element, is $0 will work?

[davevaron]

Perhaps you've done another video about the end of the article, which explains array coercion, and UNNEST. That is actually the important part. Addressing each nested index in a single query is good for incremental comprehension, but there is probably no practical use case for it. I appreciate the link to the article--i was able to get what I needed from that.

[sreekanthgs]

Hi i used this approach but im getting this error like
HIVE_CURSOR_ERROR: Row is not a valid JSON Object - JSONException: A JSONObject text must end with '}' at 2 [character 3 line 1]
anyone help me to get out of this.

[vchamala]

would this work for very large datasets like 100GB? We are taking the approach of converted these nested JSONs to Parquet and then query using Athena. Thoughts?