Search code examples
`lag()` with `over` and `range between` returns a value if even the previous record is out of range...


sqlamazon-athenaprestotrino

Read More
How to calculate an array of differences from an original array?...


sqlarraysamazon-athenaprestotrino

Read More
what is the equivalent of Substitute function in excel to presto sql...


sqlprestodbeavertrino

Read More
How to delete data physically with Presto/Trino?...


hiveprestotrino

Read More
PrestoSQL/Trino - How to query all cases without explicit where clauses in subequery...


sqlamazon-athenaprestotrino

Read More
How can I use a fully-qualified table function in AWS Athena Federated Query Pass-Through?...


amazon-athenatrino

Read More
How to validate that each value of 'IN' statement are present in the SQL query result?...


sqlamazon-athenaprestotrinojupyterhub

Read More
Presto: How to map arrays of different length?...


sqlprestotrino

Read More
Extract from nested JSON in SQL...


sqljsonamazon-athenatrinoansi-sql

Read More
Issue with using contains array function in SQL presto...


sqlamazon-athenaprestotrino

Read More
In SQL Athena, how can I get a CSV's creation date and time?...


amazon-s3amazon-athenaprestotrino

Read More
Time Cost of UNNEST operation in query?...


sqltime-complexityprestotrinounnest

Read More
How to separate JSON key and value pair in Amazon Athena?...


sqlamazon-athenaprestotrino

Read More
Unable to format trino sql query in expected format...


sqlprestotrino

Read More
Need to format the data in trino sql...


sqlaggregate-functionsprestotrino

Read More
presto sql get string of elements to get first and second items...


sqlprestotrino

Read More
Trino cluster returns query not found error when using trino:jdbc...


kubernetesjdbctrino

Read More
presto sql to generate dynamic dictionary column after group by...


sqlprestotrino

Read More
Invoking Trino's try_cast() using SQLAlchemy...


sqlalchemytrino

Read More
Compute a new column to increment/decrement by 1 per row, in respect to a certain row set with a con...


sqlamazon-athenaprestotrino

Read More
Trino create custom table...


sqldockerprestotrino

Read More
Trino - How do I filter on dates...


sqlprestotrino

Read More
How do you escape underscores and single quotes in Amazon Athena queries?...


sqlamazon-athenaprestotrino

Read More
How to enable "Use for Hive table metadata" in "AWS Glue Data Catalog settings" ...


amazon-web-servicesterraformaws-glueamazon-emrtrino

Read More
Can't set catalog to backblaze in Trino...


amazon-web-servicesamazon-s3prestotrinobackblaze

Read More
Presto fails to read hexadecimal string: Not a valid base-16 number...


sqlprestotrino

Read More
PL/SQL to Superset/Trino - convert hexadecimal funcion...


sqlplsqlprestoapache-supersettrino

Read More
Athena/Presto Escape Underscore...


sqlamazon-athenaprestotrino

Read More
How to find how many sessions had specific action from JSON column in SQL...


sqlprestotrino

Read More
Athena query find till next value...


sqlamazon-athenaprestotrino

Read More
BackNext