hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jd...@apache.org
Subject svn commit: r1670407 - in /hive/trunk/ql/src/test: queries/clientpositive/udaf_percentile_approx_23.q results/clientpositive/udaf_percentile_approx_23.q.out
Date Tue, 31 Mar 2015 17:42:08 GMT
Author: jdere
Date: Tue Mar 31 17:42:07 2015
New Revision: 1670407

URL: http://svn.apache.org/r1670407
Log:
HIVE-10059: Make udaf_percentile_approx_23.q test more stable (Alex Pivovarov via Jason Dere)

Modified:
    hive/trunk/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q
    hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out

Modified: hive/trunk/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q?rev=1670407&r1=1670406&r2=1670407&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/udaf_percentile_approx_23.q Tue Mar 31 17:42:07
2015
@@ -88,11 +88,11 @@ select * from t12;
 set hive.cbo.enable=false;
 
 -- NaN
-explain 
+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;
 
 -- with CBO
-explain 
-select percentile_approx(key, 0.5) from bucket;
+explain
 select percentile_approx(key, 0.5) from bucket;
+select percentile_approx(key, 0.5) between 255.0 and 257.0 from bucket;

Modified: hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out?rev=1670407&r1=1670406&r2=1670407&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out Tue Mar
31 17:42:07 2015
@@ -505,11 +505,11 @@ POSTHOOK: Input: default@t12
 #### A masked pattern was here ####
 [26.0,255.5,479.0,491.0]
 PREHOOK: query: -- NaN
-explain 
+explain
 select percentile_approx(case when key < 100 then cast('NaN' as double) else key end,
0.5) from bucket
 PREHOOK: type: QUERY
 POSTHOOK: query: -- NaN
-explain 
+explain
 select percentile_approx(case when key < 100 then cast('NaN' as double) else key end,
0.5) from bucket
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
@@ -566,11 +566,11 @@ POSTHOOK: Input: default@bucket
 #### A masked pattern was here ####
 341.5
 PREHOOK: query: -- with CBO
-explain 
+explain
 select percentile_approx(key, 0.5) from bucket
 PREHOOK: type: QUERY
 POSTHOOK: query: -- with CBO
-explain 
+explain
 select percentile_approx(key, 0.5) from bucket
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
@@ -617,12 +617,12 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-PREHOOK: query: select percentile_approx(key, 0.5) from bucket
+PREHOOK: query: select percentile_approx(key, 0.5) between 255.0 and 257.0 from bucket
 PREHOOK: type: QUERY
 PREHOOK: Input: default@bucket
 #### A masked pattern was here ####
-POSTHOOK: query: select percentile_approx(key, 0.5) from bucket
+POSTHOOK: query: select percentile_approx(key, 0.5) between 255.0 and 257.0 from bucket
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@bucket
 #### A masked pattern was here ####
-255.5
+true



Mime
View raw message