Search code examples
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
How to convert below date format into epoch_utc in AWS Athena?...


sqlamazon-athenaprestoepochtrino

Read More
Given a history of actions of the same kind, how can I count # of actions before/after certain point...


sqlamazon-athenapresto

Read More
Selecting common factors in different rows...


sqlamazon-athenapresto

Read More
Joining tables on Athena using a date and interval as key?...


sqljoinamazon-athenaprestotrino

Read More
AWS Athena Search for Substring in array using contains() method...


sqlamazon-athenaprestotrino

Read More
Athena gets order of operations wrong...


sqlamazon-athenaprestotrino

Read More
In postgres/presto/AWS-Athena, what's the opposite of `array_agg( (col1, col2) )` to get multipl...


sqlpostgresqlamazon-athenaprestotrino

Read More
Any_Match or Contains with Multiple Parameters...


sqlprestotrino

Read More
Arraying two array rows and display only distinct values...


sqlarraysaggregate-functionspresto

Read More
Select distinct of multiple columns from prestodb...


sqldistinctprestotrino

Read More
PRESTO: Calculating Date Difference Excluding Days: Precision in Months and Handling Greater Than 1 ...


sqlprestodatediffdate-difference

Read More
How to get month name from date in Presto...


functiondatemonthcalendarpresto

Read More
Combine WITH AS and JOIN in Presto SQL...


sqlpresto

Read More
Error while converting Presto SQL to Hive SQL containing subquery...


sqlhivepresto

Read More
Convert Timestamps to Minute to Timestamp format...


prestotrino

Read More
BackNext