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

Relax type restrictions on 'Greatest' and 'Least'

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Implemented
    • 1.1.1, 1.2.1
    • 2.0.0
    • UDF
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: