You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/08/06 08:44:16 UTC
svn commit: r1616108 - in /hive/branches/cbo/ql/src/test:
queries/clientpositive/cbo_correctness.q
results/clientpositive/cbo_correctness.q.out
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