Search code examples
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
Configure trino-jvm properties in GCP Dataproc on cluster create...


google-cloud-platformgoogle-cloud-dataproctrinodataproc

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


sqlamazon-athenaprestoepochtrino

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
Trying to understand Trino and how it handles Time Zones...


timezonedbeavertimestamp-with-timezonetrino

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
Select distinct of multiple columns from prestodb...


sqldistinctprestotrino

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


prestotrino

Read More
In Presto SQL, for string column, how to remove text starting from a pattern in each string?...


sqlregexprestotrino

Read More
Getting the max date per each Key per user...


sqlgroup-byprestotrino

Read More
PrestoDB -- Select rows where varchar column is in array query...


sqlarraysprestotrino

Read More
splitting start and end date to start_date / first day of month and end_date / last day of month...


sqlprestogaps-and-islandstrino

Read More
How to extract value from a nested JSON object key with dots...


sqljsonprestotrino

Read More
BackNext