How to create a lag year variable in Amazon Athena Environment using SQL...

transform json in aws athena...

Filtering out array elements if element contains specified string by SQL...

Trying to convert json to string (Athena AWS)...

Import Parquet files with non-compliant field names into AWS Athena...

random sample of size N in Athena...

Building a view from a JSON stringified array of objects in the original table column...

Count and group rows for each 24 hour period in sql...

How do we get dict like string column in Presto from multiple columns?...

How to combine multiple columns in one array in Presto...

How to create (explode) separate rows using two array columns in presto/SQL...

alias a table returning function (UNNEST) using pypika...

How to check Trino version with SQL query?...

Trino API to get query history...

How to select multiple values from JSON array...

Query String Array JSON...

Validate if random IPs stored in a table belong to a set of subnets stored in another table...

Athena Nested Json Extract...

Select all columns except one when joining two tables in AWS Athena...

How to Migrate from Athena to "local" Presto +?...

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...

AWS Athena: Right function...

How to map id with name in presto...

Bring the last date (result)...

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