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