Breaking News: Grepper is joining You.com. Read the official announcement!

AWS Athena select partition year month day

Uptight Unicorn answered on October 24, 2022 Popularity 2/10 Helpfulness 1/10

answer AWS Athena select partition year month day

AWS Athena select partition year month day

Comment

SELECT avg(price) 
FROM my_table 
WHERE cast(date_parse(concat(cast(year as varchar(4)),'-',
                             cast(month as varchar(2)),'-',
                             cast(day as varchar(2))
                             ), '%Y-%m-%d') as date) 
BETWEEN Date '2018-01-01' AND Date '2018-01-31'

Popularity 2/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: athena partition select sql

Link to this answer
Share Copy Link