Search code examples
Presto sql: presto extract substring for the last occurrence of character in string...


sqlsubstringprestotrino

Read More
How to validate data is Hexadecimal in Presto...


sqlhexprestotrino

Read More
SQL - Replace column values with another table column ONLY where they match, else keep original valu...


sqlprestoamazon-athena

Read More
Most direct way to check if array contains any non-null values...


sqlprestotrino

Read More
How to create an array by replacing values from another array?...


sqlamazon-athenaprestotrino

Read More
Presto: Aggregate the arrays for all columns...


sqlarraysdistinctprestotrino

Read More
SQL Query include row when at least one of three fields is not null...


sqlnullpresto

Read More
How can I query attributes with struck array data type?...


sqlamazon-athenaprestotrinounnest

Read More
How to search for a value that matches a condition...


sqlpresto

Read More
Set True to duplicate records that occur within 1 hour window...


sqlwindow-functionsamazon-athenaprestotrino

Read More
How to duplicate same row X number of times based on the value of a column?...


sqlamazon-web-servicesamazon-athenaprestotrino

Read More
Athena unable to parse date using OpenCSVSerde...


csvhiveopencsvamazon-athenapresto

Read More
Preserve columns names case in Parquet produced by UNLOAD...


parquetamazon-athenaprestotrino

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


sqlamazon-athenaprestotrino

Read More
AWS Athena: Right function...


sqlamazon-athenaprestotrino

Read More
SQL join: unnesting rows with same column names (but different data) without resorting to aliases...


sqljoinpivotprestounnest

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


sqlarraysamazon-athenaprestotrino

Read More
Proper Case in Athena SQL...


sqlamazon-web-servicescaseamazon-athenapresto

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
How to lag using dynamic offset in SQL AWS Athena?...


sqlamazon-athenapresto

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


sqlamazon-athenaprestotrino

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