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
1
vote
1answer
38 views

Getting the row before a row with a certain value in SQL

I have a table like below where user actions are stored with a timestamp. My goal is to identify the action that happened before a specific action (named reference_action) and count the number of ...
0
votes
0answers
26 views

presto from_unixtime to omit milliseconds & timezone string

This is my query SELECT from_unixtime(dispo_epoch,'Africa/Johannesburg') FROM "analytics"."table1" WHERE lead_id = 100000 Result returned is: 2020-03-31 12:37:43.000 Africa/...
1
vote
1answer
698 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. ...
1
vote
1answer
130 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 ...
1
vote
1answer
154 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 ...