Aihua Xu created HIVE-11962:
-------------------------------
Summary: Improve windowing_windowspec2.q tests to return
consistent results
Key: HIVE-11962
URL: https://issues.apache.org/jira/browse/HIVE-11962
Project: Hive
Issue Type: Test
Components: Test
Affects Versions: 2.0.0
Reporter: Aihua Xu
Priority: Trivial
Upstream test result for windowing_windowspec2.q seems to return consistent
result while we have observe that in a different test env, the result could be
slightly different.
e.g., for the following query, the value t could be the same in each partition
of ts. So the row order could be either for those rows. I haven't looked
further why it causes that difference yet.
{noformat}
select ts, f, max(f) over (partition by ts order by t rows between 2 preceding
and 1 preceding) from over10k limit 100;
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
