[HIVE-656] Add a PMOD (POSITIVE_MOD) function

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Hadoop Flags: Reviewed
• Release Note: HIVE-656. Add a PMOD (POSITIVE MOD) function. (Scott Chen via zshao)
• Assignee: Scott Chen
• Reporter: Zheng Shao
• Created: 20/Jul/09 20:44
• Updated: 17/Dec/11 00:07
• Resolved: 29/Jul/09 04:06

Description

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:

((hash(xxx) % 10) + 10) % 10