http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/explain_locks.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explain_locks.q.out b/ql/src/test/results/clientpositive/explain_locks.q.out index 72aa410..ed7f1e8 100644 --- a/ql/src/test/results/clientpositive/explain_locks.q.out +++ b/ql/src/test/results/clientpositive/explain_locks.q.out @@ -4,8 +4,12 @@ POSTHOOK: query: explain locks drop table test_explain_locks POSTHOOK: type: DROPTABLE PREHOOK: query: explain locks create table test_explain_locks (a int, b int) PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@test_explain_locks POSTHOOK: query: explain locks create table test_explain_locks (a int, b int) POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@test_explain_locks LOCK INFORMATION: default -> SHARED_READ PREHOOK: query: drop table if exists target @@ -50,8 +54,24 @@ POSTHOOK: Lineage: target PARTITION(p=2,q=2).a SCRIPT [] POSTHOOK: Lineage: target PARTITION(p=2,q=2).b SCRIPT [] PREHOOK: query: explain locks update target set b = 1 where p in (select t.q1 from source t where t.a1=5) PREHOOK: type: QUERY +PREHOOK: Input: default@source +PREHOOK: Input: default@target +PREHOOK: Input: default@target@p=1/q=2 +PREHOOK: Input: default@target@p=1/q=3 +PREHOOK: Input: default@target@p=2/q=2 +PREHOOK: Output: default@target@p=1/q=2 +PREHOOK: Output: default@target@p=1/q=3 +PREHOOK: Output: default@target@p=2/q=2 POSTHOOK: query: explain locks update target set b = 1 where p in (select t.q1 from source t where t.a1=5) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source +POSTHOOK: Input: default@target +POSTHOOK: Input: default@target@p=1/q=2 +POSTHOOK: Input: default@target@p=1/q=3 +POSTHOOK: Input: default@target@p=2/q=2 +POSTHOOK: Output: default@target@p=1/q=2 +POSTHOOK: Output: default@target@p=1/q=3 +POSTHOOK: Output: default@target@p=2/q=2 LOCK INFORMATION: default.source -> SHARED_READ default.target.p=1/q=2 -> SHARED_READ @@ -62,21 +82,62 @@ default.target.p=1/q=3 -> SHARED_WRITE default.target.p=1/q=2 -> SHARED_WRITE PREHOOK: query: explain locks update source set b1 = 1 where p1 in (select t.q from target t where t.p=2) PREHOOK: type: QUERY +PREHOOK: Input: default@source +PREHOOK: Input: default@target +PREHOOK: Input: default@target@p=2/q=2 +PREHOOK: Output: default@source POSTHOOK: query: explain locks update source set b1 = 1 where p1 in (select t.q from target t where t.p=2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source +POSTHOOK: Input: default@target +POSTHOOK: Input: default@target@p=2/q=2 +POSTHOOK: Output: default@source LOCK INFORMATION: default.target -> SHARED_READ default.target.p=2/q=2 -> SHARED_READ default.source -> SHARED_WRITE PREHOOK: query: explain formatted locks update source set b1 = 1 where p1 in (select t.q from target t where t.p=2) PREHOOK: type: QUERY +PREHOOK: Input: default@source +PREHOOK: Input: default@target +PREHOOK: Input: default@target@p=2/q=2 +PREHOOK: Output: default@source POSTHOOK: query: explain formatted locks update source set b1 = 1 where p1 in (select t.q from target t where t.p=2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source +POSTHOOK: Input: default@target +POSTHOOK: Input: default@target@p=2/q=2 +POSTHOOK: Output: default@source {"LOCK INFORMATION:":"[default.target -> SHARED_READ, default.target.p=2/q=2 -> SHARED_READ, default.source -> SHARED_WRITE]"} PREHOOK: query: explain locks merge into target t using source s on t.a = s.a1 when matched and p = 1 and q = 2 then update set b = 1 when matched and p = 2 and q = 2 then delete when not matched and a1 > 100 then insert values(s.a1,s.b1,s.p1, s.q1) PREHOOK: type: QUERY +PREHOOK: Input: default@source +PREHOOK: Input: default@target +PREHOOK: Input: default@target@p=1/q=2 +PREHOOK: Input: default@target@p=1/q=3 +PREHOOK: Input: default@target@p=2/q=2 +PREHOOK: Output: default@merge_tmp_table +PREHOOK: Output: default@target +PREHOOK: Output: default@target@p=1/q=2 +PREHOOK: Output: default@target@p=1/q=2 +PREHOOK: Output: default@target@p=1/q=3 +PREHOOK: Output: default@target@p=1/q=3 +PREHOOK: Output: default@target@p=2/q=2 +PREHOOK: Output: default@target@p=2/q=2 POSTHOOK: query: explain locks merge into target t using source s on t.a = s.a1 when matched and p = 1 and q = 2 then update set b = 1 when matched and p = 2 and q = 2 then delete when not matched and a1 > 100 then insert values(s.a1,s.b1,s.p1, s.q1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@source +POSTHOOK: Input: default@target +POSTHOOK: Input: default@target@p=1/q=2 +POSTHOOK: Input: default@target@p=1/q=3 +POSTHOOK: Input: default@target@p=2/q=2 +POSTHOOK: Output: default@merge_tmp_table +POSTHOOK: Output: default@target@p=1/q=2 +POSTHOOK: Output: default@target@p=1/q=2 +POSTHOOK: Output: default@target@p=1/q=3 +POSTHOOK: Output: default@target@p=1/q=3 +POSTHOOK: Output: default@target@p=2/q=2 +POSTHOOK: Output: default@target@p=2/q=2 LOCK INFORMATION: default.source -> SHARED_READ default.target.p=1/q=2 -> SHARED_READ
http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/explain_logical.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explain_logical.q.out b/ql/src/test/results/clientpositive/explain_logical.q.out index c7eb6e9..fcee2e0 100644 --- a/ql/src/test/results/clientpositive/explain_logical.q.out +++ b/ql/src/test/results/clientpositive/explain_logical.q.out @@ -69,9 +69,13 @@ POSTHOOK: Lineage: V4_n1.value2 SIMPLE [(src)src3.FieldSchema(name:value, type:s PREHOOK: query: EXPLAIN LOGICAL SELECT key, count(1) FROM srcpart WHERE ds IS NOT NULL GROUP BY key PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT key, count(1) FROM srcpart WHERE ds IS NOT NULL GROUP BY key POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +#### A masked pattern was here #### LOGICAL PLAN: srcpart TableScan (TS_0) @@ -111,9 +115,13 @@ srcpart PREHOOK: query: EXPLAIN LOGICAL SELECT key, count(1) FROM (SELECT key, value FROM src) subq1 GROUP BY key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT key, count(1) FROM (SELECT key, value FROM src) subq1 GROUP BY key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### LOGICAL PLAN: src TableScan (TS_0) @@ -154,11 +162,17 @@ PREHOOK: query: EXPLAIN LOGICAL SELECT key, value FROM src UNION ALL SELECT key, value FROM srcpart WHERE ds IS NOT NULL ) S1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@srcpart +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM ( SELECT key, value FROM src UNION ALL SELECT key, value FROM srcpart WHERE ds IS NOT NULL ) S1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@srcpart +#### A masked pattern was here #### LOGICAL PLAN: $hdt$_0-subquery1:src TableScan (TS_0) @@ -192,9 +206,15 @@ $hdt$_0-subquery2:srcpart PREHOOK: query: EXPLAIN LOGICAL SELECT S1.key, S2.value FROM src S1 JOIN srcpart S2 ON S1.key = S2.key WHERE ds IS NOT NULL PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@srcpart +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT S1.key, S2.value FROM src S1 JOIN srcpart S2 ON S1.key = S2.key WHERE ds IS NOT NULL POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@srcpart +#### A masked pattern was here #### LOGICAL PLAN: $hdt$_0:s1 TableScan (TS_0) @@ -261,8 +281,14 @@ $hdt$_1:s2 PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V1_n8 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@v1_n8 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V1_n8 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@v1_n8 +#### A masked pattern was here #### LOGICAL PLAN: src TableScan (TS_0) @@ -278,8 +304,22 @@ src PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V2_n3 PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +PREHOOK: Input: default@v2_n3 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V2_n3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 +POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 +POSTHOOK: Input: default@v2_n3 +#### A masked pattern was here #### LOGICAL PLAN: srcpart TableScan (TS_0) @@ -296,8 +336,18 @@ srcpart PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V3_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@v2_n3 +PREHOOK: Input: default@v3_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V3_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@v2_n3 +POSTHOOK: Input: default@v3_n1 +#### A masked pattern was here #### LOGICAL PLAN: $hdt$_0:srcpart TableScan (TS_0) @@ -368,8 +418,20 @@ $hdt$_1:src2 PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V4_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@v1_n8 +PREHOOK: Input: default@v2_n3 +PREHOOK: Input: default@v4_n1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V4_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@v1_n8 +POSTHOOK: Input: default@v2_n3 +POSTHOOK: Input: default@v4_n1 +#### A masked pattern was here #### LOGICAL PLAN: $hdt$_0:srcpart TableScan (TS_0) @@ -488,8 +550,14 @@ POSTHOOK: Lineage: V5_n0.key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type POSTHOOK: Lineage: V5_n0.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V5_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@srcpart +PREHOOK: Input: default@v5_n0 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V5_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@srcpart +POSTHOOK: Input: default@v5_n0 +#### A masked pattern was here #### LOGICAL PLAN: srcpart TableScan (TS_0) @@ -509,8 +577,12 @@ srcpart PREHOOK: query: EXPLAIN LOGICAL SELECT s1.key, s1.cnt, s2.value FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src s2 ON (s1.key = s2.key) ORDER BY s1.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN LOGICAL SELECT s1.key, s1.cnt, s2.value FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src s2 ON (s1.key = s2.key) ORDER BY s1.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### LOGICAL PLAN: $hdt$_0:src TableScan (TS_0) http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/explain_outputs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explain_outputs.q.out b/ql/src/test/results/clientpositive/explain_outputs.q.out index d0fe893..bd7bb02 100644 --- a/ql/src/test/results/clientpositive/explain_outputs.q.out +++ b/ql/src/test/results/clientpositive/explain_outputs.q.out @@ -35,9 +35,15 @@ POSTHOOK: Lineage: t2_n14.id SCRIPT [] PREHOOK: query: explain select sum(t1_n22.id) from t1_n22 join t2_n14 on (t1_n22.id=t2_n14.id) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n22 +PREHOOK: Input: default@t2_n14 +#### A masked pattern was here #### POSTHOOK: query: explain select sum(t1_n22.id) from t1_n22 join t2_n14 on (t1_n22.id=t2_n14.id) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n22 +POSTHOOK: Input: default@t2_n14 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -142,9 +148,15 @@ POSTHOOK: Input: default@t2_n14 PREHOOK: query: explain analyze select sum(t1_n22.id) from t1_n22 join t2_n14 on (t1_n22.id=t2_n14.id) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n22 +PREHOOK: Input: default@t2_n14 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select sum(t1_n22.id) from t1_n22 join t2_n14 on (t1_n22.id=t2_n14.id) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n22 +POSTHOOK: Input: default@t2_n14 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -251,9 +263,15 @@ POSTHOOK: Input: default@t2_n14 PREHOOK: query: explain reoptimization select sum(t1_n22.id) from t1_n22 join t2_n14 on (t1_n22.id=t2_n14.id) PREHOOK: type: QUERY +PREHOOK: Input: default@t1_n22 +PREHOOK: Input: default@t2_n14 +#### A masked pattern was here #### POSTHOOK: query: explain reoptimization select sum(t1_n22.id) from t1_n22 join t2_n14 on (t1_n22.id=t2_n14.id) POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1_n22 +POSTHOOK: Input: default@t2_n14 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/explain_rearrange.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explain_rearrange.q.out b/ql/src/test/results/clientpositive/explain_rearrange.q.out index 6ff089f..448dc18 100644 --- a/ql/src/test/results/clientpositive/explain_rearrange.q.out +++ b/ql/src/test/results/clientpositive/explain_rearrange.q.out @@ -32,6 +32,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n9 +PREHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -50,6 +53,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n9 +POSTHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage [MAPRED] Stage-9 depends on stages: Stage-1, Stage-5 , consists of Stage-10, Stage-11, Stage-2 [CONDITIONAL] @@ -306,6 +312,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n9 +PREHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -324,6 +333,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n9 +POSTHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage [MAPRED] Stage-2 depends on stages: Stage-1, Stage-9 , consists of Stage-3, Stage-6, Stage-8 [CONDITIONAL] @@ -580,6 +592,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n9 +PREHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -598,6 +613,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n9 +POSTHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage [MAPRED] Stage-2 is a root stage [MAPRED] @@ -854,6 +872,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 PREHOOK: type: QUERY +PREHOOK: Input: default@tbl1_n9 +PREHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### POSTHOOK: query: explain select src1.key, src1.cnt1, src2.cnt1 from ( @@ -872,6 +893,9 @@ join on src1.key = src2.key order by src1.key, src1.cnt1, src2.cnt1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@tbl1_n9 +POSTHOOK: Input: default@tbl2_n8 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage [MAPRED] Stage-2 is a root stage [MAPRED] http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/explaindenpendencydiffengs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/explaindenpendencydiffengs.q.out b/ql/src/test/results/clientpositive/explaindenpendencydiffengs.q.out index 3a5d4e4..a31317b 100644 --- a/ql/src/test/results/clientpositive/explaindenpendencydiffengs.q.out +++ b/ql/src/test/results/clientpositive/explaindenpendencydiffengs.q.out @@ -33,8 +33,16 @@ POSTHOOK: Lineage: viewtest.a SIMPLE [(dependtest)dependtest.FieldSchema(name:a, POSTHOOK: Lineage: viewtest.b SIMPLE [] PREHOOK: query: explain dependency select count(*) from viewtest PREHOOK: type: QUERY +PREHOOK: Input: default@dependtest +PREHOOK: Input: default@dependtest@b=1 +PREHOOK: Input: default@viewtest +#### A masked pattern was here #### POSTHOOK: query: explain dependency select count(*) from viewtest POSTHOOK: type: QUERY +POSTHOOK: Input: default@dependtest +POSTHOOK: Input: default@dependtest@b=1 +POSTHOOK: Input: default@viewtest +#### A masked pattern was here #### {"input_tables":[{"tablename":"default@viewtest","tabletype":"VIRTUAL_VIEW"},{"tablename":"default@dependtest","tabletype":"MANAGED_TABLE","tableParents":"[default@viewtest]"}],"input_partitions":[{"partitionName":"default@dependtest@b=1","partitionParents":"[default@viewtest]"}]} PREHOOK: query: drop view viewtest PREHOOK: type: DROPVIEW http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/extract.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/extract.q.out b/ql/src/test/results/clientpositive/extract.q.out index 3386f66..8d736a2 100644 --- a/ql/src/test/results/clientpositive/extract.q.out +++ b/ql/src/test/results/clientpositive/extract.q.out @@ -27,10 +27,14 @@ PREHOOK: query: explain select day(t) from extract_udf PREHOOK: type: QUERY +PREHOOK: Input: default@extract_udf +#### A masked pattern was here #### POSTHOOK: query: explain select day(t) from extract_udf POSTHOOK: type: QUERY +POSTHOOK: Input: default@extract_udf +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -76,10 +80,14 @@ PREHOOK: query: explain select extract(day from t) from extract_udf PREHOOK: type: QUERY +PREHOOK: Input: default@extract_udf +#### A masked pattern was here #### POSTHOOK: query: explain select extract(day from t) from extract_udf POSTHOOK: type: QUERY +POSTHOOK: Input: default@extract_udf +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out b/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out index 3569eb5..d8c24af 100644 --- a/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out +++ b/ql/src/test/results/clientpositive/extrapolate_part_stats_date.q.out @@ -57,8 +57,14 @@ POSTHOOK: Output: default@date_dim_n1@d_date_sk=2416947 #### A masked pattern was here #### PREHOOK: query: explain select count(*) from date_dim_n1 where d_date > date "1900-01-02" and d_date_sk= 2416945 PREHOOK: type: QUERY +PREHOOK: Input: default@date_dim_n1 +PREHOOK: Input: default@date_dim_n1@d_date_sk=2416945 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from date_dim_n1 where d_date > date "1900-01-02" and d_date_sk= 2416945 POSTHOOK: type: QUERY +POSTHOOK: Input: default@date_dim_n1 +POSTHOOK: Input: default@date_dim_n1@d_date_sk=2416945 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -117,8 +123,20 @@ POSTHOOK: Output: default@date_dim_n1@d_date_sk=2416948 POSTHOOK: Lineage: date_dim_n1 PARTITION(d_date_sk=2416948).d_date SCRIPT [] PREHOOK: query: explain extended select d_date from date_dim_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@date_dim_n1 +PREHOOK: Input: default@date_dim_n1@d_date_sk=2416945 +PREHOOK: Input: default@date_dim_n1@d_date_sk=2416946 +PREHOOK: Input: default@date_dim_n1@d_date_sk=2416947 +PREHOOK: Input: default@date_dim_n1@d_date_sk=2416948 +#### A masked pattern was here #### POSTHOOK: query: explain extended select d_date from date_dim_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@date_dim_n1 +POSTHOOK: Input: default@date_dim_n1@d_date_sk=2416945 +POSTHOOK: Input: default@date_dim_n1@d_date_sk=2416946 +POSTHOOK: Input: default@date_dim_n1@d_date_sk=2416947 +POSTHOOK: Input: default@date_dim_n1@d_date_sk=2416948 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `d_date` FROM `default`.`date_dim_n1` STAGE DEPENDENCIES: http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out b/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out index c4cd90c..111660a 100644 --- a/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out +++ b/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out @@ -103,8 +103,16 @@ bitVector HL comment from deserializer PREHOOK: query: explain extended select state from loc_orc_1d PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_1d +PREHOOK: Input: default@loc_orc_1d@year=2000 +PREHOOK: Input: default@loc_orc_1d@year=2001 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state from loc_orc_1d POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_1d +POSTHOOK: Input: default@loc_orc_1d@year=2000 +POSTHOOK: Input: default@loc_orc_1d@year=2001 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state` FROM `default`.`loc_orc_1d` STAGE DEPENDENCIES: @@ -220,8 +228,16 @@ STAGE PLANS: PREHOOK: query: explain extended select state,locid from loc_orc_1d PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_1d +PREHOOK: Input: default@loc_orc_1d@year=2000 +PREHOOK: Input: default@loc_orc_1d@year=2001 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state,locid from loc_orc_1d POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_1d +POSTHOOK: Input: default@loc_orc_1d@year=2000 +POSTHOOK: Input: default@loc_orc_1d@year=2001 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state`, `locid` FROM `default`.`loc_orc_1d` STAGE DEPENDENCIES: @@ -426,8 +442,20 @@ POSTHOOK: Output: default@loc_orc_2d@zip=94087/year=2001 #### A masked pattern was here #### PREHOOK: query: explain extended select state from loc_orc_2d PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_2d +PREHOOK: Input: default@loc_orc_2d@zip=94086/year=2000 +PREHOOK: Input: default@loc_orc_2d@zip=94086/year=2001 +PREHOOK: Input: default@loc_orc_2d@zip=94087/year=2000 +PREHOOK: Input: default@loc_orc_2d@zip=94087/year=2001 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state from loc_orc_2d POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_2d +POSTHOOK: Input: default@loc_orc_2d@zip=94086/year=2000 +POSTHOOK: Input: default@loc_orc_2d@zip=94086/year=2001 +POSTHOOK: Input: default@loc_orc_2d@zip=94087/year=2000 +POSTHOOK: Input: default@loc_orc_2d@zip=94087/year=2001 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state` FROM `default`.`loc_orc_2d` STAGE DEPENDENCIES: @@ -639,8 +667,20 @@ STAGE PLANS: PREHOOK: query: explain extended select state,locid from loc_orc_2d PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_2d +PREHOOK: Input: default@loc_orc_2d@zip=94086/year=2000 +PREHOOK: Input: default@loc_orc_2d@zip=94086/year=2001 +PREHOOK: Input: default@loc_orc_2d@zip=94087/year=2000 +PREHOOK: Input: default@loc_orc_2d@zip=94087/year=2001 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state,locid from loc_orc_2d POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_2d +POSTHOOK: Input: default@loc_orc_2d@zip=94086/year=2000 +POSTHOOK: Input: default@loc_orc_2d@zip=94086/year=2001 +POSTHOOK: Input: default@loc_orc_2d@zip=94087/year=2000 +POSTHOOK: Input: default@loc_orc_2d@zip=94087/year=2001 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state`, `locid` FROM `default`.`loc_orc_2d` STAGE DEPENDENCIES: http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out b/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out index 3e7d0f4..ad67fb8 100644 --- a/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out +++ b/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out @@ -129,8 +129,20 @@ bitVector HL comment from deserializer PREHOOK: query: explain extended select state from loc_orc_1d_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_1d_n1 +PREHOOK: Input: default@loc_orc_1d_n1@year=2000 +PREHOOK: Input: default@loc_orc_1d_n1@year=2001 +PREHOOK: Input: default@loc_orc_1d_n1@year=2002 +PREHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state from loc_orc_1d_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_1d_n1 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2000 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2001 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2002 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state` FROM `default`.`loc_orc_1d_n1` STAGE DEPENDENCIES: @@ -338,8 +350,20 @@ STAGE PLANS: PREHOOK: query: explain extended select state,locid from loc_orc_1d_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_1d_n1 +PREHOOK: Input: default@loc_orc_1d_n1@year=2000 +PREHOOK: Input: default@loc_orc_1d_n1@year=2001 +PREHOOK: Input: default@loc_orc_1d_n1@year=2002 +PREHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state,locid from loc_orc_1d_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_1d_n1 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2000 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2001 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2002 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state`, `locid` FROM `default`.`loc_orc_1d_n1` STAGE DEPENDENCIES: @@ -575,8 +599,20 @@ POSTHOOK: Output: default@loc_orc_1d_n1@year=2003 #### A masked pattern was here #### PREHOOK: query: explain extended select state from loc_orc_1d_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_1d_n1 +PREHOOK: Input: default@loc_orc_1d_n1@year=2000 +PREHOOK: Input: default@loc_orc_1d_n1@year=2001 +PREHOOK: Input: default@loc_orc_1d_n1@year=2002 +PREHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state from loc_orc_1d_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_1d_n1 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2000 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2001 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2002 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state` FROM `default`.`loc_orc_1d_n1` STAGE DEPENDENCIES: @@ -784,8 +820,20 @@ STAGE PLANS: PREHOOK: query: explain extended select state,locid from loc_orc_1d_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_1d_n1 +PREHOOK: Input: default@loc_orc_1d_n1@year=2000 +PREHOOK: Input: default@loc_orc_1d_n1@year=2001 +PREHOOK: Input: default@loc_orc_1d_n1@year=2002 +PREHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state,locid from loc_orc_1d_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_1d_n1 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2000 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2001 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2002 +POSTHOOK: Input: default@loc_orc_1d_n1@year=2003 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state`, `locid` FROM `default`.`loc_orc_1d_n1` STAGE DEPENDENCIES: @@ -1075,8 +1123,34 @@ POSTHOOK: Output: default@loc_orc_2d_n1@zip=94087/year=2002 #### A masked pattern was here #### PREHOOK: query: explain extended select state from loc_orc_2d_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_2d_n1 +PREHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2001 +PREHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2002 +PREHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2003 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2000 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2001 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2002 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2003 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2000 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2001 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2002 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2003 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state from loc_orc_2d_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_2d_n1 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2001 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2002 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2003 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2000 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2001 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2002 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2003 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2000 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2001 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2002 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2003 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state` FROM `default`.`loc_orc_2d_n1` STAGE DEPENDENCIES: @@ -1617,8 +1691,34 @@ STAGE PLANS: PREHOOK: query: explain extended select state,locid from loc_orc_2d_n1 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_2d_n1 +PREHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2001 +PREHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2002 +PREHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2003 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2000 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2001 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2002 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2003 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2000 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2001 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2002 +PREHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2003 +#### A masked pattern was here #### POSTHOOK: query: explain extended select state,locid from loc_orc_2d_n1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_2d_n1 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2001 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2002 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=43201/year=2003 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2000 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2001 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2002 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94086/year=2003 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2000 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2001 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2002 +POSTHOOK: Input: default@loc_orc_2d_n1@zip=94087/year=2003 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `state`, `locid` FROM `default`.`loc_orc_2d_n1` STAGE DEPENDENCIES: http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fetch_aggregation.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fetch_aggregation.q.out b/ql/src/test/results/clientpositive/fetch_aggregation.q.out index 801c6de..b30b0e4 100644 --- a/ql/src/test/results/clientpositive/fetch_aggregation.q.out +++ b/ql/src/test/results/clientpositive/fetch_aggregation.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select count(key),sum(key),avg(key),min(key),max(key),std(key),variance(key) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(key),sum(key),avg(key),min(key),max(key),std(key),variance(key) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out b/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out index 73d36c8..8610fa0 100644 --- a/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out +++ b/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out @@ -3,11 +3,15 @@ CREATE TABLE dest1_n85(key INT, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat' PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@dest1_n85 POSTHOOK: query: EXPLAIN CREATE TABLE dest1_n85(key INT, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat' POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@dest1_n85 STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fileformat_text.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fileformat_text.q.out b/ql/src/test/results/clientpositive/fileformat_text.q.out index 13704ca..387f807 100644 --- a/ql/src/test/results/clientpositive/fileformat_text.q.out +++ b/ql/src/test/results/clientpositive/fileformat_text.q.out @@ -3,11 +3,15 @@ CREATE TABLE dest1_n107(key INT, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@dest1_n107 POSTHOOK: query: EXPLAIN CREATE TABLE dest1_n107(key INT, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@dest1_n107 STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_aggr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_aggr.q.out b/ql/src/test/results/clientpositive/filter_aggr.q.out index 0b42dca..33c5a4b 100644 --- a/ql/src/test/results/clientpositive/filter_aggr.q.out +++ b/ql/src/test/results/clientpositive/filter_aggr.q.out @@ -7,6 +7,8 @@ select key, c, 2 as m from (select key, count(key) as c from src group by key)s2 )sub where m = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain extended select key, c, m from ( @@ -16,6 +18,8 @@ select key, c, 2 as m from (select key, count(key) as c from src group by key)s2 )sub where m = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, COUNT(`key`) AS `c`, 1 AS `m` FROM `default`.`src` GROUP BY `key` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out b/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out index 19b506b..086c291 100644 --- a/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out +++ b/ql/src/test/results/clientpositive/filter_cond_pushdown.q.out @@ -3,11 +3,15 @@ SELECT f.key, g.value FROM src f JOIN src m JOIN src g ON(g.value = m.value AND m.value is not null AND m.value !='') WHERE (f.key = m.key AND f.value='2008-04-08' AND m.value='2008-04-08') OR (f.key = m.key AND f.value='2008-04-09') PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT f.key, g.value FROM src f JOIN src m JOIN src g ON(g.value = m.value AND m.value is not null AND m.value !='') WHERE (f.key = m.key AND f.value='2008-04-08' AND m.value='2008-04-08') OR (f.key = m.key AND f.value='2008-04-09') POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -128,11 +132,15 @@ SELECT f.key, g.value FROM src f JOIN src m JOIN src g ON(g.value = m.value AND m.value is not null AND m.value !='') WHERE (f.key = m.key AND f.value IN ('2008-04-08','2008-04-10') AND m.value='2008-04-08') OR (f.key = m.key AND f.value='2008-04-09') PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT f.key, g.value FROM src f JOIN src m JOIN src g ON(g.value = m.value AND m.value is not null AND m.value !='') WHERE (f.key = m.key AND f.value IN ('2008-04-08','2008-04-10') AND m.value='2008-04-08') OR (f.key = m.key AND f.value='2008-04-09') POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -258,6 +266,12 @@ JOIN ( WHERE ((t2.key=t3.key) AND (t2.c_float + t3.c_float > 2)) OR ((t2.key=t3.key) AND (t2.c_int + t3.c_int > 2))) t4 ON t1.key=t4.key 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@cbo_t3 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT t1.key FROM cbo_t1 t1 @@ -268,6 +282,12 @@ JOIN ( WHERE ((t2.key=t3.key) AND (t2.c_float + t3.c_float > 2)) OR ((t2.key=t3.key) AND (t2.c_int + t3.c_int > 2))) t4 ON t1.key=t4.key 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@cbo_t3 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-2 is a root stage Stage-1 depends on stages: Stage-2 @@ -387,11 +407,15 @@ SELECT f.key, f.value, m.value FROM src f JOIN src m ON(f.key = m.key AND m.value is not null AND m.value !='') WHERE (f.value IN ('2008-04-08','2008-04-10') AND f.value IN ('2008-04-08','2008-04-09') AND m.value='2008-04-10') OR (m.value='2008-04-08') PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT f.key, f.value, m.value FROM src f JOIN src m ON(f.key = m.key AND m.value is not null AND m.value !='') WHERE (f.value IN ('2008-04-08','2008-04-10') AND f.value IN ('2008-04-08','2008-04-09') AND m.value='2008-04-10') OR (m.value='2008-04-08') POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out b/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out index 39ddaac..d1191a6 100644 --- a/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out +++ b/ql/src/test/results/clientpositive/filter_cond_pushdown2.q.out @@ -65,6 +65,8 @@ and all_exposed_users.field_2 = interacted.field_2 group by all_exposed_users.field_1 order by all_exposed_users.field_1 PREHOOK: type: QUERY +PREHOOK: Input: default@users_table +#### A masked pattern was here #### POSTHOOK: query: explain with all_hits as ( select * from users_table @@ -94,6 +96,8 @@ and all_exposed_users.field_2 = interacted.field_2 group by all_exposed_users.field_1 order by all_exposed_users.field_1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@users_table +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1, Stage-5 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out b/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out index db4aee7..bc023a6 100644 --- a/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out +++ b/ql/src/test/results/clientpositive/filter_cond_pushdown_HIVE_15647.q.out @@ -19,11 +19,17 @@ sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar)) and ((sales.store_number) <=> (sales.customer_id)) PREHOOK: type: QUERY +PREHOOK: Input: default@sales_hive_15647 +PREHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar)) and ((sales.store_number) <=> (sales.customer_id)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@sales_hive_15647 +POSTHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -111,11 +117,17 @@ sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar)) and ((sales.store_number) = (sales.customer_id)) PREHOOK: type: QUERY +PREHOOK: Input: default@sales_hive_15647 +PREHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar)) and ((sales.store_number) = (sales.customer_id)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@sales_hive_15647 +POSTHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -203,11 +215,17 @@ sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar = true)) and ((sales.store_number) <=> (sales.customer_id)) PREHOOK: type: QUERY +PREHOOK: Input: default@sales_hive_15647 +PREHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar = true)) and ((sales.store_number) <=> (sales.customer_id)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@sales_hive_15647 +POSTHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -295,11 +313,17 @@ sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar = false)) and ((sales.store_number) > (sales.customer_id)) PREHOOK: type: QUERY +PREHOOK: Input: default@sales_hive_15647 +PREHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from sales_HIVE_15647 as sales join store_HIVE_15647 as store on sales.store_id = store.store_id where ((store.salad_bar = false)) and ((sales.store_number) > (sales.customer_id)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@sales_hive_15647 +POSTHOOK: Input: default@store_hive_15647 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_in_or_dup.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_in_or_dup.q.out b/ql/src/test/results/clientpositive/filter_in_or_dup.q.out index f96298c..c0aa840 100644 --- a/ql/src/test/results/clientpositive/filter_in_or_dup.q.out +++ b/ql/src/test/results/clientpositive/filter_in_or_dup.q.out @@ -4,12 +4,18 @@ FROM cbo_t1 f WHERE (f.key = '1' OR f.key='2') AND f.key IN ('1', '2') PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT f.key FROM cbo_t1 f WHERE (f.key = '1' OR f.key='2') AND f.key IN ('1', '2') POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -50,12 +56,18 @@ FROM cbo_t1 f WHERE (f.key = '1' OR f.key = '2') AND f.key IN ('1', '2', '3') PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT f.key FROM cbo_t1 f WHERE (f.key = '1' OR f.key = '2') AND f.key IN ('1', '2', '3') POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -96,12 +108,18 @@ FROM cbo_t1 f WHERE (f.key = '1' OR f.key='2' OR f.key='3') AND f.key IN ('1', '2') PREHOOK: type: QUERY +PREHOOK: Input: default@cbo_t1 +PREHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT f.key FROM cbo_t1 f WHERE (f.key = '1' OR f.key='2' OR f.key='3') AND f.key IN ('1', '2') POSTHOOK: type: QUERY +POSTHOOK: Input: default@cbo_t1 +POSTHOOK: Input: default@cbo_t1@dt=2014 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_join_breaktask.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_join_breaktask.q.out b/ql/src/test/results/clientpositive/filter_join_breaktask.q.out index 07843d0..849ca3f 100644 --- a/ql/src/test/results/clientpositive/filter_join_breaktask.q.out +++ b/ql/src/test/results/clientpositive/filter_join_breaktask.q.out @@ -23,11 +23,17 @@ SELECT f.key, g.value FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null) JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='') PREHOOK: type: QUERY +PREHOOK: Input: default@filter_join_breaktask +PREHOOK: Input: default@filter_join_breaktask@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED SELECT f.key, g.value FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null) JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='') POSTHOOK: type: QUERY +POSTHOOK: Input: default@filter_join_breaktask +POSTHOOK: Input: default@filter_join_breaktask@ds=2008-04-08 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `t2`.`key`, `t0`.`value` FROM (SELECT `value`, CAST('2008-04-08' AS STRING) AS `ds` FROM `default`.`filter_join_breaktask` http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_numeric.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_numeric.q.out b/ql/src/test/results/clientpositive/filter_numeric.q.out index 6c7cc50..ca5c67a 100644 --- a/ql/src/test/results/clientpositive/filter_numeric.q.out +++ b/ql/src/test/results/clientpositive/filter_numeric.q.out @@ -26,8 +26,12 @@ POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart 1B2M2Y8AsgTpgAmY7PhCfg== PREHOOK: query: explain select key, value, hr from partint where hr < 11 PREHOOK: type: QUERY +PREHOOK: Input: default@partint +#### A masked pattern was here #### POSTHOOK: query: explain select key, value, hr from partint where hr < 11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partint +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -60,8 +64,14 @@ POSTHOOK: Input: default@partint 1B2M2Y8AsgTpgAmY7PhCfg== PREHOOK: query: explain select key, value, hr from partint where hr <= 12 and hr > 11 PREHOOK: type: QUERY +PREHOOK: Input: default@partint +PREHOOK: Input: default@partint@ds=2008-04-08/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key, value, hr from partint where hr <= 12 and hr > 11 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partint +POSTHOOK: Input: default@partint@ds=2008-04-08/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -593,8 +603,16 @@ POSTHOOK: Input: default@partint@ds=2008-04-08/hr=12 XrhdsR2p43qW9hpMcP/9nw== PREHOOK: query: explain select key, value, hr from partint where hr between 11 and 12 PREHOOK: type: QUERY +PREHOOK: Input: default@partint +PREHOOK: Input: default@partint@ds=2008-04-08/hr=11 +PREHOOK: Input: default@partint@ds=2008-04-08/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key, value, hr from partint where hr between 11 and 12 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partint +POSTHOOK: Input: default@partint@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@partint@ds=2008-04-08/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -1628,8 +1646,14 @@ POSTHOOK: Input: default@partint@ds=2008-04-08/hr=12 irG2+wNa4ZWkUKb0+hXweg== PREHOOK: query: explain select key, value, hr from partint where hr not between 12 and 14 PREHOOK: type: QUERY +PREHOOK: Input: default@partint +PREHOOK: Input: default@partint@ds=2008-04-08/hr=11 +#### A masked pattern was here #### POSTHOOK: query: explain select key, value, hr from partint where hr not between 12 and 14 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partint +POSTHOOK: Input: default@partint@ds=2008-04-08/hr=11 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -2161,8 +2185,16 @@ POSTHOOK: Input: default@partint@ds=2008-04-08/hr=11 v6vY2XVDyLw+4d5w+xCycg== PREHOOK: query: explain select key, value, hr from partint where hr < 13 PREHOOK: type: QUERY +PREHOOK: Input: default@partint +PREHOOK: Input: default@partint@ds=2008-04-08/hr=11 +PREHOOK: Input: default@partint@ds=2008-04-08/hr=12 +#### A masked pattern was here #### POSTHOOK: query: explain select key, value, hr from partint where hr < 13 POSTHOOK: type: QUERY +POSTHOOK: Input: default@partint +POSTHOOK: Input: default@partint@ds=2008-04-08/hr=11 +POSTHOOK: Input: default@partint@ds=2008-04-08/hr=12 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/filter_union.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/filter_union.q.out b/ql/src/test/results/clientpositive/filter_union.q.out index a7cd8c1..394a0b9 100644 --- a/ql/src/test/results/clientpositive/filter_union.q.out +++ b/ql/src/test/results/clientpositive/filter_union.q.out @@ -11,6 +11,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m >2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain extended select key, c, m from ( @@ -24,6 +26,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m >2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, COUNT(`key`) AS `c`, 3 AS `m` FROM `default`.`src` GROUP BY `key` @@ -384,6 +388,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, c, m from ( @@ -397,6 +403,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -463,6 +471,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m = 4 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, c, m from ( @@ -476,6 +486,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m = 4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -542,6 +554,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m = 5 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key, c, m from ( @@ -555,6 +569,8 @@ select key, c, 4 as m from (select key, count(key) as c from src group by key)s4 )sub where m = 5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/flatten_and_or.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/flatten_and_or.q.out b/ql/src/test/results/clientpositive/flatten_and_or.q.out index 04b4a1d..4b72daa 100644 --- a/ql/src/test/results/clientpositive/flatten_and_or.q.out +++ b/ql/src/test/results/clientpositive/flatten_and_or.q.out @@ -15,6 +15,8 @@ WHERE AND value = '1') OR (key = '10' AND value = '3')) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain SELECT key FROM src @@ -32,6 +34,8 @@ WHERE AND value = '1') OR (key = '10' AND value = '3')) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/floor_time.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/floor_time.q.out b/ql/src/test/results/clientpositive/floor_time.q.out index e4ae666..907c377 100644 --- a/ql/src/test/results/clientpositive/floor_time.q.out +++ b/ql/src/test/results/clientpositive/floor_time.q.out @@ -38,10 +38,14 @@ PREHOOK: query: explain select floor_day(t) from extract_udf_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@extract_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select floor_day(t) from extract_udf_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@extract_udf_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -87,10 +91,14 @@ PREHOOK: query: explain select floor(t to day) from extract_udf_n0 PREHOOK: type: QUERY +PREHOOK: Input: default@extract_udf_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select floor(t to day) from extract_udf_n0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@extract_udf_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fm-sketch.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fm-sketch.q.out b/ql/src/test/results/clientpositive/fm-sketch.q.out index f6f248d..e9184dd 100644 --- a/ql/src/test/results/clientpositive/fm-sketch.q.out +++ b/ql/src/test/results/clientpositive/fm-sketch.q.out @@ -17,8 +17,14 @@ POSTHOOK: Output: default@n_n0 POSTHOOK: Lineage: n_n0.key EXPRESSION [] PREHOOK: query: explain analyze table n_n0 compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@n_n0 +PREHOOK: Output: default@n_n0 +#### A masked pattern was here #### POSTHOOK: query: explain analyze table n_n0 compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@n_n0 +POSTHOOK: Output: default@n_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 depends on stages: Stage-0 @@ -113,8 +119,14 @@ POSTHOOK: Output: default@i_n1 POSTHOOK: Lineage: i_n1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] PREHOOK: query: explain analyze table i_n1 compute statistics for columns PREHOOK: type: ANALYZE_TABLE +PREHOOK: Input: default@i_n1 +PREHOOK: Output: default@i_n1 +#### A masked pattern was here #### POSTHOOK: query: explain analyze table i_n1 compute statistics for columns POSTHOOK: type: ANALYZE_TABLE +POSTHOOK: Input: default@i_n1 +POSTHOOK: Output: default@i_n1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 depends on stages: Stage-0 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fold_case.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fold_case.q.out b/ql/src/test/results/clientpositive/fold_case.q.out index 438829b..408275d 100644 --- a/ql/src/test/results/clientpositive/fold_case.q.out +++ b/ql/src/test/results/clientpositive/fold_case.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select count(1) from src where (case key when '238' then true else false end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then true else false end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -54,9 +58,13 @@ STAGE PLANS: PREHOOK: query: explain select count(1) from src where (case key when '238' then 1=2 else 1=1 end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then 1=2 else 1=1 end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -107,9 +115,13 @@ STAGE PLANS: PREHOOK: query: explain select count(1) from src where (case key when '238' then 1=2 else 1=31 end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then 1=2 else 1=31 end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -159,9 +171,13 @@ STAGE PLANS: PREHOOK: query: explain select count(1) from src where (case key when '238' then true else 1=1 end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then true else 1=1 end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -175,9 +191,13 @@ STAGE PLANS: PREHOOK: query: explain select count(1) from src where (case key when '238' then 1=1 else 1=null end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then 1=1 else 1=null end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -228,9 +248,13 @@ STAGE PLANS: PREHOOK: query: explain select count(1) from src where (case key when '238' then 1=null end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then 1=null end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -280,9 +304,13 @@ STAGE PLANS: PREHOOK: query: explain select count(1) from src where (case key when '238' then 2 = cast('2' as bigint) end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then 2 = cast('2' as bigint) end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -333,9 +361,13 @@ STAGE PLANS: PREHOOK: query: explain select (case key when '238' then null else false end) from src where (case key when '238' then 2 = cast('1' as bigint) else true end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select (case key when '238' then null else false end) from src where (case key when '238' then 2 = cast('1' as bigint) else true end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -373,9 +405,13 @@ STAGE PLANS: PREHOOK: query: explain select (case key when '238' then null else null end) from src where (case key when '238' then 2 = null else 3 = null end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select (case key when '238' then null else null end) from src where (case key when '238' then 2 = null else 3 = null end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -414,9 +450,13 @@ STAGE PLANS: PREHOOK: query: explain select count(1) from src where (case key when '238' then null else 1=1 end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select count(1) from src where (case key when '238' then null else 1=1 end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -468,10 +508,14 @@ PREHOOK: query: explain select (CASE WHEN (-2) >= 0 THEN SUBSTRING(key, 1,CAST((-2) AS INT)) ELSE NULL END) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select (CASE WHEN (-2) >= 0 THEN SUBSTRING(key, 1,CAST((-2) AS INT)) ELSE NULL END) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -493,10 +537,14 @@ PREHOOK: query: explain select (CASE WHEN key = value THEN '1' WHEN true THEN '0' ELSE NULL END) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select (CASE WHEN key = value THEN '1' WHEN true THEN '0' ELSE NULL END) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -530,9 +578,13 @@ STAGE PLANS: PREHOOK: query: explain select (case when true then key when not true then to_date(key) else null end) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select (case when true then key when not true then to_date(key) else null end) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out b/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out index 0e1f2c6..25825b8 100644 --- a/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out +++ b/ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out @@ -14,6 +14,8 @@ WHERE ((CASE WHEN (1 = l_linenumber) THEN 1 ELSE 1 END) = 1) AND (1 = 1)) GROUP BY l_orderkey PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain SELECT SUM((CASE WHEN 1000000 = 0 THEN NULL ELSE l_partkey / 1000000 END)), @@ -30,6 +32,8 @@ WHERE ((CASE WHEN (1 = l_linenumber) THEN 1 ELSE 1 END) = 1) AND (1 = 1)) GROUP BY l_orderkey POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -89,8 +93,12 @@ STAGE PLANS: PREHOOK: query: explain select key from src where (case key when '238' then 1 else 2 end) = 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where (case key when '238' then 1 else 2 end) = 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -127,8 +135,12 @@ STAGE PLANS: PREHOOK: query: explain select key from src where (case key when '238' then 1 when '94' then 1 else 3 end) = cast('1' as int) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where (case key when '238' then 1 when '94' then 1 else 3 end) = cast('1' as int) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -165,8 +177,12 @@ STAGE PLANS: PREHOOK: query: explain select key from src where (case key when '238' then 1 else 2 end) = (case when key != '238' then 1 else 1 end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where (case key when '238' then 1 else 2 end) = (case when key != '238' then 1 else 1 end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -203,8 +219,12 @@ STAGE PLANS: PREHOOK: query: explain select key from src where (case key when '238' then 1 end) = (case when key != '238' then 1 when key = '23' then 1 end) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where (case key when '238' then 1 end) = (case when key != '238' then 1 when key = '23' then 1 end) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fold_when.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fold_when.q.out b/ql/src/test/results/clientpositive/fold_when.q.out index dfc49ef..6f3a479 100644 --- a/ql/src/test/results/clientpositive/fold_when.q.out +++ b/ql/src/test/results/clientpositive/fold_when.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select key from src where ((case when (key = '238') then null end) = 1) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then null end) = 1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -40,9 +44,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then null else null end) = 1) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then null else null end) = 1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -79,9 +87,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1 else 1 end) = 1) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1 else 1 end) = 1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -102,9 +114,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1 else 1 end) = 2) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1 else 1 end) = 2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -141,9 +157,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1 else null end) = 1) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1 else null end) = 1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -181,9 +201,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1=1 else null=1 end)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1=1 else null=1 end)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -221,9 +245,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1=1 else 2=2 end)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1=1 else 2=2 end)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -244,9 +272,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1=3 else 2=1 end)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1=3 else 2=1 end)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -283,9 +315,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1=1 else 2=1 end)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1=1 else 2=1 end)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -323,9 +359,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = '238') then 1=3 else 1=1 end)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = '238') then 1=3 else 1=1 end)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -363,9 +403,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when ('23' = '23') then 1 else 1 end) = 1) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when ('23' = '23') then 1 else 1 end) = 1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -386,9 +430,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when ('2' = '238') then 1 else 2 end) = 2) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when ('2' = '238') then 1 else 2 end) = 2) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -409,9 +457,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (true=null) then 1 else 1 end) = 1) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (true=null) then 1 else 1 end) = 1) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -432,9 +484,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = (case when (key = '238') then '11' else '11' end)) then false else true end)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = (case when (key = '238') then '11' else '11' end)) then false else true end)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -472,9 +528,13 @@ STAGE PLANS: PREHOOK: query: explain select key from src where ((case when (key = (case when (key = '238') then '12' else '11' end)) then 2=2 else true end)) PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from src where ((case when (key = (case when (key = '238') then '12' else '11' end)) then 2=2 else true end)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/folder_predicate.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/folder_predicate.q.out b/ql/src/test/results/clientpositive/folder_predicate.q.out index 64d2693..d8144ca 100644 --- a/ql/src/test/results/clientpositive/folder_predicate.q.out +++ b/ql/src/test/results/clientpositive/folder_predicate.q.out @@ -22,9 +22,13 @@ POSTHOOK: Lineage: predicate_fold_tb.value SCRIPT [] PREHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value = 3) PREHOOK: type: QUERY +PREHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value = 3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -75,9 +79,13 @@ NULL PREHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value >= 3) PREHOOK: type: QUERY +PREHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value >= 3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -126,9 +134,13 @@ NULL PREHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value <= 3) PREHOOK: type: QUERY +PREHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value <= 3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -177,9 +189,13 @@ NULL PREHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value > 3) PREHOOK: type: QUERY +PREHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value > 3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -229,9 +245,13 @@ NULL PREHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value < 3) PREHOOK: type: QUERY +PREHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value < 3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -281,9 +301,13 @@ NULL PREHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value <> 3) PREHOOK: type: QUERY +PREHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value <> 3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -331,9 +355,13 @@ NULL PREHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value > 1 AND value <=3) PREHOOK: type: QUERY +PREHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### POSTHOOK: query: explain SELECT * FROM predicate_fold_tb WHERE not(value IS NOT NULL AND value > 1 AND value <=3) POSTHOOK: type: QUERY +POSTHOOK: Input: default@predicate_fold_tb +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/foldts.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/foldts.q.out b/ql/src/test/results/clientpositive/foldts.q.out index 83a6481..9a68fe0 100644 --- a/ql/src/test/results/clientpositive/foldts.q.out +++ b/ql/src/test/results/clientpositive/foldts.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select ctimestamp1, unix_timestamp(ctimestamp1), to_unix_timestamp(ctimestamp1) from alltypesorc limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select ctimestamp1, unix_timestamp(ctimestamp1), to_unix_timestamp(ctimestamp1) from alltypesorc limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -59,9 +63,13 @@ POSTHOOK: Output: default@src1orc PREHOOK: query: explain select from_unixtime(to_unix_timestamp(ctimestamp1), 'EEEE') from alltypesorc limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select from_unixtime(to_unix_timestamp(ctimestamp1), 'EEEE') from alltypesorc limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -107,9 +115,13 @@ Wednesday PREHOOK: query: explain select from_unixtime(unix_timestamp(ctimestamp1), 'EEEE') from alltypesorc limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@alltypesorc +#### A masked pattern was here #### POSTHOOK: query: explain select from_unixtime(unix_timestamp(ctimestamp1), 'EEEE') from alltypesorc limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alltypesorc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 http://git-wip-us.apache.org/repos/asf/hive/blob/163caed7/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out b/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out index a6be904..cc076f6 100644 --- a/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out +++ b/ql/src/test/results/clientpositive/fp_literal_arithmetic.q.out @@ -2,10 +2,14 @@ PREHOOK: query: explain select sum(l_extendedprice) from lineitem q0 where l_discount between cast('0.05' as decimal(3,2)) and cast('0.07' as decimal(3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain select sum(l_extendedprice) from lineitem q0 where l_discount between cast('0.05' as decimal(3,2)) and cast('0.07' as decimal(3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -70,10 +74,14 @@ PREHOOK: query: explain select sum(l_extendedprice) from lineitem q1 where l_discount between 0.06 - 0.01 and 0.06 + 0.01 PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain select sum(l_extendedprice) from lineitem q1 where l_discount between 0.06 - 0.01 and 0.06 + 0.01 POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -175,10 +183,14 @@ PREHOOK: query: explain select sum(l_extendedprice) from lineitem q10 where l_discount between cast('0.05' as decimal(3,2)) and cast('0.07' as decimal(3,2)) PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain select sum(l_extendedprice) from lineitem q10 where l_discount between cast('0.05' as decimal(3,2)) and cast('0.07' as decimal(3,2)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -243,10 +255,14 @@ PREHOOK: query: explain select sum(l_extendedprice) from lineitem q11 where l_discount between 0.06 - 0.01 and 0.06 + 0.01 PREHOOK: type: QUERY +PREHOOK: Input: default@lineitem +#### A masked pattern was here #### POSTHOOK: query: explain select sum(l_extendedprice) from lineitem q11 where l_discount between 0.06 - 0.01 and 0.06 + 0.01 POSTHOOK: type: QUERY +POSTHOOK: Input: default@lineitem +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
