Add a POSITIVE_MOD function
---------------------------
Key: HIVE-656
URL: https://issues.apache.org/jira/browse/HIVE-656
Project: Hadoop Hive
Issue Type: New Feature
Reporter: Zheng Shao
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:
{code}
((hash(xxx) % 10) + 10) % 10
{code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.