CODEWITHSUNDEEP
sqlprestoamazon-athena
ashur
ashur

Reputation: 63

Is there any function could make date minus bigint type in Athena?

select user_id,first_event_date,(date(max(event_date)) - rnk) date_on from (select event_date,user_id,first_event_date,row_number() over(partition by user_id order by first_event_date desc) rnk from retention_user_selected) GROUP BY user_id, first_event_date enter image description here

This would show error : '-' cannot be applied to date, bigint

Upvotes: 1

Views: 197

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270301

Try using intervals:

date(max(event_date)) - rnk * interval '1 day'

Upvotes: 0

Related Questions