hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kgyrtk...@apache.org
Subject [27/54] [partial] hive git commit: HIVE-17550: Remove unreferenced q.out-s (Zoltan Haindrich, reviewed by Ashutosh Chauhan)
Date Thu, 21 Sep 2017 09:07:04 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/cbo_rp_udf_udaf_stats_opt.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cbo_rp_udf_udaf_stats_opt.q.out b/ql/src/test/results/clientpositive/cbo_rp_udf_udaf_stats_opt.q.out
deleted file mode 100644
index 3a589b4..0000000
--- a/ql/src/test/results/clientpositive/cbo_rp_udf_udaf_stats_opt.q.out
+++ /dev/null
@@ -1,124 +0,0 @@
-Warning: Value had a \n character in it.
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
--- 8. Test UDF/UDAF
-select count(*), count(c_int), sum(c_int), avg(c_int), max(c_int), min(c_int) from cbo_t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
--- 8. Test UDF/UDAF
-select count(*), count(c_int), sum(c_int), avg(c_int), max(c_int), min(c_int) from cbo_t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-20	18	18	1.0	1	1
-PREHOOK: query: select count(*), count(c_int) as a, sum(c_int), avg(c_int), max(c_int), min(c_int),
case c_int when 0  then 1 when 1 then 2 else 3 end, sum(case c_int when 0  then 1 when 1 then
2 else 3 end) from cbo_t1 group by c_int order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*), count(c_int) as a, sum(c_int), avg(c_int), max(c_int),
min(c_int), case c_int when 0  then 1 when 1 then 2 else 3 end, sum(case c_int when 0  then
1 when 1 then 2 else 3 end) from cbo_t1 group by c_int order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-18	18	18	1.0	1	1	2	36
-2	0	NULL	NULL	NULL	NULL	3	6
-PREHOOK: query: select * from (select count(*) as a, count(distinct c_int) as b, sum(c_int)
as c, avg(c_int) as d, max(c_int) as e, min(c_int) as f from cbo_t1) cbo_t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select count(*) as a, count(distinct c_int) as b, sum(c_int)
as c, avg(c_int) as d, max(c_int) as e, min(c_int) as f from cbo_t1) cbo_t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-20	1	18	1.0	1	1
-PREHOOK: query: select * from (select count(*) as a, count(distinct c_int) as b, sum(c_int)
as c, avg(c_int) as d, max(c_int) as e, min(c_int) as f, case c_int when 0  then 1 when 1
then 2 else 3 end as g, sum(case c_int when 0  then 1 when 1 then 2 else 3 end) as h from
cbo_t1 group by c_int) cbo_t1 order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select * from (select count(*) as a, count(distinct c_int) as b, sum(c_int)
as c, avg(c_int) as d, max(c_int) as e, min(c_int) as f, case c_int when 0  then 1 when 1
then 2 else 3 end as g, sum(case c_int when 0  then 1 when 1 then 2 else 3 end) as h from
cbo_t1 group by c_int) cbo_t1 order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-18	1	18	1.0	1	1	2	36
-2	0	NULL	NULL	NULL	NULL	3	6
-PREHOOK: query: select f,a,e,b from (select count(*) as a, count(c_int) as b, sum(c_int)
as c, avg(c_int) as d, max(c_int) as e, min(c_int) as f from cbo_t1) cbo_t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-#### A masked pattern was here ####
-POSTHOOK: query: select f,a,e,b from (select count(*) as a, count(c_int) as b, sum(c_int)
as c, avg(c_int) as d, max(c_int) as e, min(c_int) as f from cbo_t1) cbo_t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-#### A masked pattern was here ####
-1	20	1	18
-PREHOOK: query: select f,a,e,b from (select count(*) as a, count(distinct c_int) as b, sum(distinct
c_int) as c, avg(distinct c_int) as d, max(distinct c_int) as e, min(distinct c_int) as f
from cbo_t1) cbo_t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select f,a,e,b from (select count(*) as a, count(distinct c_int) as b, sum(distinct
c_int) as c, avg(distinct c_int) as d, max(distinct c_int) as e, min(distinct c_int) as f
from cbo_t1) cbo_t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-1	20	1	1
-PREHOOK: query: select key,count(c_int) as a, avg(c_float) from cbo_t1 group by key order
by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select key,count(c_int) as a, avg(c_float) from cbo_t1 group by key order
by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
- 1	2	1.0
- 1 	2	1.0
-1	12	1.0
-1 	2	1.0
-NULL	0	NULL
-PREHOOK: query: select count(distinct c_int) as a, avg(c_float) from cbo_t1 group by c_float
order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select count(distinct c_int) as a, avg(c_float) from cbo_t1 group by c_float
order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-0	NULL
-1	1.0
-PREHOOK: query: select count(distinct c_int) as a, avg(c_float) from cbo_t1 group by c_int
order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select count(distinct c_int) as a, avg(c_float) from cbo_t1 group by c_int
order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-0	NULL
-1	1.0
-PREHOOK: query: select count(distinct c_int) as a, avg(c_float) from cbo_t1 group by c_float,
c_int order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select count(distinct c_int) as a, avg(c_float) from cbo_t1 group by c_float,
c_int order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-0	NULL
-1	1.0

