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: