Questions tagged [amazon-presto]

Use for questions about how to use Amazon Presto SQL query engine on Amazon EMR.

Filter by
Sorted by
Tagged with
0
votes
0answers
19 views

Is there a way to reduce the number of joins?

I have an ETL job that looks like the following: INSERT INTO awsdatacatalog.db.table0 (SELECT field0 AS other_name0 fieldN AS other_nameN -- PARTITION KEYS , 'partition0' ...
0
votes
1answer
121 views

AWS Athena: syntax for grouping data for week ending on a Saturday

I'm having some issues with the Presto syntax in grouping data by separate weeks, ending on Saturdays. I have this field called "timestamp," and I've been using the the following to group by weeks. ...
0
votes
1answer
66 views

SQL query - Do I need a full join to produce this combined result?

With two tables structured like this: Table1 Table2 ---------------- ---------------- id, time, x id, time, y, z 1 1 1 1 2 ...
0
votes
1answer
115 views

How to query from the result of a changed column of a table in postgresql

I am working with Presto on Amazon Athena. I have a string time column in a table and now I want to change that time to date time type and then query data for selected dates. Is there a direct way to ...