http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/cbo_rp_unionDistinct_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cbo_rp_unionDistinct_2.q.out b/ql/src/test/results/clientpositive/cbo_rp_unionDistinct_2.q.out
deleted file mode 100644
index 304d74f..0000000
--- a/ql/src/test/results/clientpositive/cbo_rp_unionDistinct_2.q.out
+++ /dev/null
@@ -1,551 +0,0 @@
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-CREATE TABLE u1 as select key, value from src order by key limit 5
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@src
-PREHOOK: Output: database:default
-PREHOOK: Output: default@u1
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-CREATE TABLE u1 as select key, value from src order by key limit 5
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@src
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@u1
-POSTHOOK: Lineage: u1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: u1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
-PREHOOK: query: CREATE TABLE u2 as select key, value from src order by key limit 3
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@src
-PREHOOK: Output: database:default
-PREHOOK: Output: default@u2
-POSTHOOK: query: CREATE TABLE u2 as select key, value from src order by key limit 3
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@src
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@u2
-POSTHOOK: Lineage: u2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: u2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
-PREHOOK: query: CREATE TABLE u3 as select key, value from src order by key desc limit 5
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@src
-PREHOOK: Output: database:default
-PREHOOK: Output: default@u3
-POSTHOOK: query: CREATE TABLE u3 as select key, value from src order by key desc limit 5
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@src
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@u3
-POSTHOOK: Lineage: u3.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default),
]
-POSTHOOK: Lineage: u3.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
-PREHOOK: query: select * from u1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from u1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-#### A masked pattern was here ####
-0	val_0
-0	val_0
-0	val_0
-10	val_10
-100	val_100
-PREHOOK: query: select * from u2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u2
-#### A masked pattern was here ####
-POSTHOOK: query: select * from u2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u2
-#### A masked pattern was here ####
-0	val_0
-0	val_0
-0	val_0
-PREHOOK: query: select * from u3
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select * from u3
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-96	val_96
-97	val_97
-97	val_97
-98	val_98
-98	val_98
-PREHOOK: query: select key, value from 
-(
-select key, value from u1
-union all
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, value from 
-(
-select key, value from u1
-union all
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-0	val_0
-0	val_0
-0	val_0
-0	val_0
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-97	val_97
-98	val_98
-98	val_98
-PREHOOK: query: select key, value from 
-(
-select key, value from u1
-union 
-select key, value from u2
-union all
-select key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, value from 
-(
-select key, value from u1
-union 
-select key, value from u2
-union all
-select key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-97	val_97
-98	val_98
-98	val_98
-PREHOOK: query: select key, value from 
-(
-select key, value from u1
-union distinct
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, value from 
-(
-select key, value from u1
-union distinct
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-97	val_97
-98	val_98
-98	val_98
-PREHOOK: query: select key, value from 
-(
-select key, value from u1
-union all
-select key, value from u2
-union
-select key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, value from 
-(
-select key, value from u1
-union all
-select key, value from u2
-union
-select key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-98	val_98
-PREHOOK: query: select key, value from 
-(
-select key, value from u1
-union 
-select key, value from u2
-union
-select key as key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, value from 
-(
-select key, value from u1
-union 
-select key, value from u2
-union
-select key as key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-98	val_98
-PREHOOK: query: select distinct * from 
-(
-select key, value from u1
-union all 
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct * from 
-(
-select key, value from u1
-union all 
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-98	val_98
-PREHOOK: query: select distinct * from 
-(
-select distinct * from u1
-union  
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct * from 
-(
-select distinct * from u1
-union  
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-98	val_98
-PREHOOK: query: drop view if exists v
-PREHOOK: type: DROPVIEW
-POSTHOOK: query: drop view if exists v
-POSTHOOK: type: DROPVIEW
-PREHOOK: query: create view v as select distinct * from 
-(
-select distinct * from u1
-union  
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-PREHOOK: type: CREATEVIEW
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-PREHOOK: Output: database:default
-PREHOOK: Output: default@v
-POSTHOOK: query: create view v as select distinct * from 
-(
-select distinct * from u1
-union  
-select key, value from u2
-union all
-select key as key, value from u3
-) tab
-POSTHOOK: type: CREATEVIEW
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@v
-PREHOOK: query: describe extended v
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe extended v
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
-key                 	string              	                    
-value               	string              	                    
-	 	 
-#### A masked pattern was here ####
-(	 	 
-select distinct * from u1	 	 
-union  	 	 
-select key, value from u2	 	 
-union all	 	 
-select key as key, value from u3	 	 
-) tab, viewExpandedText:select distinct `tab`.`key`, `tab`.`value` from 	 	 
-(	 	 
-select distinct `u1`.`key`, `u1`.`value` from `default`.`u1`	 	 
-union  	 	 
-select `u2`.`key`, `u2`.`value` from `default`.`u2`	 	 
-union all	 	 
-select `u3`.`key` as `key`, `u3`.`value` from `default`.`u3`	 	 
-) `tab`, tableType:VIRTUAL_VIEW)		 
-PREHOOK: query: select * from v
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-PREHOOK: Input: default@v
-#### A masked pattern was here ####
-POSTHOOK: query: select * from v
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-POSTHOOK: Input: default@v
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-98	val_98
-PREHOOK: query: drop view if exists v
-PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v
-PREHOOK: Output: default@v
-POSTHOOK: query: drop view if exists v
-POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v
-POSTHOOK: Output: default@v
-PREHOOK: query: create view v as select tab.* from 
-(
-select distinct * from u1
-union  
-select distinct * from u2
-) tab
-PREHOOK: type: CREATEVIEW
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Output: database:default
-PREHOOK: Output: default@v
-POSTHOOK: query: create view v as select tab.* from 
-(
-select distinct * from u1
-union  
-select distinct * from u2
-) tab
-POSTHOOK: type: CREATEVIEW
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@v
-PREHOOK: query: describe extended v
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe extended v
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
-key                 	string              	                    
-value               	string              	                    
-	 	 
-#### A masked pattern was here ####
-(	 	 
-select distinct * from u1	 	 
-union  	 	 
-select distinct * from u2	 	 
-) tab, viewExpandedText:select `tab`.`key`, `tab`.`value` from 	 	 
-(	 	 
-select distinct `u1`.`key`, `u1`.`value` from `default`.`u1`	 	 
-union  	 	 
-select distinct `u2`.`key`, `u2`.`value` from `default`.`u2`	 	 
-) `tab`, tableType:VIRTUAL_VIEW)		 
-PREHOOK: query: select * from v
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@v
-#### A masked pattern was here ####
-POSTHOOK: query: select * from v
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@v
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-PREHOOK: query: drop view if exists v
-PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v
-PREHOOK: Output: default@v
-POSTHOOK: query: drop view if exists v
-POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v
-POSTHOOK: Output: default@v
-PREHOOK: query: create view v as select * from 
-(
-select distinct u1.* from u1
-union all 
-select distinct * from u2
-) tab
-PREHOOK: type: CREATEVIEW
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Output: database:default
-PREHOOK: Output: default@v
-POSTHOOK: query: create view v as select * from 
-(
-select distinct u1.* from u1
-union all 
-select distinct * from u2
-) tab
-POSTHOOK: type: CREATEVIEW
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@v
-PREHOOK: query: describe extended v
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe extended v
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
-key                 	string              	                    
-value               	string              	                    
-	 	 
-#### A masked pattern was here ####
-(	 	 
-select distinct u1.* from u1	 	 
-union all 	 	 
-select distinct * from u2	 	 
-) tab, viewExpandedText:select `tab`.`key`, `tab`.`value` from 	 	 
-(	 	 
-select distinct `u1`.`key`, `u1`.`value` from `default`.`u1`	 	 
-union all 	 	 
-select distinct `u2`.`key`, `u2`.`value` from `default`.`u2`	 	 
-) `tab`, tableType:VIRTUAL_VIEW)		 
-PREHOOK: query: select * from v
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@v
-#### A masked pattern was here ####
-POSTHOOK: query: select * from v
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@v
-#### A masked pattern was here ####
-0	val_0
-0	val_0
-10	val_10
-100	val_100
-PREHOOK: query: select distinct * from 
-(
-select key, value from u1
-union all 
-select key, value from u2
-union 
-select key as key, value from u3
-) tab
-PREHOOK: type: QUERY
-PREHOOK: Input: default@u1
-PREHOOK: Input: default@u2
-PREHOOK: Input: default@u3
-#### A masked pattern was here ####
-POSTHOOK: query: select distinct * from 
-(
-select key, value from u1
-union all 
-select key, value from u2
-union 
-select key as key, value from u3
-) tab
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@u1
-POSTHOOK: Input: default@u2
-POSTHOOK: Input: default@u3
-#### A masked pattern was here ####
-0	val_0
-10	val_10
-100	val_100
-96	val_96
-97	val_97
-98	val_98

http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/cbo_rp_views.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cbo_rp_views.q.out b/ql/src/test/results/clientpositive/cbo_rp_views.q.out
deleted file mode 100644
index 4a7b935..0000000
--- a/ql/src/test/results/clientpositive/cbo_rp_views.q.out
+++ /dev/null
@@ -1,237 +0,0 @@
-PREHOOK: query: -- 10. Test views
-create view v1 as select c_int, value, c_boolean, dt from cbo_t1
-PREHOOK: type: CREATEVIEW
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Output: database:default
-PREHOOK: Output: default@v1
-POSTHOOK: query: -- 10. Test views
-create view v1 as select c_int, value, c_boolean, dt from cbo_t1
-POSTHOOK: type: CREATEVIEW
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@v1
-PREHOOK: query: create view v2 as select c_int, value from cbo_t2
-PREHOOK: type: CREATEVIEW
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Output: database:default
-PREHOOK: Output: default@v2
-POSTHOOK: query: create view v2 as select c_int, value from cbo_t2
-POSTHOOK: type: CREATEVIEW
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@v2
-PREHOOK: query: select value from v1 where c_boolean=false
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@v1
-#### A masked pattern was here ####
-POSTHOOK: query: select value from v1 where c_boolean=false
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@v1
-#### A masked pattern was here ####
-1
-1
-PREHOOK: query: select max(c_int) from v1 group by (c_boolean)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@v1
-#### A masked pattern was here ####
-POSTHOOK: query: select max(c_int) from v1 group by (c_boolean)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@v1
-#### A masked pattern was here ####
-NULL
-1
-1
-PREHOOK: query: select count(v1.c_int)  from v1 join cbo_t2 on v1.c_int = cbo_t2.c_int
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@v1
-#### A masked pattern was here ####
-POSTHOOK: query: select count(v1.c_int)  from v1 join cbo_t2 on v1.c_int = cbo_t2.c_int
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@v1
-#### A masked pattern was here ####
-234
-PREHOOK: query: select count(v1.c_int)  from v1 join v2 on v1.c_int = v2.c_int
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@v1
-PREHOOK: Input: default@v2
-#### A masked pattern was here ####
-POSTHOOK: query: select count(v1.c_int)  from v1 join v2 on v1.c_int = v2.c_int
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@v1
-POSTHOOK: Input: default@v2
-#### A masked pattern was here ####
-234
-PREHOOK: query: select count(*) from v1 a join v1 b on a.value = b.value
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@v1
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from v1 a join v1 b on a.value = b.value
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@v1
-#### A masked pattern was here ####
-156
-PREHOOK: query: create view v3 as select v1.value val from v1 join cbo_t1 on v1.c_boolean
= cbo_t1.c_boolean
-PREHOOK: type: CREATEVIEW
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@v1
-PREHOOK: Output: database:default
-PREHOOK: Output: default@v3
-POSTHOOK: query: create view v3 as select v1.value val from v1 join cbo_t1 on v1.c_boolean
= cbo_t1.c_boolean
-POSTHOOK: type: CREATEVIEW
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@v1
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@v3
-PREHOOK: query: select count(val) from v3 where val != '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@v1
-PREHOOK: Input: default@v3
-#### A masked pattern was here ####
-POSTHOOK: query: select count(val) from v3 where val != '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@v1
-POSTHOOK: Input: default@v3
-#### A masked pattern was here ####
-96
-PREHOOK: query: with q1 as ( select key from cbo_t1 where key = '1')
-select count(*) from q1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: with q1 as ( select key from cbo_t1 where key = '1')
-select count(*) from q1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-#### A masked pattern was here ####
-12
-PREHOOK: query: with q1 as ( select value from v1 where c_boolean = false)
-select count(value) from q1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@v1
-#### A masked pattern was here ####
-POSTHOOK: query: with q1 as ( select value from v1 where c_boolean = false)
-select count(value) from q1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@v1
-#### A masked pattern was here ####
-2
-PREHOOK: query: create view v4 as
-with q1 as ( select key,c_int from cbo_t1  where key = '1')
-select * from q1
-PREHOOK: type: CREATEVIEW
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Output: database:default
-PREHOOK: Output: default@v4
-POSTHOOK: query: create view v4 as
-with q1 as ( select key,c_int from cbo_t1  where key = '1')
-select * from q1
-POSTHOOK: type: CREATEVIEW
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Output: database:default
-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 sum(c_int) from (select c_int from q1) a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-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 sum(c_int) from (select c_int from q1) a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@v1
-#### A masked pattern was here ####
-2
-PREHOOK: query: with q1 as ( select cbo_t1.c_int c_int from q2 join cbo_t1 where q2.c_int
= cbo_t1.c_int  and cbo_t1.dt='2014'),
-q2 as ( select c_int,c_boolean from v1  where value = '1' or dt = '14')
-select count(*) from q1 join q2 join v4 on q1.c_int = q2.c_int and v4.c_int = q2.c_int
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@v1
-PREHOOK: Input: default@v4
-#### A masked pattern was here ####
-POSTHOOK: query: with q1 as ( select cbo_t1.c_int c_int from q2 join cbo_t1 where q2.c_int
= cbo_t1.c_int  and cbo_t1.dt='2014'),
-q2 as ( select c_int,c_boolean from v1  where value = '1' or dt = '14')
-select count(*) from q1 join q2 join v4 on q1.c_int = q2.c_int and v4.c_int = q2.c_int
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@v1
-POSTHOOK: Input: default@v4
-#### A masked pattern was here ####
-31104
-PREHOOK: query: drop view v1
-PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v1
-PREHOOK: Output: default@v1
-POSTHOOK: query: drop view v1
-POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v1
-POSTHOOK: Output: default@v1
-PREHOOK: query: drop view v2
-PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v2
-PREHOOK: Output: default@v2
-POSTHOOK: query: drop view v2
-POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v2
-POSTHOOK: Output: default@v2
-PREHOOK: query: drop view v3
-PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v3
-PREHOOK: Output: default@v3
-POSTHOOK: query: drop view v3
-POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v3
-POSTHOOK: Output: default@v3
-PREHOOK: query: drop view v4
-PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v4
-PREHOOK: Output: default@v4
-POSTHOOK: query: drop view v4
-POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v4
-POSTHOOK: Output: default@v4


Mime
View raw message