[
https://issues.apache.org/jira/browse/HIVE-12277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pengcheng Xiong updated HIVE-12277:
-----------------------------------
Attachment: HIVE-12277.01.patch
[~jdere], could you please review it? Thanks!
> Hive macro results on macro_duplicate.q different after adding ORDER BY
> -----------------------------------------------------------------------
>
> Key: HIVE-12277
> URL: https://issues.apache.org/jira/browse/HIVE-12277
> Project: Hive
> Issue Type: Bug
> Components: Macros
> Reporter: Jason Dere
> Assignee: Pengcheng Xiong
> Attachments: HIVE-12277.01.patch
>
>
> Added an order-by to the query in macro_duplicate.q:
> {noformat}
> -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);
> {noformat}
> And the results from math_add() changed unexpectedly:
> {noformat}
> -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
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
