hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1616108 - in /hive/branches/cbo/ql/src/test: queries/clientpositive/cbo_correctness.q results/clientpositive/cbo_correctness.q.out
Date Wed, 06 Aug 2014 06:44:16 GMT
Author: hashutosh
Date: Wed Aug  6 06:44:16 2014
New Revision: 1616108

URL: http://svn.apache.org/r1616108
Log:
HIVE-7621 : Add tests for cte with cbo (Ashutosh Chauhan)

Modified:
    hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q
    hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out

Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q?rev=1616108&r1=1616107&r2=1616108&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q (original)
+++ hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q Wed Aug  6 06:44:16
2014
@@ -192,4 +192,22 @@ select count(v1.c_int)  from v1 join v2 
 create view v3 as select v1.value  from v1 join t1 on v1.c_boolean = t1.c_boolean;
 select * from v3 limit 3;
 
+with q1 as ( select key from t1 where key = '1')
+select *
+from q1
+;
+
+with q1 as ( select value from v1 where c_boolean = false)
+select *
+from q1 ;
+
+create view v4 as
+with q1 as ( select key from t1  where key = '1')
+select * from q1
+;
+
+with q1 as ( select c_int from q2 where c_boolean = false),
+q2 as ( select c_int,c_boolean from v1  where value = '1')
+select * from (select c_int from q1) a;
+
 

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out?rev=1616108&r1=1616107&r2=1616108&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out Wed Aug  6
06:44:16 2014
@@ -16037,3 +16037,70 @@ POSTHOOK: Input: default@v3
 1
 1
 1
+PREHOOK: query: with q1 as ( select key from t1 where key = '1')
+select *
+from q1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: with q1 as ( select key from t1 where key = '1')
+select *
+from q1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+PREHOOK: query: with q1 as ( select value from v1 where c_boolean = false)
+select *
+from q1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@v1
+#### A masked pattern was here ####
+POSTHOOK: query: with q1 as ( select value from v1 where c_boolean = false)
+select *
+from q1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@v1
+#### A masked pattern was here ####
+1
+1
+PREHOOK: query: create view v4 as
+with q1 as ( select key from t1  where key = '1')
+select * from q1
+PREHOOK: type: CREATEVIEW
+PREHOOK: Input: default@t1
+POSTHOOK: query: create view v4 as
+with q1 as ( select key from t1  where key = '1')
+select * from q1
+POSTHOOK: type: CREATEVIEW
+POSTHOOK: Input: default@t1
+POSTHOOK: Output: default@v4
+PREHOOK: query: with q1 as ( select c_int from q2 where c_boolean = false),
+q2 as ( select c_int,c_boolean from v1  where value = '1')
+select * from (select c_int from q1) a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@v1
+#### A masked pattern was here ####
+POSTHOOK: query: with q1 as ( select c_int from q2 where c_boolean = false),
+q2 as ( select c_int,c_boolean from v1  where value = '1')
+select * from (select c_int from q1) a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@v1
+#### A masked pattern was here ####
+1
+1



Mime
View raw message