[HIVE-12277] Hive macro results on macro_duplicate.q different after adding ORDER BY

• 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: CorrectnessBug
• Assignee: Pengcheng Xiong
• Reporter: Jason Dere
• Created: 27/Oct/15 18:39
• Updated: 05/Apr/16 03:06
• Resolved: 30/Oct/15 17:18

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

Issue Links

• duplicates: HIVE-12275 Query results on macro_duplicate.q are in different order on some environments
• relates to: HIVE-2655 Ability to define functions in HQL