[ 
https://issues.apache.org/jira/browse/HIVE-29201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Araika Singh updated HIVE-29201:
--------------------------------
    Description: The test in itself uses SORT_QUERY_RESULTS to keep a 
deterministic ordering of queries. But there is still scope of non determinism, 
as SORT_QUERY_RESULTS sorts the output of each query lexicographically, and if 
the present masked values change, then the output ordering changes as well. 
Hence, we need to add explicit order by on queries.  (was: The queries in 
itself uses SORT_QUERY_RESULTS to keep a deterministic ordering of queries. But 
there is still scope of non determinism, as SORT_QUERY_RESULTS sorts the output 
of each query lexicographically, and if the present masked values change, then 
the output ordering changes as well. Hence, we need to add explicit order by on 
queries.)

> Fix flaky test query_iceberg_metadata_of_unpartitioned_table.q
> --------------------------------------------------------------
>
>                 Key: HIVE-29201
>                 URL: https://issues.apache.org/jira/browse/HIVE-29201
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Araika Singh
>            Assignee: Araika Singh
>            Priority: Major
>
> The test in itself uses SORT_QUERY_RESULTS to keep a deterministic ordering 
> of queries. But there is still scope of non determinism, as 
> SORT_QUERY_RESULTS sorts the output of each query lexicographically, and if 
> the present masked values change, then the output ordering changes as well. 
> Hence, we need to add explicit order by on queries.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to