[ https://issues.apache.org/jira/browse/HIVE-26761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Balázs Cseh reassigned HIVE-26761: ---------------------------------- Assignee: Balázs Cseh > 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 > > 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)