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

Repeated UDAFs with literals can produce incorrect result

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.0.1, 1.1.1, 1.2.1, 2.0.0
    • Fix Version/s: 2.0.0
    • Component/s: Query Planning
    • Labels:
      None

      Description

      Repeated UDAF with literals could produce wrong result.
      This is not a common use case, nevertheless a bug.

      hive> select max('pants'), max('pANTS') from t1 group by key;
      Total MapReduce CPU Time Spent: 0 msec
      OK
      pANTS pANTS
      pANTS pANTS
      pANTS pANTS
      pANTS pANTS
      pANTS pANTS
      Time taken: 296.252 seconds, Fetched: 5 row(s)

        Attachments

        1. HIVE-12590.patch
          139 kB
          Ashutosh Chauhan
        2. HIVE-12590.2.patch
          560 kB
          Ashutosh Chauhan
        3. HIVE-12590.3.patch
          10 kB
          Ashutosh Chauhan
        4. HIVE-12590.4.patch
          12 kB
          Ashutosh Chauhan
        5. HIVE-12590.4.patch
          12 kB
          Ashutosh Chauhan
        6. HIVE-12590.5.patch
          15 kB
          Ashutosh Chauhan
        7. HIVE-12590.6.patch
          17 kB
          Ashutosh Chauhan
        8. HIVE-12590.7.patch
          76 kB
          Ashutosh Chauhan
        9. HIVE-12590.8.patch
          79 kB
          Ashutosh Chauhan
        10. HIVE-12590.9.patch
          76 kB
          Ashutosh Chauhan

          Issue Links

            Activity

              People

              • Assignee:
                ashutoshc Ashutosh Chauhan
                Reporter:
                jpullokkaran Laljo John Pullokkaran
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: