Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: None
    • Labels:
      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.

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

        Issue Links

          Activity

          Brock Noland created issue -
          Brock Noland made changes -
          Field Original Value New Value
          Description Currently the following query:

          {noformat}
          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
          Brock Noland made changes -
          Description Currently the following query:

          {noformat}
          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
          Currently the following query:

          {noformat}
          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
          {noformat}

          is not supported by hive but is on postgres.
          Show
          Brock Noland added a comment - https://reviews.facebook.net/D9411
          Brock Noland made changes -
          Remote Link This issue links to "Review (Web Link)" [ 12079 ]
          Brock Noland made changes -
          Attachment HIVE-4128-2.patch [ 12573773 ]
          Brock Noland made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Fix Version/s 0.11.0 [ 12323587 ]
          Hide
          Gunther Hagleitner added a comment -

          Nice. Couple of comments on phabricator.

          Show
          Gunther Hagleitner added a comment - Nice. Couple of comments on phabricator.
          Hide
          Brock Noland added a comment -

          New patch attached and posted to RB.

          Show
          Brock Noland added a comment - New patch attached and posted to RB.
          Brock Noland made changes -
          Attachment HIVE-4128-3.patch [ 12577055 ]
          Hide
          Brock Noland added a comment -

          Updated based on review

          Show
          Brock Noland added a comment - Updated based on review
          Brock Noland made changes -
          Attachment HIVE-4128-4.patch [ 12577080 ]
          Hide
          Gunther Hagleitner added a comment -

          +1 (non-committer)

          Show
          Gunther Hagleitner added a comment - +1 (non-committer)
          Gunther Hagleitner made changes -
          Link This issue blocks HIVE-4271 [ HIVE-4271 ]
          Hide
          Ashutosh Chauhan added a comment -

          +1 will commit if tests pass.

          Show
          Ashutosh Chauhan added a comment - +1 will commit if tests pass.
          Hide
          Ashutosh Chauhan added a comment -

          Committed to trunk. Thanks, Brock!

          Show
          Ashutosh Chauhan added a comment - Committed to trunk. Thanks, Brock!
          Ashutosh Chauhan made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          Brock Noland added a comment -

          Awesome, thank you!

          Show
          Brock Noland added a comment - Awesome, thank you!
          Owen O'Malley made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Brock Noland
              Reporter:
              Brock Noland
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development