HIVE-10665 Continue to make udaf_percentile_approx_23.q test more stable (Alexander Pivovarov, reviewed by Jason Dere and Swarnim Kulkarni)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/3d95e106 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/3d95e106 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/3d95e106 Branch: refs/heads/parquet Commit: 3d95e1061883ab9d7265ac7d678f103c4565fc9c Parents: d117612 Author: Alexander Pivovarov <apivova...@gmail.com> Authored: Wed May 13 17:42:12 2015 -0700 Committer: Alexander Pivovarov <apivova...@gmail.com> Committed: Tue May 19 23:15:39 2015 -0700 ---------------------------------------------------------------------- ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q | 2 +- .../results/clientpositive/udaf_percentile_approx_23.q.out | 6 +++--- 2 files changed, 4 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/3d95e106/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q b/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q index b345b37..028acdb 100644 --- a/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q +++ b/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q @@ -90,7 +90,7 @@ set hive.cbo.enable=false; -- NaN explain select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) from bucket; -select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) from bucket; +select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) between 340.5 and 343.0 from bucket; -- with CBO explain http://git-wip-us.apache.org/repos/asf/hive/blob/3d95e106/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out index 022a884..14a6874 100644 --- a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out +++ b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out @@ -556,15 +556,15 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) from bucket +PREHOOK: query: select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) between 340.5 and 343.0 from bucket PREHOOK: type: QUERY PREHOOK: Input: default@bucket #### A masked pattern was here #### -POSTHOOK: query: select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) from bucket +POSTHOOK: query: select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) between 340.5 and 343.0 from bucket POSTHOOK: type: QUERY POSTHOOK: Input: default@bucket #### A masked pattern was here #### -341.5 +true PREHOOK: query: -- with CBO explain select percentile_approx(key, 0.5) from bucket