Extracting JSON objects in Athena / Presto for dynamic keys...

Consecutive weeks a title is in Top 10...

How to compute a median in PrestoSQL?...

Presto SQL to select all records between the current date/time and 36 hours ago...

Difference between sum and count in aggregate case statement...

HIVE_METASTORE_ERROR expected 'STRING' but 'STRING' is found...

How to map id with name in presto...

Bring the last date (result)...

Presto query: Find the key with maximum value in a map...

In Athena how do I query a member of a struct in an array in a struct?...

How to remove NULL from array in Athena...

unnesting empty or null array leading to missing rows...

What is the best way to dynamically fill values in SQL based on conditions from other columns from p...

Athena Query: Convert Server Timing JSON to Date-wise Aggregated Columns...

group by/ aggregate in sql presto athena...

unnesting an array into two other array sql (athena/presto)...

sql athena/presto check if value in array of nested json...

Presto | Athena: Duplicated values in not key column...

Extract all values from JSON...

Create new columns from String Columns that looks like JSON...

Presto/Athena - query to discover JSON attribute frequencies?...

Athena SQL - Unable to UNNEST JSON string as desired...

Athena query JSON Array without struct...

Extracting string value before bracket using regexp in Athena...

How to select the last element of a JSON array in AWS Athena?...

Perform Value Count with Specific Conditions inside subwindows SQL Presto...

how to convert TIMESTAMP WITH TIMEZONE to TIMESTAMP but keeping local time in SQL...

How to convert bigint into timestamp in Presto SQL?...

Create flattened array from array of JSON values Athena...

PRESTO SQL conversion into Databricks SQL...