Selecting Child Object in Presto Query

How to use RJDBC to connect to Presto on EMR?

Out of range integer: infinity

Presto To Postgres Not able to query

Presto CLI command in a for loop

python json.decoder.JSONDecodeError: on executing prestodb query

SQL Count Matches

Aggregate expression issue with GROUPBY

Insert into static hive partition using Presto

REGEX Simple Pattern

How to take max between two values in presto?

How to parse hours into human readable string in Presto? (decimal to time)

How to turn off or reduce frequency of NODE_INFO_PER_URI_SQL in presto

Trying to explode an array with unnest() in Presto and failing due to extra column

How can I get stack log while running Presto in my IDE?

Athena - count of case statement

Duplicates with condition (SQL)

Place product_id into a price range

duplicates with condition

Connecting Presto and Apache SuperSet

How to create a reference for a parsed field in a query in AWS Athena?

Filter customers with atleast 3 transactions a year for the past 2 years Presto/SQL

presto production cluster + minimal presto workers machines in cluster

How to UNNEST a column with nested array values in Presto SQL?

Count exclusive and shared product_ids for each merchant_id

hive accesses orc external table by position rather than column name

Check if entry exists in other column and then classify as exists_in_both_col; exists_in_colA;exists_in_colB

SQL Join: have all values from both sides with an accumulative condition (Presto/AWS Athena)

SQL query to find sum of products based on store_id, product_category and product_status

What is the alternative of datefromparts in Presto (AWS Athena)

in presto, how to use max_by twice with two conditions on the same filed?

Presto Rest API [ in Presto version 333]

Is there a way to flatten a struct field in AWS Athena?

Count shared and exclusive product_ids

Installing Presto on Google VM

Query AWS Presto with native .NET library

How to select max date if table exist in Presto

How to insert line break in between ranked items in SQL?

UNNEST returns no rows for empty array

SQL: How to Get The Average of Each Column Using Group By

What is cardinality() in presto sql?

Difference between JOIN expressions in Presto SQL

How to get a list of all table columns referenced in a Presto query?

Athena (Hive/Presto) Parquet vs ORC In Count Query

How to get column name based on condition

Translating my query from using aggregate functions to using window functions

cannot select hive table via presto 0.208, but hive cli succeeds for the same SQL query

How can I replicate my query using a window function instead?

Windows functions orderen by date when some dates doesn't exist

Getting New Users and Returning Users breakdown (new payers vs returning payers)

How to cast date as date string in PRESTO

How to insert 2 case when conditions into sum() function in SQL?

How to Handle SQLAlchemy Disconnects?

Using Replace Function in Join (SQL)

hash a column in spark dataframe before storing it in database and have the the original value when selecting from presto

Count duplicates in SQL and partition by specific column

How to find rows between two dates per row

Secure Presto with Kerberos on multi tenant environment cluster with Hive Catalog

Varchar string to date - Presto

presto multiple columns in subquery not supported

AWS Athena working with nested arrays, trying to search for a field within the array

how to solve given Correlated Subqueries is not supported within case when statement

how to set Boolean value per row based on condition

Aggregating data in a table up to the date of each row in the table

How to get all database tables referenced in a presto query using presto-parser

Why don't these two queries return the same number of results?

Join and aggregate where date in right table <= date in left table

How to convert json object into array in prestodb/athena

Rounding integers nearest 10 in Presto

prestosql minio connection refused (minio as metastore)

How to select data from aws athena table which is partitioned like 'year=yyyy/month=MM/date=dd/' for a given date range?

How to do date date comparison in Amazon Athena , Here my date columns are in string in the (yyyy-mm-dd) format

Generate list of all dates between x & y

Need help in running presto execute query

How can I get my presto plugin to log to my mysql database?

Mixed format in S3 files to be queried by Athena: How to cast at table definition stage

Presto - Insert Array as Function Input

Is there a way to see raw string values using SQL / presto SQL / athena?

Select where multiple conditions in parallel lists of values

SQL: Group by and show examples of another field

How to exclude items from search using NOT LIKE and % in Presto SQL?

Counting population of membership groups in Presto

Why don't columns with citext datatype is processed by presto?

Connecting to Presto using dash

Presto return all field names of a ROW type column

Presto average window function

Exploding a json column in Athena using Presto stored procedure

AWS Athena case sensitive orc.column.index.access=false?

How to combine day, month, year fields into a date in Presto?

Presto SQL - Fill in missing values within range with 0

How to count array elements occurrences in Presto?

Parse dates with timezone

Qubole Presto datatype "Map" using the Like Operator

Presto - Ranger Issue with Hive Connector

Selecting row by value and calculate radius of gyration

AWS Athena Fails to Run any WHERE clause on table

Does Presto have a function like translate()?

Does presto support adding data sources dynamically?

Using SQL Array in Radians Function in AWS Athena/Presto

Efficient way to sum on one column where count(value_1) / count(value_2) of another column is greater than x