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

Support avg(decimal)

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 0.11.0
    • None
    • None

    Description

      Currently the following query:

      hive> select p_mfgr, avg(p_retailprice) from part group by p_mfgr;
FAILED: UDFArgumentTypeException Only numeric or string type arguments are accepted but decimal is passed

      is not supported by hive but is on postgres.

      Attachments

        1. HIVE-4128-2.patch
          18 kB
          Brock Noland
        2. HIVE-4128-3.patch
          20 kB
          Brock Noland
        3. HIVE-4128-4.patch
          23 kB
          Brock Noland

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. HIVE-4271 Limit precision of decimal type

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Review

          Activity

            People

              brocknoland Brock Noland
              brocknoland Brock Noland
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: