http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/cbo_views.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/cbo_views.q.out b/ql/src/test/results/clientpositive/tez/cbo_views.q.out deleted file mode 100644 index 4a7b935..0000000 --- a/ql/src/test/results/clientpositive/tez/cbo_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
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out b/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out deleted file mode 100644 index 52b584a..0000000 --- a/ql/src/test/results/clientpositive/tez/cbo_windowing.q.out +++ /dev/null @@ -1,293 +0,0 @@ -PREHOOK: query: -- 9. Test Windowing Functions --- SORT_QUERY_RESULTS - -select count(c_int) over() 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: -- 9. Test Windowing Functions --- SORT_QUERY_RESULTS - -select count(c_int) over() from cbo_t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cbo_t1 -POSTHOOK: Input: default@cbo_t1@dt=2014 -#### A masked pattern was here #### -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -PREHOOK: query: select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key), 2), lead(c_int, 2, c_int) over(partition by c_float order by key), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn -PREHOOK: type: QUERY -PREHOOK: Input: default@cbo_t1 -PREHOOK: Input: default@cbo_t1@dt=2014 -#### A masked pattern was here #### -POSTHOOK: query: select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key), 2), lead(c_int, 2, c_int) over(partition by c_float order by key), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cbo_t1 -POSTHOOK: Input: default@cbo_t1@dt=2014 -#### A masked pattern was here #### -0 NULL NULL NULL 1 1 1 0.0 NULL NULL -0 NULL NULL NULL 2 1 1 0.0 NULL NULL -16 16.0 1 1 10 5 3 0.24 1 1.0 -16 16.0 1 1 11 5 3 0.24 1 1.0 -16 16.0 1 1 12 5 3 0.24 1 1.0 -16 16.0 1 1 13 5 3 0.24 1 1.0 -16 16.0 1 1 14 5 3 0.24 1 1.0 -16 16.0 1 1 15 5 3 0.24 1 1.0 -16 16.0 1 1 16 5 3 0.24 1 1.0 -16 16.0 1 1 5 5 3 0.24 1 1.0 -16 16.0 1 1 6 5 3 0.24 1 1.0 -16 16.0 1 1 7 5 3 0.24 1 1.0 -16 16.0 1 1 8 5 3 0.24 1 1.0 -16 16.0 1 1 9 5 3 0.24 1 1.0 -18 18.0 1 1 17 17 4 0.94 1 1.0 -18 18.0 1 1 18 17 4 0.94 1 1.0 -2 2.0 1 1 1 1 1 0.0 1 1.0 -2 2.0 1 1 2 1 1 0.0 1 1.0 -4 4.0 1 1 3 3 2 0.12 1 1.0 -4 4.0 1 1 4 3 2 0.12 1 1.0 -PREHOOK: query: select * from (select count(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key),2), lead(c_int, 2, c_int) over(partition by c_float order by key ), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn) 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(c_int) over(partition by c_float order by key), sum(c_float) over(partition by c_float order by key), max(c_int) over(partition by c_float order by key), min(c_int) over(partition by c_float order by key), row_number() over(partition by c_float order by key) as rn, rank() over(partition by c_float order by key), dense_rank() over(partition by c_float order by key), round(percent_rank() over(partition by c_float order by key),2), lead(c_int, 2, c_int) over(partition by c_float order by key ), lag(c_float, 2, c_float) over(partition by c_float order by key) from cbo_t1 order by rn) cbo_t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cbo_t1 -POSTHOOK: Input: default@cbo_t1@dt=2014 -#### A masked pattern was here #### -0 NULL NULL NULL 1 1 1 0.0 NULL NULL -0 NULL NULL NULL 2 1 1 0.0 NULL NULL -16 16.0 1 1 10 5 3 0.24 1 1.0 -16 16.0 1 1 11 5 3 0.24 1 1.0 -16 16.0 1 1 12 5 3 0.24 1 1.0 -16 16.0 1 1 13 5 3 0.24 1 1.0 -16 16.0 1 1 14 5 3 0.24 1 1.0 -16 16.0 1 1 15 5 3 0.24 1 1.0 -16 16.0 1 1 16 5 3 0.24 1 1.0 -16 16.0 1 1 5 5 3 0.24 1 1.0 -16 16.0 1 1 6 5 3 0.24 1 1.0 -16 16.0 1 1 7 5 3 0.24 1 1.0 -16 16.0 1 1 8 5 3 0.24 1 1.0 -16 16.0 1 1 9 5 3 0.24 1 1.0 -18 18.0 1 1 17 17 4 0.94 1 1.0 -18 18.0 1 1 18 17 4 0.94 1 1.0 -2 2.0 1 1 1 1 1 0.0 1 1.0 -2 2.0 1 1 2 1 1 0.0 1 1.0 -4 4.0 1 1 3 3 2 0.12 1 1.0 -4 4.0 1 1 4 3 2 0.12 1 1.0 -PREHOOK: query: select x from (select count(c_int) over() as x, sum(c_float) over() 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 x from (select count(c_int) over() as x, sum(c_float) over() 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 #### -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -18 -PREHOOK: query: select 1+sum(c_int) over() 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: select 1+sum(c_int) over() from cbo_t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cbo_t1 -POSTHOOK: Input: default@cbo_t1@dt=2014 -#### A masked pattern was here #### -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -19 -PREHOOK: query: select sum(c_int)+sum(sum(c_int)) over() 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: select sum(c_int)+sum(sum(c_int)) over() from cbo_t1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cbo_t1 -POSTHOOK: Input: default@cbo_t1@dt=2014 -#### A masked pattern was here #### -36 -PREHOOK: query: select * from (select max(c_int) over (partition by key order by value Rows UNBOUNDED PRECEDING), min(c_int) over (partition by key order by value rows current row), count(c_int) over(partition by key order by value ROWS 1 PRECEDING), avg(value) over (partition by key order by value Rows between unbounded preceding and unbounded following), sum(value) over (partition by key order by value rows between unbounded preceding and current row), avg(c_float) over (partition by key order by value Rows between 1 preceding and unbounded following), sum(c_float) over (partition by key order by value rows between 1 preceding and current row), max(c_float) over (partition by key order by value rows between 1 preceding and unbounded following), min(c_float) over (partition by key order by value rows between 1 preceding and 1 following) 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 max(c_int) over (partition by key order by value Rows UNBOUNDED PRECEDING), min(c_int) over (partition by key order by value rows current row), count(c_int) over(partition by key order by value ROWS 1 PRECEDING), avg(value) over (partition by key order by value Rows between unbounded preceding and unbounded following), sum(value) over (partition by key order by value rows between unbounded preceding and current row), avg(c_float) over (partition by key order by value Rows between 1 preceding and unbounded following), sum(c_float) over (partition by key order by value rows between 1 preceding and current row), max(c_float) over (partition by key order by value rows between 1 preceding and unbounded following), min(c_float) over (partition by key order by value rows between 1 preceding and 1 following) 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 1 1 1.0 1.0 1.0 1.0 1.0 1.0 -1 1 1 1.0 1.0 1.0 1.0 1.0 1.0 -1 1 1 1.0 1.0 1.0 1.0 1.0 1.0 -1 1 1 1.0 1.0 1.0 1.0 1.0 1.0 -1 1 2 1.0 10.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 11.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 12.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 2.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 2.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 2.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 2.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 3.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 4.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 5.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 6.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 7.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 8.0 1.0 2.0 1.0 1.0 -1 1 2 1.0 9.0 1.0 2.0 1.0 1.0 -NULL NULL 0 NULL NULL NULL NULL NULL NULL -NULL NULL 0 NULL NULL NULL NULL NULL NULL -PREHOOK: query: select i, a, h, b, c, d, e, f, g, a as x, a +1 as y from (select max(c_int) over (partition by key order by value range UNBOUNDED PRECEDING) a, min(c_int) over (partition by key order by value range current row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c, avg(value) over (partition by key order by value range between unbounded preceding and unbounded following) d, sum(value) over (partition by key order by value range between unbounded preceding and current row) e, avg(c_float) over (partition by key order by value range between 1 preceding and unbounded following) f, sum(c_float) over (partition by key order by value range between 1 preceding and current row) g, max(c_float) over (partition by key order by value range between 1 preceding and unbounded following) h, min(c_float) over (partition by key order by value range between 1 preceding and 1 following) i 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 i, a, h, b, c, d, e, f, g, a as x, a +1 as y from (select max(c_int) over (partition by key order by value range UNBOUNDED PRECEDING) a, min(c_int) over (partition by key order by value range current row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c, avg(value) over (partition by key order by value range between unbounded preceding and unbounded following) d, sum(value) over (partition by key order by value range between unbounded preceding and current row) e, avg(c_float) over (partition by key order by value range between 1 preceding and unbounded following) f, sum(c_float) over (partition by key order by value range between 1 preceding and current row) g, max(c_float) over (partition by key order by value range between 1 preceding and unbounded following) h, min(c_float) over (partition by key order by value range between 1 preceding and 1 following) i 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.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 12 1.0 12.0 1.0 12.0 1 2 -1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2 -1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2 -1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2 -1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2 -1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2 -1.0 1 1.0 1 2 1.0 2.0 1.0 2.0 1 2 -NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL -PREHOOK: query: select *, rank() over(partition by key order by value) as rr from src1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src1 -#### A masked pattern was here #### -POSTHOOK: query: select *, rank() over(partition by key order by value) as rr from src1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src1 -#### A masked pattern was here #### - 1 - 1 - 1 - 1 - val_165 5 - val_193 6 - val_265 7 - val_27 8 - val_409 9 - val_484 10 -128 1 -146 val_146 1 -150 val_150 1 -213 val_213 1 -224 1 -238 val_238 1 -255 val_255 1 -273 val_273 1 -278 val_278 1 -311 val_311 1 -369 1 -401 val_401 1 -406 val_406 1 -66 val_66 1 -98 val_98 1 -PREHOOK: query: select *, rank() over(partition by key order by value) from src1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src1 -#### A masked pattern was here #### -POSTHOOK: query: select *, rank() over(partition by key order by value) from src1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src1 -#### A masked pattern was here #### - 1 - 1 - 1 - 1 - val_165 5 - val_193 6 - val_265 7 - val_27 8 - val_409 9 - val_484 10 -128 1 -146 val_146 1 -150 val_150 1 -213 val_213 1 -224 1 -238 val_238 1 -255 val_255 1 -273 val_273 1 -278 val_278 1 -311 val_311 1 -369 1 -401 val_401 1 -406 val_406 1 -66 val_66 1 -98 val_98 1 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/column_names_with_leading_and_trailing_spaces.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/column_names_with_leading_and_trailing_spaces.q.out b/ql/src/test/results/clientpositive/tez/column_names_with_leading_and_trailing_spaces.q.out deleted file mode 100644 index 18314b5..0000000 --- a/ql/src/test/results/clientpositive/tez/column_names_with_leading_and_trailing_spaces.q.out +++ /dev/null @@ -1,85 +0,0 @@ -PREHOOK: query: create table space (` left` string, ` middle ` string, `right ` string) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@space -POSTHOOK: query: create table space (` left` string, ` middle ` string, `right ` string) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@space -PREHOOK: query: desc formatted space -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@space -POSTHOOK: query: desc formatted space -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@space -# col_name data_type comment - - left string - middle string -right string - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - numFiles 0 - numRows 0 - rawDataSize 0 - totalSize 0 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: insert into space values ("1", "2", "3") -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@space -POSTHOOK: query: insert into space values ("1", "2", "3") -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@space -POSTHOOK: Lineage: space. left SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: space. middle SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: space.right SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -PREHOOK: query: select * from space -PREHOOK: type: QUERY -PREHOOK: Input: default@space -#### A masked pattern was here #### -POSTHOOK: query: select * from space -POSTHOOK: type: QUERY -POSTHOOK: Input: default@space -#### A masked pattern was here #### -1 2 3 -PREHOOK: query: insert into space (` middle `) values("2") -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 -PREHOOK: Output: default@space -POSTHOOK: query: insert into space (` middle `) values("2") -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 -POSTHOOK: Output: default@space -POSTHOOK: Lineage: space. left SIMPLE [] -POSTHOOK: Lineage: space. middle SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: space.right SIMPLE [] -PREHOOK: query: select * from space order by ` left` -PREHOOK: type: QUERY -PREHOOK: Input: default@space -#### A masked pattern was here #### -POSTHOOK: query: select * from space order by ` left` -POSTHOOK: type: QUERY -POSTHOOK: Input: default@space -#### A masked pattern was here #### -NULL 2 NULL -1 2 3 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out b/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out deleted file mode 100644 index 1614cb0..0000000 --- a/ql/src/test/results/clientpositive/tez/constprog_dpp.q.out +++ /dev/null @@ -1,87 +0,0 @@ -PREHOOK: query: drop table if exists tb1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists tb1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table tb1 (id int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@tb1 -POSTHOOK: query: create table tb1 (id int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@tb1 -PREHOOK: query: drop table if exists tb2 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists tb2 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table tb2 (id smallint) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@tb2 -POSTHOOK: query: create table tb2 (id smallint) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@tb2 -PREHOOK: query: explain -select a.id from tb1 a -left outer join -(select id from tb2 -union all -select 2 as id from tb2 limit 1) b -on a.id=b.id -PREHOOK: type: QUERY -POSTHOOK: query: explain -select a.id from tb1 a -left outer join -(select id from tb2 -union all -select 2 as id from tb2 limit 1) b -on a.id=b.id -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Map 3 <- Union 4 (CONTAINS) -Map 6 <- Union 4 (CONTAINS) -Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE) -Reducer 5 <- Union 4 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_17] - Merge Join Operator [MERGEJOIN_21] (rows=1 width=0) - Conds:RS_13._col0=RS_14._col0(Left Outer),Output:["_col0"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_13] - PartitionCols:_col0 - Select Operator [SEL_1] (rows=1 width=0) - Output:["_col0"] - TableScan [TS_0] (rows=1 width=0) - default@tb1,a,Tbl:PARTIAL,Col:NONE,Output:["id"] - <-Reducer 5 [SIMPLE_EDGE] - SHUFFLE [RS_14] - PartitionCols:_col0 - Limit [LIM_11] (rows=1 width=0) - Number of rows:1 - Select Operator [SEL_10] (rows=1 width=0) - Output:["_col0"] - <-Union 4 [SIMPLE_EDGE] - <-Map 3 [CONTAINS] - Reduce Output Operator [RS_9] - Limit [LIM_8] (rows=1 width=0) - Number of rows:1 - Select Operator [SEL_3] (rows=1 width=0) - Output:["_col0"] - TableScan [TS_2] (rows=1 width=0) - Output:["id"] - <-Map 6 [CONTAINS] - Reduce Output Operator [RS_9] - Limit [LIM_8] (rows=1 width=0) - Number of rows:1 - Select Operator [SEL_5] (rows=1 width=0) - Output:["_col0"] - TableScan [TS_4] (rows=1 width=0) - http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/constprog_partitioner.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/constprog_partitioner.q.out b/ql/src/test/results/clientpositive/tez/constprog_partitioner.q.out deleted file mode 100644 index 79df412..0000000 --- a/ql/src/test/results/clientpositive/tez/constprog_partitioner.q.out +++ /dev/null @@ -1,119 +0,0 @@ -PREHOOK: query: EXPLAIN -SELECT src1.key, src1.key + 1, src2.value - FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN -SELECT src1.key, src1.key + 1, src2.value - FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100 -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_10] - Select Operator [SEL_9] (rows=275 width=10) - Output:["_col0","_col1","_col2"] - Merge Join Operator [MERGEJOIN_15] (rows=275 width=10) - Conds:RS_6.'100'=RS_7.'100'(Inner),Output:["_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_6] - PartitionCols:'100' - Select Operator [SEL_2] (rows=250 width=10) - Filter Operator [FIL_13] (rows=250 width=10) - predicate:(UDFToDouble(key) = 100.0) - TableScan [TS_0] (rows=500 width=10) - default@src,src1,Tbl:COMPLETE,Col:NONE,Output:["key"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_7] - PartitionCols:'100' - Select Operator [SEL_5] (rows=250 width=10) - Output:["_col1"] - Filter Operator [FIL_14] (rows=250 width=10) - predicate:(UDFToDouble(key) = 100.0) - TableScan [TS_3] (rows=500 width=10) - default@src,src1,Tbl:COMPLETE,Col:NONE,Output:["key","value"] - -PREHOOK: query: SELECT src1.key, src1.key + 1, src2.value - FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT src1.key, src1.key + 1, src2.value - FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -100 101.0 val_100 -100 101.0 val_100 -100 101.0 val_100 -100 101.0 val_100 -PREHOOK: query: EXPLAIN -SELECT l_partkey, l_suppkey -FROM lineitem li -WHERE li.l_linenumber = 1 AND - li.l_orderkey IN (SELECT l_orderkey FROM lineitem WHERE l_shipmode = 'AIR' AND l_linenumber = li.l_linenumber) -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN -SELECT l_partkey, l_suppkey -FROM lineitem li -WHERE li.l_linenumber = 1 AND - li.l_orderkey IN (SELECT l_orderkey FROM lineitem WHERE l_shipmode = 'AIR' AND l_linenumber = li.l_linenumber) -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_12] - Select Operator [SEL_11] (rows=55 width=119) - Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_17] (rows=55 width=119) - Conds:RS_8._col0, 1=RS_9._col0, 1(Left Semi),Output:["_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_8] - PartitionCols:_col0, 1 - Select Operator [SEL_2] (rows=50 width=119) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_15] (rows=50 width=119) - predicate:((l_linenumber = 1) and l_orderkey is not null) - TableScan [TS_0] (rows=100 width=119) - default@lineitem,li,Tbl:COMPLETE,Col:NONE,Output:["l_orderkey","l_partkey","l_suppkey","l_linenumber"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_9] - PartitionCols:_col0, 1 - Group By Operator [GBY_7] (rows=25 width=119) - Output:["_col0","_col1"],keys:_col0, 1 - Select Operator [SEL_5] (rows=25 width=119) - Output:["_col0"] - Filter Operator [FIL_16] (rows=25 width=119) - predicate:(((l_shipmode = 'AIR') and (l_linenumber = 1)) and l_orderkey is not null) - TableScan [TS_3] (rows=100 width=119) - default@lineitem,li,Tbl:COMPLETE,Col:NONE,Output:["l_orderkey","l_linenumber","l_shipmode"] - -PREHOOK: query: SELECT l_partkey, l_suppkey -FROM lineitem li -WHERE li.l_linenumber = 1 AND - li.l_orderkey IN (SELECT l_orderkey FROM lineitem WHERE l_shipmode = 'AIR' AND l_linenumber = li.l_linenumber) -PREHOOK: type: QUERY -PREHOOK: Input: default@lineitem -#### A masked pattern was here #### -POSTHOOK: query: SELECT l_partkey, l_suppkey -FROM lineitem li -WHERE li.l_linenumber = 1 AND - li.l_orderkey IN (SELECT l_orderkey FROM lineitem WHERE l_shipmode = 'AIR' AND l_linenumber = li.l_linenumber) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@lineitem -#### A masked pattern was here #### -108570 8571 -4297 1798 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/constprog_semijoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/constprog_semijoin.q.out b/ql/src/test/results/clientpositive/tez/constprog_semijoin.q.out deleted file mode 100644 index 15a8351..0000000 --- a/ql/src/test/results/clientpositive/tez/constprog_semijoin.q.out +++ /dev/null @@ -1,494 +0,0 @@ -PREHOOK: query: create table table1 (id int, val string, val1 string, dimid int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@table1 -POSTHOOK: query: create table table1 (id int, val string, val1 string, dimid int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@table1 -PREHOOK: query: insert into table1 (id, val, val1, dimid) values (1, 't1val01', 'val101', 100), (2, 't1val02', 'val102', 200), (3, 't1val03', 'val103', 103), (3, 't1val01', 'val104', 100), (2, 't1val05', 'val105', 200), (3, 't1val01', 'val106', 103), (1, 't1val07', 'val107', 200), (2, 't1val01', 'val108', 200), (3, 't1val09', 'val109', 103), (4,'t1val01', 'val110', 200) -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@table1 -POSTHOOK: query: insert into table1 (id, val, val1, dimid) values (1, 't1val01', 'val101', 100), (2, 't1val02', 'val102', 200), (3, 't1val03', 'val103', 103), (3, 't1val01', 'val104', 100), (2, 't1val05', 'val105', 200), (3, 't1val01', 'val106', 103), (1, 't1val07', 'val107', 200), (2, 't1val01', 'val108', 200), (3, 't1val09', 'val109', 103), (4,'t1val01', 'val110', 200) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@table1 -POSTHOOK: Lineage: table1.dimid EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: table1.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: table1.val SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: table1.val1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -PREHOOK: query: create table table2 (id int, val2 string) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@table2 -POSTHOOK: query: create table table2 (id int, val2 string) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@table2 -PREHOOK: query: insert into table2 (id, val2) values (1, 't2val201'), (2, 't2val202'), (3, 't2val203') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 -PREHOOK: Output: default@table2 -POSTHOOK: query: insert into table2 (id, val2) values (1, 't2val201'), (2, 't2val202'), (3, 't2val203') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 -POSTHOOK: Output: default@table2 -POSTHOOK: Lineage: table2.id EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: table2.val2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -PREHOOK: query: create table table3 (id int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@table3 -POSTHOOK: query: create table table3 (id int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@table3 -PREHOOK: query: insert into table3 (id) values (100), (100), (101), (102), (103) -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 -PREHOOK: Output: default@table3 -POSTHOOK: query: insert into table3 (id) values (100), (100), (101), (102), (103) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__3 -POSTHOOK: Output: default@table3 -POSTHOOK: Lineage: table3.id EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id where table1.val = 't1val01' -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id where table1.val = 't1val01' -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_12] - Select Operator [SEL_11] (rows=5 width=22) - Output:["_col0","_col1","_col2"] - Merge Join Operator [MERGEJOIN_17] (rows=5 width=22) - Conds:RS_8._col3=RS_9._col0(Left Semi),Output:["_col0","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_8] - PartitionCols:_col3 - Select Operator [SEL_2] (rows=5 width=20) - Output:["_col0","_col2","_col3"] - Filter Operator [FIL_15] (rows=5 width=20) - predicate:((val = 't1val01') and dimid is not null) - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_9] - PartitionCols:_col0 - Group By Operator [GBY_7] (rows=5 width=3) - Output:["_col0"],keys:_col0 - Select Operator [SEL_5] (rows=5 width=3) - Output:["_col0"] - Filter Operator [FIL_16] (rows=5 width=3) - predicate:id is not null - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id where table1.val = 't1val01' -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id where table1.val = 't1val01' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -1 t1val01 val101 -3 t1val01 val104 -3 t1val01 val106 -PREHOOK: query: explain select table1.id, table1.val, table2.val2 from table1 inner join table2 on table1.val = 't1val01' and table1.id = table2.id left semi join table3 on table1.dimid = table3.id -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table2.val2 from table1 inner join table2 on table1.val = 't1val01' and table1.id = table2.id left semi join table3 on table1.dimid = table3.id -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) -Reducer 3 <- Map 5 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 3 - File Output Operator [FS_18] - Select Operator [SEL_17] (rows=5 width=24) - Output:["_col0","_col1","_col2"] - Merge Join Operator [MERGEJOIN_28] (rows=5 width=24) - Conds:RS_14._col0=RS_15._col0(Inner),Output:["_col0","_col4"] - <-Map 5 [SIMPLE_EDGE] - SHUFFLE [RS_15] - PartitionCols:_col0 - Select Operator [SEL_8] (rows=3 width=10) - Output:["_col0","_col1"] - Filter Operator [FIL_26] (rows=3 width=10) - predicate:id is not null - TableScan [TS_6] (rows=3 width=10) - default@table2,table2,Tbl:COMPLETE,Col:NONE,Output:["id","val2"] - <-Reducer 2 [SIMPLE_EDGE] - SHUFFLE [RS_14] - PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_27] (rows=5 width=22) - Conds:RS_11._col2=RS_12._col0(Left Semi),Output:["_col0"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_11] - PartitionCols:_col2 - Select Operator [SEL_2] (rows=5 width=20) - Output:["_col0","_col2"] - Filter Operator [FIL_24] (rows=5 width=20) - predicate:((val = 't1val01') and id is not null and dimid is not null) - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","dimid"] - <-Map 4 [SIMPLE_EDGE] - SHUFFLE [RS_12] - PartitionCols:_col0 - Group By Operator [GBY_10] (rows=5 width=3) - Output:["_col0"],keys:_col0 - Select Operator [SEL_5] (rows=5 width=3) - Output:["_col0"] - Filter Operator [FIL_25] (rows=5 width=3) - predicate:id is not null - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table2.val2 from table1 inner join table2 on table1.val = 't1val01' and table1.id = table2.id left semi join table3 on table1.dimid = table3.id -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table2 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table2.val2 from table1 inner join table2 on table1.val = 't1val01' and table1.id = table2.id left semi join table3 on table1.dimid = table3.id -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table2 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -1 t1val01 t2val201 -3 t1val01 t2val203 -3 t1val01 t2val203 -PREHOOK: query: explain select table1.id, table1.val, table2.val2 from table1 left semi join table3 on table1.dimid = table3.id inner join table2 on table1.val = 't1val01' and table1.id = table2.id -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table2.val2 from table1 left semi join table3 on table1.dimid = table3.id inner join table2 on table1.val = 't1val01' and table1.id = table2.id -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) -Reducer 3 <- Map 5 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 3 - File Output Operator [FS_18] - Select Operator [SEL_17] (rows=5 width=24) - Output:["_col0","_col1","_col2"] - Merge Join Operator [MERGEJOIN_28] (rows=5 width=24) - Conds:RS_14._col0=RS_15._col0(Inner),Output:["_col0","_col4"] - <-Map 5 [SIMPLE_EDGE] - SHUFFLE [RS_15] - PartitionCols:_col0 - Select Operator [SEL_8] (rows=3 width=10) - Output:["_col0","_col1"] - Filter Operator [FIL_26] (rows=3 width=10) - predicate:id is not null - TableScan [TS_6] (rows=3 width=10) - default@table2,table2,Tbl:COMPLETE,Col:NONE,Output:["id","val2"] - <-Reducer 2 [SIMPLE_EDGE] - SHUFFLE [RS_14] - PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_27] (rows=5 width=22) - Conds:RS_11._col2=RS_12._col0(Left Semi),Output:["_col0"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_11] - PartitionCols:_col2 - Select Operator [SEL_2] (rows=5 width=20) - Output:["_col0","_col2"] - Filter Operator [FIL_24] (rows=5 width=20) - predicate:((val = 't1val01') and dimid is not null and id is not null) - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","dimid"] - <-Map 4 [SIMPLE_EDGE] - SHUFFLE [RS_12] - PartitionCols:_col0 - Group By Operator [GBY_10] (rows=5 width=3) - Output:["_col0"],keys:_col0 - Select Operator [SEL_5] (rows=5 width=3) - Output:["_col0"] - Filter Operator [FIL_25] (rows=5 width=3) - predicate:id is not null - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table2.val2 from table1 left semi join table3 on table1.dimid = table3.id inner join table2 on table1.val = 't1val01' and table1.id = table2.id -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table2 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table2.val2 from table1 left semi join table3 on table1.dimid = table3.id inner join table2 on table1.val = 't1val01' and table1.id = table2.id -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table2 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -1 t1val01 t2val201 -3 t1val01 t2val203 -3 t1val01 t2val203 -PREHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid <> 100 -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid <> 100 -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_12] - Merge Join Operator [MERGEJOIN_17] (rows=2 width=3) - Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_8] - PartitionCols:100, true - Select Operator [SEL_2] (rows=1 width=20) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_15] (rows=1 width=20) - predicate:false - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_9] - PartitionCols:_col0, _col1 - Group By Operator [GBY_7] (rows=2 width=3) - Output:["_col0","_col1"],keys:_col0, _col1 - Select Operator [SEL_5] (rows=2 width=3) - Output:["_col0","_col1"] - Filter Operator [FIL_16] (rows=2 width=3) - predicate:((id = 100) and (id = 100) is not null) - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid <> 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid <> 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -PREHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid IN (100,200) -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid IN (100,200) -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_12] - Merge Join Operator [MERGEJOIN_17] (rows=5 width=22) - Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_8] - PartitionCols:100, true - Select Operator [SEL_2] (rows=5 width=20) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_15] (rows=5 width=20) - predicate:((dimid = 100) and (dimid = 100) is not null) - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_9] - PartitionCols:_col0, _col1 - Group By Operator [GBY_7] (rows=2 width=3) - Output:["_col0","_col1"],keys:_col0, _col1 - Select Operator [SEL_5] (rows=2 width=3) - Output:["_col0","_col1"] - Filter Operator [FIL_16] (rows=2 width=3) - predicate:((id = 100) and (id = 100) is not null) - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid IN (100,200) -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid IN (100,200) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -1 t1val01 val101 -3 t1val01 val104 -PREHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 200 -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 200 -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_12] - Merge Join Operator [MERGEJOIN_17] (rows=2 width=3) - Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_8] - PartitionCols:100, true - Select Operator [SEL_2] (rows=1 width=20) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_15] (rows=1 width=20) - predicate:false - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_9] - PartitionCols:_col0, _col1 - Group By Operator [GBY_7] (rows=2 width=3) - Output:["_col0","_col1"],keys:_col0, _col1 - Select Operator [SEL_5] (rows=2 width=3) - Output:["_col0","_col1"] - Filter Operator [FIL_16] (rows=2 width=3) - predicate:((id = 100) and (id = 100) is not null) - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 200 -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 200 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -PREHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 100 -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 100 -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_12] - Merge Join Operator [MERGEJOIN_17] (rows=5 width=22) - Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_8] - PartitionCols:100, true - Select Operator [SEL_2] (rows=5 width=20) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_15] (rows=5 width=20) - predicate:((dimid = 100) and (dimid = 100) is not null) - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_9] - PartitionCols:_col0, _col1 - Group By Operator [GBY_7] (rows=2 width=3) - Output:["_col0","_col1"],keys:_col0, _col1 - Select Operator [SEL_5] (rows=2 width=3) - Output:["_col0","_col1"] - Filter Operator [FIL_16] (rows=2 width=3) - predicate:((id = 100) and (id = 100) is not null) - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -1 t1val01 val101 -3 t1val01 val104 -PREHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 -PREHOOK: type: QUERY -POSTHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_12] - Merge Join Operator [MERGEJOIN_17] (rows=5 width=22) - Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_8] - PartitionCols:100, true - Select Operator [SEL_2] (rows=5 width=20) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_15] (rows=5 width=20) - predicate:((dimid = 100) and (dimid = 100) is not null) - TableScan [TS_0] (rows=10 width=20) - default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_9] - PartitionCols:_col0, _col1 - Group By Operator [GBY_7] (rows=2 width=3) - Output:["_col0","_col1"],keys:_col0, _col1 - Select Operator [SEL_5] (rows=2 width=3) - Output:["_col0","_col1"] - Filter Operator [FIL_16] (rows=2 width=3) - predicate:((id = 100) and (id = 100) is not null) - TableScan [TS_3] (rows=5 width=3) - default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"] - -PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@table1 -PREHOOK: Input: default@table3 -#### A masked pattern was here #### -POSTHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@table1 -POSTHOOK: Input: default@table3 -#### A masked pattern was here #### -1 t1val01 val101 -3 t1val01 val104
