Search code examples
Athena Query - "NOT IN" slow performance...


sqlamazon-web-servicesamazon-athenapresto

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
Window functions in Trino: ordering changes length of array...


sqlwindow-functionsprestotrino

Read More
Picking just a single value from Map of Arrays in SQL...


sqlarraysdictionaryprestotrino

Read More
Splitting columns of type MAP(int, Array) by other array column...


sqlprestotrinocross-joinunnest

Read More
AWS Athena parse JSON array...


sqljsonamazon-athenaprestotrino

Read More
Presto SQL-Extract sting from the last occurence of char (:) from the right...


sqlregexregex-lookaroundsprestotrino

Read More
Create json object from several columns programmatically in presto/trino/aws athena...


sqlamazon-athenaprestotrino

Read More
AWS Athena Parse array of JSON objects to rows...


sqljsonamazon-athenaprestotrino

Read More
AWS athena regex replace except first occurrence...


sqlamazon-athenaprestoregexp-replacetrino

Read More
Is this an efficient way to find overlap of two string columns...


sqlprestoset-intersection

Read More
Do a distinct in SQL, ordered by another column...


sqlpresto

Read More
Presto server on AWS - Cannot connect to discovery server...


amazon-web-servicesprestotrino

Read More
Count matching value in two columns in SQL...


sqlpresto

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


sqljsonprestotrino

Read More
Question on Presto-Prestissimo ExchangeSource...


prestopresto-prestissimovelox-acceleration

Read More
How to add column with accumulations of certain values from another column in SQL?...


pythonsqlpython-3.xdataframepresto

Read More
SQL Unnest - how to use correctly?...


sqlprestotrinounnest

Read More
How to use previous quarter's data when quarter is missing from dataset...


sqlpresto

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


sqlwindow-functionsamazon-athenaprestotrino

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


sqldatetimesequenceprestotrino

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


sqlamazon-athenaprestotrino

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


sqljoinamazon-athenaprestotrino

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


sqlhiveprestotrino

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


sqlprestotrino

Read More
use `lag()` to get previous timestamp...


sqlpostgresqlpresto

Read More
BackNext