Search code examples
In Athena how do I query a member of a struct in an array in a struct?...


sqljsonprestoamazon-athena

Read More
How to remove NULL from array in Athena...


sqlarraysamazon-athenaprestotrino

Read More
unnesting empty or null array leading to missing rows...


sqlprestotrinounnest

Read More
What is the best way to dynamically fill values in SQL based on conditions from other columns from p...


sqlprestotrino

Read More
Athena Query: Convert Server Timing JSON to Date-wise Aggregated Columns...


sqlamazon-athenaprestotrino

Read More
group by/ aggregate in sql presto athena...


sqlamazon-athenaprestotrino

Read More
unnesting an array into two other array sql (athena/presto)...


sqlamazon-athenaprestotrino

Read More
sql athena/presto check if value in array of nested json...


sqlamazon-athenaprestotrino

Read More
Presto | Athena: Duplicated values in not key column...


sqldistinctprestotrino

Read More
How do I get the index (position) of an element from a json array in presto?...


presto

Read More
Extract all values from JSON...


sqljsonprestotrino

Read More
Create new columns from String Columns that looks like JSON...


sqljsonamazon-athenaprestotrino

Read More
Presto/Athena - query to discover JSON attribute frequencies?...


jsonamazon-web-servicesamazon-athenapresto

Read More
Athena SQL - Unable to UNNEST JSON string as desired...


sqlamazon-athenaprestotrino

Read More
Athena query JSON Array without struct...


sqlaws-glueamazon-athenaprestotrino

Read More
Extracting string value before bracket using regexp in Athena...


sqlamazon-athenaprestotrino

Read More
How to select the last element of a JSON array in AWS Athena?...


sqljsonamazon-athenaprestotrino

Read More
Perform Value Count with Specific Conditions inside subwindows SQL Presto...


sqlwindow-functionsamazon-athenaprestogaps-and-islands

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


sqlarraysdistinctprestotrino

Read More
Athena/Trino/Presto code to parse text file with custom line separator...


amazon-athenaprestotext-processingtrino

Read More
how to convert TIMESTAMP WITH TIMEZONE to TIMESTAMP but keeping local time in SQL...


sqlprestotrino

Read More
How to convert bigint into timestamp in Presto SQL?...


sqlprestotrino

Read More
Create flattened array from array of JSON values Athena...


sqlamazon-web-servicesamazon-athenaprestotrino

Read More
PRESTO SQL conversion into Databricks SQL...


sqlpivot-tabledatabricksaggregate-functionspresto

Read More
Conditional Row Numbering - PrestoDB...


sqldatabasepresto

Read More
SQL to find multiple occurence of a substring in a column of type varchar and its value...


sqljsonamazon-athenaprestotrino

Read More
Athena calculate count per month from a date to current timestamp...


sqlamazon-athenaprestotrino

Read More
Exploding column by delimiter and using prefix of split column name as value...


sqlprestounpivot

Read More
Grafana SQL template variables (value, text)...


sqlgrafanapresto

Read More
Select Top # in Presto SQL?...


sqlpresto

Read More
BackNext