SQL Antipatterns, Volume 1: Bad column in partition by example (page 107)

Thank you for identifying this mistake. A more clear example should be “PARTITION BY HASH( TO_DAYS(date_reported) )”.