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