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

Hive macro results on macro_duplicate.q different after adding ORDER BY

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.3.0, 2.0.0
    • Component/s: Macros
    • Labels:

      Description

      Added an order-by to the query in macro_duplicate.q:

      -select math_square(a), math_square(b),factorial(a), factorial(b), math_add(a), math_add(b),int(c) from macro_testing;
      \ No newline at end of file
      +select math_square(a), math_square(b),factorial(a), factorial(b), math_add(a), math_add(b),int(c) from macro_testing order by int(c);
      

      And the results from math_add() changed unexpectedly:

      -1      4       1       2       2       4       3
      -16     25      24      120     8       10      6
      +1      4       1       2       1       4       3
      +16     25      24      120     16      25      6
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pxiong Pengcheng Xiong
                Reporter:
                jdere Jason Dere
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: