[ https://issues.apache.org/jira/browse/HIVE-26761?focusedWorklogId=827531&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-827531 ]
ASF GitHub Bot logged work on HIVE-26761: ----------------------------------------- Author: ASF GitHub Bot Created on: 21/Nov/22 10:06 Start Date: 21/Nov/22 10:06 Worklog Time Spent: 10m Work Description: abstractdog merged PR #3783: URL: https://github.com/apache/hive/pull/3783 Issue Time Tracking ------------------- Worklog Id: (was: 827531) Time Spent: 40m (was: 0.5h) > Add "-- SORT_QUERY_RESULTS" to complex_alias.q > ---------------------------------------------- > > Key: HIVE-26761 > URL: https://issues.apache.org/jira/browse/HIVE-26761 > Project: Hive > Issue Type: Bug > Components: HiveServer2 > Reporter: Balázs Cseh > Assignee: Balázs Cseh > Priority: Major > Labels: pull-request-available > Time Spent: 40m > Remaining Estimate: 0h > > Without sorting the order in which results are returned is non-deterministic. > In most runs, it is: > {code:java} > 42 42 > 41 41 {code} > however in some cases it comes back as: > {code:java} > 41 41 > 42 42 {code} > Adding "– SORT_QUERY_RESULTS" eliminates this potential inconsistency. -- This message was sent by Atlassian Jira (v8.20.10#820010)