hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-436) MIN and MAX should inherit type
Date Tue, 21 Apr 2009 06:59:47 GMT
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.

View raw message