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.

Reply via email to