Szehon Ho created HIVE-12070:
--------------------------------

             Summary: Relax type restrictions on 'Greatest' and 'Least'
                 Key: HIVE-12070
                 URL: https://issues.apache.org/jira/browse/HIVE-12070
             Project: Hive
          Issue Type: Bug
          Components: UDF
            Reporter: Szehon Ho


Hive functions 'greatest' and 'least' have one of the strictest type 
restrictions of any database.

Experimented with other databases, Postgres and MySQL, all of them are much 
more relaxed.  Tinyint (not in postgres), smallint, int, bigint, decimal, 
double, float can all be passed to these functions without complaint.  In Hive, 
one cannot even do a greatest comparison between int and bigint without hitting 
exception.

This JIRA aims to relax the restriction and make it more akin to the other 
databases.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to