Search code examples
DATE_TRUNC Starting on Sunday for SQL presto (Athena)...


sqldatetimestampamazon-athenapresto

Read More
Find items for which the price has changed the most number of times...


sqlwindow-functionspresto

Read More
Avoid using JOIN with OR...


sqlprestotrino

Read More
Calculate subtotal with special condition...


sqlprestotrinosubtotal

Read More
How can I do this multi-index sum/join in SQL instead of within Python?...


sqlpandasjoinprestotrino

Read More
How to concatenate arrays grouped by another column in Presto?...


sqlprestotrino

Read More
Extract values from a JSON Array in Presto...


sqlarraysjsonprestotrino

Read More
How to convert long JSON string into seperate columns via a query...


sqlamazon-web-servicesamazon-athenaprestotrino

Read More
AWS athena (presto SQL): How to take the (set-like) union of arrays in a group by statement...


sqlamazon-web-servicesamazon-athenapresto

Read More
Parsing time format with zone in presto sql...


sqldatetimeamazon-athenaprestotrino

Read More
What does "interactive query" or "interactive analytics" mean in Presto SQL?...


amazon-web-servicesprestotrino

Read More
AWS Glue issue with double quote and commas...


hadoophiveprestoamazon-athenaaws-glue

Read More
Aggregate By Column in SQL That Results in Sample Size and % with Case When...


sqlprestotrino

Read More
Presto SQL Exploding Array to rows (but randomly sampled 100 rows)...


sqlprestotrino

Read More
Presto: Filtering by Row Number...


sqlfilterprestorow-numbertrino

Read More
Is there a way to cast string to date to int in athena?...


sqlamazon-web-servicesamazon-athenaprestotrino

Read More
Add missing values in each group using presto or mysql...


sqlmysqldatabasepresto

Read More
How to use aggregation within a case statement?...


sqlamazon-web-servicesamazon-athenaprestotrino

Read More
SQL How do I generate a row with value 0 of customers in days without order...


sqlamazon-athenaprestotrino

Read More
How to compute cosine similarity between two texts in presto?...


sqlprestotext-processingcosine-similaritytrino

Read More
Athena: Calculating Age from String "birth_dt" Column...


sqldatetimeamazon-athenaprestotrino

Read More
How do I sum for all of true/false of each WITH SELECT to the final result in Athena?...


sqlamazon-athenapresto

Read More
Athena unnest for nested Array string column...


sqlamazon-web-servicesamazon-athenaprestotrino

Read More
AWS Athena How to check for numeric value before multiplying the value...


sqlamazon-web-servicesamazon-athenaprestotrino

Read More
Regular expression to stop at first match of one or the other character...


sqlregexprestotrino

Read More
Comparing string variables in Athena...


sqlamazon-athenapresto

Read More
Presto/Trino - static date and timestamp in where clause...


prestotrino

Read More
Does Presto cache intermediate results internally out of the box?...


sqlamazon-athenaprestotrino

Read More
Nginx loadbalancing configuration...


nginxcentosprestonginx-reverse-proxynginx-config

Read More
String concatenation in AWS Glue Athena?...


string-concatenationaws-glueprestoamazon-athena

Read More
BackNext