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

Community PragProg Customers
,
1

@billkarwin

You say partitioning by date_reported but in the example there is a partition by hash ( bug_id ).

2

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