Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12070

Relax type restrictions on 'Greatest' and 'Least'

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: 1.1.1, 1.2.1
    • Fix Version/s: 2.0.0
    • Component/s: UDF
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                szehon Szehon Ho
                Reporter:
                szehon Szehon Ho
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: