The range partitioning strategy helps prevent the values of the columns of the PARTITION BY clause from distributing excessive rows to the same partition or AMP.
Range and hash partitioning is supported for moving window types. Only hash partitioning is supported for the reporting and cumulative window types because of potential ambiguities that can occur when a user tries to reference previous values assuming a specific ordering within window types like reporting and cumulative, which are semantically not order dependent.
Make sure that the function uses an appropriate set of column values for the PARTITION BY clause to avoid potential skew situations for the reporting or cumulative aggregate cases. For more information, see Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145.