ALBのアクセスログを日別に集計

SELECT COUNT(*), date_parse(time, '%Y-%m-%dT%H:%i:%sZ') as date FROM alb_logs WHERE time > '2018-07-12' AND request_url like '%path%' GROUP BY date_parse(time, '%Y-%m-%dT%H:%i:%sZ') ORDER BY count(*) desc

• timeは2017-01-07T00:07:23.752260Zが入る

AWS Developer Forums: date_parse() nor parse_datetime() seem …

6.10. Date and Time Functions and Operators — Presto 0.172 Documentation