MIN and MAX should inherit type
-------------------------------

                 Key: HIVE-436
                 URL: https://issues.apache.org/jira/browse/HIVE-436
             Project: Hadoop Hive
          Issue Type: Wish
            Reporter: Adam Kramer


MIN and MAX functions currently return the DOUBLE type...but really, they 
should return the same type as the column they operate on.

In some cases like SUM, it's possible that the result would overflow making 
DOUBLE more useful as it can drop digits and swap to scientific notation, but 
MIN and MAX by definition cannot have this problem because the answers are 
always represented in the column they are run across.

Easy workaround: CAST all of my MINs and MAXes. It's just a wish.

-- 
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