Top "Presto" questions

Presto is an open source distributed SQL query engine for running analytic queries against data sources of all sizes ranging from gigabytes to petabytes.

Nested Query Alternatives in AWS Athena

I am running a query that gives a non-overlapping set of first_party_id's - ids that are associated with …

sql amazon-web-services presto amazon-athena
Split one row into multiple rows based on comma-separated string column

I have a table like below with columns A(int) and B(string): A B 1 a,b,c 2 d,e 3 …

sql amazon-athena presto
How to convert a date format YYYY-MM-DD into integer YYYYMMDD in Presto/Hive?

How to CONVERT a date in format YYYY-MM-DD into integer YYYYMMDD in Presto/Hive? I am trying to convert the …

sql date hadoop hive presto
Show tables from all schemas in Presto

In Presto SHOW SCHEMAS; returns all schemas SHOW TABLES FROM foo; returns all tables for foo schema Is there a …

sql presto
how to use presto to query hive data

I just installed presto and when I use the presto-cli to query hive data, I get the following error: $ ./presto …

presto
Athena: Query exhausted resources at scale factor

I am running a query like: SELECT f.*, p.countryName, p.airportName, a.name AS agentName FROM ( SELECT f.outboundlegid, …

sql amazon-web-services query-optimization amazon-athena presto
Checking if key exists in Presto value map

I am new to Presto, and can't quite figure out how to check if a key is present in a …

presto trino
random sample of size N in Athena

I'm trying to obtain a random sample of N rows from Athena. But since the table from which I want …

presto amazon-athena
User Defined Functions in Presto

I am currently working with Presto 0.80. I have to write a user defined function to convert degree celsius to degree …

presto
Athena date_parse for date with optional millisecond field

I have date in S3 using which I created an Athena table. I have some date entries in S3 in …

sql amazon-athena presto