There are a lot of cases people want to get a positive modulo result.
For example, people want to bucket the data into 10 buckets. They use the hash code in Hive (based on Java) which can return a negative number. Then they need this POSITIVE_MOD(a, b) to return the results.
Otherwise they can still do it but it will be very verbose:
|Assignee||Scott Chen [ schen ]|
|Summary||Add a POSITIVE_MOD function||Add a PMOD (POSITIVE_MOD) function|
|Status||Resolved [ 5 ]||Closed [ 6 ]|