Are json with double quotes treated differently in Presto?...

Why does Athena report "The specified key does not exist" when inserting to an Iceberg tab...

SQL Unnest - how to use correctly?...

Using LEAD and LAG on ragged time series...

Trino/Presto SQ: Replace NULL with a value only if the NULL comes after the first non-NULL value in ...

Is there a function to extract the time part of a datetime variable in Trino SQL?...

How can I expand six days beyond each date in a list of arbitrary dates?...

In Trino/Presto SQL: Create a new column that accounts (enumerates) for change in sequence per group...

How to do a non-equi join in SQL with multiple time ranges per group?...

LAG function to return previous rows by discarding null values...

splitting a dict-like varchar column into multiple columns using SQL presto...

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

How do you define a primary key on a table in Trino?...

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

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

Athena Nested Json Extract...

How to map id with name in presto...

Bring the last date (result)...

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

How to remove NULL from array in Athena...

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