http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientnegative/spark/spark_stage_max_tasks.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/spark/spark_stage_max_tasks.q.out b/ql/src/test/results/clientnegative/spark/spark_stage_max_tasks.q.out index a3a264d..97780ff 100644 --- a/ql/src/test/results/clientnegative/spark/spark_stage_max_tasks.q.out +++ b/ql/src/test/results/clientnegative/spark/spark_stage_max_tasks.q.out @@ -2,10 +2,14 @@ PREHOOK: query: EXPLAIN SELECT TRANSFORM(key) USING 'python sleep.py' AS k FROM (SELECT key FROM src1 GROUP BY key) a ORDER BY k PREHOOK: type: QUERY +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT TRANSFORM(key) USING 'python sleep.py' AS k FROM (SELECT key FROM src1 GROUP BY key) a ORDER BY k POSTHOOK: type: QUERY +POSTHOOK: Input: default@src1 +#### 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/b356aae0/ql/src/test/results/clientnegative/udf_assert_true.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/udf_assert_true.q.out b/ql/src/test/results/clientnegative/udf_assert_true.q.out index 7fc50d6..81a385a 100644 --- a/ql/src/test/results/clientnegative/udf_assert_true.q.out +++ b/ql/src/test/results/clientnegative/udf_assert_true.q.out @@ -5,8 +5,12 @@ POSTHOOK: type: DESCFUNCTION ASSERT_TRUE(condition) - Throw an exception if 'condition' is not true. PREHOOK: query: EXPLAIN SELECT ASSERT_TRUE(x > 0) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT ASSERT_TRUE(x > 0) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 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 @@ -82,8 +86,12 @@ NULL NULL PREHOOK: query: EXPLAIN SELECT ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 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 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientnegative/udf_assert_true2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/udf_assert_true2.q.out b/ql/src/test/results/clientnegative/udf_assert_true2.q.out index f061a92..dca3f2d 100644 --- a/ql/src/test/results/clientnegative/udf_assert_true2.q.out +++ b/ql/src/test/results/clientnegative/udf_assert_true2.q.out @@ -1,7 +1,11 @@ PREHOOK: query: EXPLAIN SELECT 1 + ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN SELECT 1 + ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 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 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/acid_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/acid_mapjoin.q.out b/ql/src/test/results/clientpositive/acid_mapjoin.q.out index 5569a03..c07b8ef 100644 --- a/ql/src/test/results/clientpositive/acid_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/acid_mapjoin.q.out @@ -61,9 +61,15 @@ POSTHOOK: Output: default@acid1 PREHOOK: query: explain select count(*) from acid1 join acid2 on acid1.key = acid2.key PREHOOK: type: QUERY +PREHOOK: Input: default@acid1 +PREHOOK: Input: default@acid2 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from acid1 join acid2 on acid1.key = acid2.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid1 +POSTHOOK: Input: default@acid2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-5 is a root stage Stage-2 depends on stages: Stage-5 http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/acid_nullscan.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/acid_nullscan.q.out b/ql/src/test/results/clientpositive/acid_nullscan.q.out index f4cc694..2014c58 100644 --- a/ql/src/test/results/clientpositive/acid_nullscan.q.out +++ b/ql/src/test/results/clientpositive/acid_nullscan.q.out @@ -29,9 +29,13 @@ POSTHOOK: Lineage: acid_vectorized_n1.b SCRIPT [] PREHOOK: query: explain extended select sum(a) from acid_vectorized_n1 where false PREHOOK: type: QUERY +PREHOOK: Input: default@acid_vectorized_n1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select sum(a) from acid_vectorized_n1 where false POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_vectorized_n1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT SUM(`a`) AS `$f0` FROM `default`.`acid_vectorized_n1` WHERE FALSE http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/acid_table_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/acid_table_stats.q.out b/ql/src/test/results/clientpositive/acid_table_stats.q.out index 9a9617a..222a50a 100644 --- a/ql/src/test/results/clientpositive/acid_table_stats.q.out +++ b/ql/src/test/results/clientpositive/acid_table_stats.q.out @@ -122,8 +122,14 @@ POSTHOOK: Input: default@acid@ds=2008-04-08 1000 PREHOOK: query: explain select count(*) from acid where ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid +PREHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from acid where ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid +POSTHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -289,8 +295,14 @@ POSTHOOK: Input: default@acid@ds=2008-04-08 1000 PREHOOK: query: explain select count(*) from acid where ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid +PREHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from acid where ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid +POSTHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -451,8 +463,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select count(*) from acid where ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid +PREHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from acid where ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid +POSTHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -523,8 +541,14 @@ POSTHOOK: Output: default@acid@ds=2008-04-08 #### A masked pattern was here #### PREHOOK: query: explain select max(key) from acid where ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid +PREHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain select max(key) from acid where ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid +POSTHOOK: Input: default@acid@ds=2008-04-08 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -710,8 +734,12 @@ POSTHOOK: Input: default@acid@ds=2008-04-09 2000 PREHOOK: query: explain select count(*) from acid where ds='2008-04-08' PREHOOK: type: QUERY +PREHOOK: Input: default@acid +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from acid where ds='2008-04-08' POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/add_part_multiple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/add_part_multiple.q.out b/ql/src/test/results/clientpositive/add_part_multiple.q.out index 5c9282d..7631c4d 100644 --- a/ql/src/test/results/clientpositive/add_part_multiple.q.out +++ b/ql/src/test/results/clientpositive/add_part_multiple.q.out @@ -13,6 +13,8 @@ PARTITION (ds='2010-02-01') location 'B' PARTITION (ds='2010-03-01') PARTITION (ds='2010-04-01') location 'C' PREHOOK: type: ALTERTABLE_ADDPARTS +#### A masked pattern was here #### +PREHOOK: Output: default@add_part_test_n1 POSTHOOK: query: explain ALTER TABLE add_part_test_n1 ADD IF NOT EXISTS PARTITION (ds='2010-01-01') location 'A' @@ -20,6 +22,8 @@ PARTITION (ds='2010-02-01') location 'B' PARTITION (ds='2010-03-01') PARTITION (ds='2010-04-01') location 'C' POSTHOOK: type: ALTERTABLE_ADDPARTS +#### A masked pattern was here #### +POSTHOOK: Output: default@add_part_test_n1 STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/alias_casted_column.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/alias_casted_column.q.out b/ql/src/test/results/clientpositive/alias_casted_column.q.out index c06173d..e5eeaa7 100644 --- a/ql/src/test/results/clientpositive/alias_casted_column.q.out +++ b/ql/src/test/results/clientpositive/alias_casted_column.q.out @@ -1,7 +1,11 @@ PREHOOK: query: explain select key from (select cast(key as int) from src )t PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key from (select cast(key as int) from src )t 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 @@ -34,8 +38,12 @@ STAGE PLANS: PREHOOK: query: explain select key2 from (select cast(key as int) key2 from src )t PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select key2 from (select cast(key as int) key2 from src )t 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/b356aae0/ql/src/test/results/clientpositive/allcolref_in_udf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/allcolref_in_udf.q.out b/ql/src/test/results/clientpositive/allcolref_in_udf.q.out index 000a782..47da4bf 100644 --- a/ql/src/test/results/clientpositive/allcolref_in_udf.q.out +++ b/ql/src/test/results/clientpositive/allcolref_in_udf.q.out @@ -1,9 +1,13 @@ PREHOOK: query: explain select concat(*),array(*) from src where key < 100 limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select concat(*),array(*) from src where key < 100 limit 10 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 @@ -63,11 +67,15 @@ select stack(2, *) as (e1,e2,e3) from ( select concat(*), concat(a.*), concat(b.*), concat(a.*, b.key), concat(a.key, b.*) from src a join src b on a.key+1=b.key where a.key < 100) x limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain select stack(2, *) as (e1,e2,e3) from ( select concat(*), concat(a.*), concat(b.*), concat(a.*, b.key), concat(a.key, b.*) from src a join src b on a.key+1=b.key where a.key < 100) x limit 10 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 @@ -180,8 +188,12 @@ POSTHOOK: Output: default@allcolref POSTHOOK: Lineage: allcolref._c0 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain select explode(*) as x from allcolref limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@allcolref +#### A masked pattern was here #### POSTHOOK: query: explain select explode(*) as x from allcolref limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@allcolref +#### 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/b356aae0/ql/src/test/results/clientpositive/alterColumnStatsPart.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/alterColumnStatsPart.q.out b/ql/src/test/results/clientpositive/alterColumnStatsPart.q.out index d5975e1..a887996 100644 --- a/ql/src/test/results/clientpositive/alterColumnStatsPart.q.out +++ b/ql/src/test/results/clientpositive/alterColumnStatsPart.q.out @@ -107,8 +107,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(a) from p where c=1 PREHOOK: type: QUERY +PREHOOK: Input: default@p +PREHOOK: Input: default@p@c=1 +#### A masked pattern was here #### POSTHOOK: query: explain select max(a) from p where c=1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@p +POSTHOOK: Input: default@p@c=1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -170,8 +176,12 @@ POSTHOOK: Output: default@p@c=1 #### A masked pattern was here #### PREHOOK: query: explain select max(a) from p where c=1 PREHOOK: type: QUERY +PREHOOK: Input: default@p +#### A masked pattern was here #### POSTHOOK: query: explain select max(a) from p where c=1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@p +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -241,8 +251,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(a) from p where c=4 PREHOOK: type: QUERY +PREHOOK: Input: default@p +PREHOOK: Input: default@p@c=4 +#### A masked pattern was here #### POSTHOOK: query: explain select max(a) from p where c=4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@p +POSTHOOK: Input: default@p@c=4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -334,8 +350,14 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select max(a) from p where c=100 PREHOOK: type: QUERY +PREHOOK: Input: default@p +PREHOOK: Input: default@p@c=100 +#### A masked pattern was here #### POSTHOOK: query: explain select max(a) from p where c=100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@p +POSTHOOK: Input: default@p@c=100 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -397,8 +419,14 @@ POSTHOOK: Output: default@p@c=100 #### A masked pattern was here #### PREHOOK: query: explain select max(a) from p where c=100 PREHOOK: type: QUERY +PREHOOK: Input: default@p +PREHOOK: Input: default@p@c=100 +#### A masked pattern was here #### POSTHOOK: query: explain select max(a) from p where c=100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@p +POSTHOOK: Input: default@p@c=100 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -507,8 +535,12 @@ POSTHOOK: Output: default@p@c=100 #### A masked pattern was here #### PREHOOK: query: explain select max(a) from p where c=100 PREHOOK: type: QUERY +PREHOOK: Input: default@p +#### A masked pattern was here #### POSTHOOK: query: explain select max(a) from p where c=100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@p +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/alter_partition_coltype.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/alter_partition_coltype.q.out b/ql/src/test/results/clientpositive/alter_partition_coltype.q.out index 205b2bc..4894269 100644 --- a/ql/src/test/results/clientpositive/alter_partition_coltype.q.out +++ b/ql/src/test/results/clientpositive/alter_partition_coltype.q.out @@ -68,8 +68,12 @@ POSTHOOK: Input: default@alter_coltype 50 PREHOOK: query: explain extended select count(*) from alter_coltype where dt = '100' PREHOOK: type: QUERY +PREHOOK: Input: default@alter_coltype +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) from alter_coltype where dt = '100' POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_coltype +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM `default`.`alter_coltype` WHERE `dt` = 100 @@ -118,8 +122,12 @@ POSTHOOK: Input: default@alter_coltype 25 PREHOOK: query: explain extended select count(*) from alter_coltype where ts = '6.30' PREHOOK: type: QUERY +PREHOOK: Input: default@alter_coltype +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) from alter_coltype where ts = '6.30' POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_coltype +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM `default`.`alter_coltype` WHERE `ts` = 6.3 @@ -144,8 +152,12 @@ POSTHOOK: Input: default@alter_coltype 25 PREHOOK: query: explain extended select count(*) from alter_coltype where ts = 3.0 and dt=100 PREHOOK: type: QUERY +PREHOOK: Input: default@alter_coltype +#### A masked pattern was here #### POSTHOOK: query: explain extended select count(*) from alter_coltype where ts = 3.0 and dt=100 POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_coltype +#### A masked pattern was here #### OPTIMIZED SQL: SELECT COUNT(*) AS `$f0` FROM `default`.`alter_coltype` WHERE `ts` = 3 AND `dt` = 100 @@ -223,8 +235,16 @@ POSTHOOK: Input: default@alter_coltype@dt=100/ts=6.30 100 6.3 PREHOOK: query: explain extended select key, value, dt, ts from alter_coltype where dt is not null PREHOOK: type: QUERY +PREHOOK: Input: default@alter_coltype +PREHOOK: Input: default@alter_coltype@dt=100/ts=3.0 +PREHOOK: Input: default@alter_coltype@dt=100/ts=6.30 +#### A masked pattern was here #### POSTHOOK: query: explain extended select key, value, dt, ts from alter_coltype where dt is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_coltype +POSTHOOK: Input: default@alter_coltype@dt=100/ts=3.0 +POSTHOOK: Input: default@alter_coltype@dt=100/ts=6.30 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `key`, `value`, `dt`, `ts` FROM `default`.`alter_coltype` WHERE `dt` IS NOT NULL @@ -462,8 +482,14 @@ POSTHOOK: Input: pt@alterdynamic_part_table POSTHOOK: Output: pt@alterdynamic_part_table PREHOOK: query: explain extended select intcol from pt.alterdynamic_part_table where partcol1='1' and partcol2='1' PREHOOK: type: QUERY +PREHOOK: Input: pt@alterdynamic_part_table +PREHOOK: Input: pt@alterdynamic_part_table@partcol1=1/partcol2=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select intcol from pt.alterdynamic_part_table where partcol1='1' and partcol2='1' POSTHOOK: type: QUERY +POSTHOOK: Input: pt@alterdynamic_part_table +POSTHOOK: Input: pt@alterdynamic_part_table@partcol1=1/partcol2=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `intcol` FROM `pt`.`alterdynamic_part_table` WHERE `partcol1` = 1 AND `partcol2` = '1' @@ -535,8 +561,14 @@ STAGE PLANS: PREHOOK: query: explain extended select intcol from pt.alterdynamic_part_table where (partcol1='2' and partcol2='1')or (partcol1='1' and partcol2='__HIVE_DEFAULT_PARTITION__') PREHOOK: type: QUERY +PREHOOK: Input: pt@alterdynamic_part_table +PREHOOK: Input: pt@alterdynamic_part_table@partcol1=2/partcol2=1 +#### A masked pattern was here #### POSTHOOK: query: explain extended select intcol from pt.alterdynamic_part_table where (partcol1='2' and partcol2='1')or (partcol1='1' and partcol2='__HIVE_DEFAULT_PARTITION__') POSTHOOK: type: QUERY +POSTHOOK: Input: pt@alterdynamic_part_table +POSTHOOK: Input: pt@alterdynamic_part_table@partcol1=2/partcol2=1 +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `intcol` FROM `pt`.`alterdynamic_part_table` WHERE `partcol1` = 2 AND `partcol2` = '1' OR `partcol1` = 1 AND `partcol2` = '__HIVE_DEFAULT_PARTITION__' http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/alter_rename_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/alter_rename_table.q.out b/ql/src/test/results/clientpositive/alter_rename_table.q.out index 732d8a2..16ba339 100644 --- a/ql/src/test/results/clientpositive/alter_rename_table.q.out +++ b/ql/src/test/results/clientpositive/alter_rename_table.q.out @@ -117,9 +117,13 @@ POSTHOOK: Input: source@srcpart@ds=2008-04-09/hr=12 PREHOOK: query: explain ALTER TABLE source.src RENAME TO target.src PREHOOK: type: ALTERTABLE_RENAME +PREHOOK: Input: source@src +PREHOOK: Output: source@src POSTHOOK: query: explain ALTER TABLE source.src RENAME TO target.src POSTHOOK: type: ALTERTABLE_RENAME +POSTHOOK: Input: source@src +POSTHOOK: Output: source@src STAGE DEPENDENCIES: Stage-0 is a root stage @@ -161,9 +165,13 @@ POSTHOOK: Input: target@src PREHOOK: query: explain ALTER TABLE source.srcpart RENAME TO target.srcpart PREHOOK: type: ALTERTABLE_RENAME +PREHOOK: Input: source@srcpart +PREHOOK: Output: source@srcpart POSTHOOK: query: explain ALTER TABLE source.srcpart RENAME TO target.srcpart POSTHOOK: type: ALTERTABLE_RENAME +POSTHOOK: Input: source@srcpart +POSTHOOK: Output: source@srcpart STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/ambiguitycheck.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/ambiguitycheck.q.out b/ql/src/test/results/clientpositive/ambiguitycheck.q.out index 80c9582..fb9bf5c 100644 --- a/ql/src/test/results/clientpositive/ambiguitycheck.q.out +++ b/ql/src/test/results/clientpositive/ambiguitycheck.q.out @@ -703,8 +703,12 @@ POSTHOOK: Input: default@src 98 val_98 2 PREHOOK: query: explain extended select int(1.2) from src limit 1 PREHOOK: type: QUERY +PREHOOK: Input: default@src +#### A masked pattern was here #### POSTHOOK: query: explain extended select int(1.2) from src limit 1 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +#### A masked pattern was here #### OPTIMIZED SQL: SELECT CAST(1.2 AS INTEGER) AS `_o__c0` FROM `default`.`src` LIMIT 1 @@ -814,8 +818,10 @@ NULL NULL PREHOOK: query: explain extended desc default.src key PREHOOK: type: DESCTABLE +PREHOOK: Input: default@src POSTHOOK: query: explain extended desc default.src key POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@src 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/b356aae0/ql/src/test/results/clientpositive/ambiguous_col.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/ambiguous_col.q.out b/ql/src/test/results/clientpositive/ambiguous_col.q.out index a7682fb..76fb264 100644 --- a/ql/src/test/results/clientpositive/ambiguous_col.q.out +++ b/ql/src/test/results/clientpositive/ambiguous_col.q.out @@ -1,7 +1,13 @@ PREHOOK: query: explain select * from (select a.key, a.* from (select * from src) a join (select * from src1) b on (a.key = b.key)) t PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select a.key, a.* from (select * from src) a join (select * from src1) b on (a.key = b.key)) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -117,8 +123,14 @@ POSTHOOK: Input: default@src1 98 98 val_98 PREHOOK: query: explain select * from (select a.key, a.`[k].*` from (select * from src) a join (select * from src1) b on (a.key = b.key)) t PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select a.key, a.`[k].*` from (select * from src) a join (select * from src1) b on (a.key = b.key)) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -233,8 +245,14 @@ POSTHOOK: Input: default@src1 98 98 PREHOOK: query: explain select * from (select a.key, a.key from (select * from src) a join (select * from src1) b on (a.key = b.key)) t PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain select * from (select a.key, a.key from (select * from src) a join (select * from src1) b on (a.key = b.key)) t POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### 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/b356aae0/ql/src/test/results/clientpositive/analyze_table_null_partition.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/analyze_table_null_partition.q.out b/ql/src/test/results/clientpositive/analyze_table_null_partition.q.out index 353813e..f21fbe6 100644 --- a/ql/src/test/results/clientpositive/analyze_table_null_partition.q.out +++ b/ql/src/test/results/clientpositive/analyze_table_null_partition.q.out @@ -85,8 +85,20 @@ age int #### A masked pattern was here #### PREHOOK: query: EXPLAIN EXTENDED select * from test2_n6 PREHOOK: type: QUERY +PREHOOK: Input: default@test2_n6 +PREHOOK: Input: default@test2_n6@age=15 +PREHOOK: Input: default@test2_n6@age=30 +PREHOOK: Input: default@test2_n6@age=40 +PREHOOK: Input: default@test2_n6@age=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### POSTHOOK: query: EXPLAIN EXTENDED select * from test2_n6 POSTHOOK: type: QUERY +POSTHOOK: Input: default@test2_n6 +POSTHOOK: Input: default@test2_n6@age=15 +POSTHOOK: Input: default@test2_n6@age=30 +POSTHOOK: Input: default@test2_n6@age=40 +POSTHOOK: Input: default@test2_n6@age=__HIVE_DEFAULT_PARTITION__ +#### A masked pattern was here #### OPTIMIZED SQL: SELECT `name`, `age` FROM `default`.`test2_n6` STAGE DEPENDENCIES: http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/analyze_tbl_date.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/analyze_tbl_date.q.out b/ql/src/test/results/clientpositive/analyze_tbl_date.q.out index c2294ab..b31b408 100644 --- a/ql/src/test/results/clientpositive/analyze_tbl_date.q.out +++ b/ql/src/test/results/clientpositive/analyze_tbl_date.q.out @@ -61,8 +61,12 @@ Storage Desc Params: serialization.format 1 PREHOOK: query: explain select * from test_table_n7 where d is not null PREHOOK: type: QUERY +PREHOOK: Input: default@test_table_n7 +#### A masked pattern was here #### POSTHOOK: query: explain select * from test_table_n7 where d is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@test_table_n7 +#### 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/b356aae0/ql/src/test/results/clientpositive/annotate_stats_deep_filters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/annotate_stats_deep_filters.q.out b/ql/src/test/results/clientpositive/annotate_stats_deep_filters.q.out index 5f68009..07ba2b1 100644 --- a/ql/src/test/results/clientpositive/annotate_stats_deep_filters.q.out +++ b/ql/src/test/results/clientpositive/annotate_stats_deep_filters.q.out @@ -88,6 +88,8 @@ or (t=37 and si=38) or (t=47 and si=48) or (t=52 and si=53)) PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from over1k_n4 where ( (t=1 and si=2) or (t=2 and si=3) @@ -110,6 +112,8 @@ or (t=37 and si=38) or (t=47 and si=48) or (t=52 and si=53)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n4 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -178,6 +182,8 @@ or (t=37 and si=38) or (t=47 and si=48) or (t=52 and si=53)) PREHOOK: type: QUERY +PREHOOK: Input: default@over1k_n4 +#### A masked pattern was here #### POSTHOOK: query: explain select count(*) from over1k_n4 where ( (t=1 and si=2) or (t=2 and si=3) @@ -200,6 +206,8 @@ or (t=37 and si=38) or (t=47 and si=48) or (t=52 and si=53)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@over1k_n4 +#### 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/b356aae0/ql/src/test/results/clientpositive/annotate_stats_filter.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/annotate_stats_filter.q.out b/ql/src/test/results/clientpositive/annotate_stats_filter.q.out index 59df9b2..7ee055c 100644 --- a/ql/src/test/results/clientpositive/annotate_stats_filter.q.out +++ b/ql/src/test/results/clientpositive/annotate_stats_filter.q.out @@ -54,8 +54,12 @@ POSTHOOK: Lineage: loc_orc.year SIMPLE [(loc_staging)loc_staging.FieldSchema(nam POSTHOOK: Lineage: loc_orc.zip SIMPLE [(loc_staging)loc_staging.FieldSchema(name:zip, type:bigint, comment:null), ] PREHOOK: query: explain select * from loc_orc PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -75,8 +79,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where state='OH' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where state='OH' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -122,8 +130,12 @@ POSTHOOK: Output: default@loc_orc #### A masked pattern was here #### PREHOOK: query: explain select * from loc_orc where state='OH' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where state='OH' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -159,8 +171,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where state!='OH' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where state!='OH' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -196,8 +212,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where state<>'OH' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where state<>'OH' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -233,8 +253,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where zip is null PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where zip is null POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -270,8 +294,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where !(zip is not null) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where !(zip is not null) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -307,8 +335,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where zip is not null PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where zip is not null POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -344,8 +376,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where !(zip is null) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where !(zip is null) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -381,8 +417,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where !false PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where !false POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -402,8 +442,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where !true PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where !true POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -439,8 +483,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where true PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where true POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -460,8 +508,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where 'foo' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where 'foo' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -497,8 +549,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where true = true PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where true = true POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -518,8 +574,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where false = true PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where false = true POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -555,8 +615,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where 'foo' = 'bar' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where 'foo' = 'bar' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -592,8 +656,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where false PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where false POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -629,8 +697,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where state='OH' or state='CA' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where state='OH' or state='CA' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -666,8 +738,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where year=2001 and year is null PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where year=2001 and year is null POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -703,8 +779,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where year=2001 and state='OH' and state='FL' PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where year=2001 and state='OH' and state='FL' POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -740,8 +820,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where (year=2001 and year is null) or (state='CA') PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where (year=2001 and year is null) or (state='CA') POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -777,8 +861,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where (year=2001 or year is null) and (state='CA') PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where (year=2001 or year is null) and (state='CA') POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -814,8 +902,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid < 30 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid < 30 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -851,8 +943,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid > 30 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid > 30 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -888,8 +984,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid <= 30 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid <= 30 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -925,8 +1025,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid >= 30 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid >= 30 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -962,8 +1066,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid < 3 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid < 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -999,8 +1107,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid > 3 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid > 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1036,8 +1148,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid <= 3 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid <= 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1073,8 +1189,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc where locid >= 3 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc where locid >= 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc +#### 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/b356aae0/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out b/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out index 18c103b..932e208 100644 --- a/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out +++ b/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out @@ -54,8 +54,12 @@ POSTHOOK: Lineage: loc_orc_n2.year SIMPLE [(loc_staging_n2)loc_staging_n2.FieldS POSTHOOK: Lineage: loc_orc_n2.zip SIMPLE [(loc_staging_n2)loc_staging_n2.FieldSchema(name:zip, type:bigint, comment:null), ] PREHOOK: query: explain select * from loc_orc_n2 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc_n2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -90,6 +94,8 @@ from ( select state as a, locid as b, count(*) as c ) sq1 group by a,c PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select a, c, min(b) from ( select state as a, locid as b, count(*) as c from loc_orc_n2 @@ -97,6 +103,8 @@ from ( select state as a, locid as b, count(*) as c ) sq1 group by a,c POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -190,8 +198,12 @@ POSTHOOK: Output: default@loc_orc_n2 #### A masked pattern was here #### PREHOOK: query: explain select year from loc_orc_n2 group by year PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select year from loc_orc_n2 group by year POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -240,8 +252,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -290,8 +306,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -341,8 +361,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -392,8 +416,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by rollup( state,locid ) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by rollup( state,locid ) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -443,8 +471,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state)) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -494,8 +526,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid)) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -545,8 +581,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid),()) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid),()) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -596,8 +636,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state,locid),(state),(locid),()) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state,locid),(state),(locid),()) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -647,8 +691,12 @@ STAGE PLANS: PREHOOK: query: explain select year from loc_orc_n2 group by year PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select year from loc_orc_n2 group by year POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -697,8 +745,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -748,8 +800,12 @@ STAGE PLANS: PREHOOK: query: explain select state,zip from loc_orc_n2 group by state,zip PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,zip from loc_orc_n2 group by state,zip POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -798,8 +854,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -849,8 +909,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with rollup PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with rollup POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -900,8 +964,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by rollup (state,locid) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by rollup (state,locid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -951,8 +1019,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state)) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1002,8 +1074,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid)) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid)) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1053,8 +1129,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid),()) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state),(locid),()) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1104,8 +1184,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state,locid),(state),(locid),()) PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid grouping sets((state,locid),(state),(locid),()) POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1155,8 +1239,12 @@ STAGE PLANS: PREHOOK: query: explain select year from loc_orc_n2 group by year PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select year from loc_orc_n2 group by year POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1205,8 +1293,12 @@ STAGE PLANS: PREHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select state,locid from loc_orc_n2 group by state,locid with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n2 +#### 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/b356aae0/ql/src/test/results/clientpositive/annotate_stats_groupby2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/annotate_stats_groupby2.q.out b/ql/src/test/results/clientpositive/annotate_stats_groupby2.q.out index 745fdce..9ec49bd 100644 --- a/ql/src/test/results/clientpositive/annotate_stats_groupby2.q.out +++ b/ql/src/test/results/clientpositive/annotate_stats_groupby2.q.out @@ -38,8 +38,12 @@ POSTHOOK: Output: default@location #### A masked pattern was here #### PREHOOK: query: explain select state, country from location group by state, country PREHOOK: type: QUERY +PREHOOK: Input: default@location +#### A masked pattern was here #### POSTHOOK: query: explain select state, country from location group by state, country POSTHOOK: type: QUERY +POSTHOOK: Input: default@location +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -88,8 +92,12 @@ STAGE PLANS: PREHOOK: query: explain select state, country from location group by state, country with cube PREHOOK: type: QUERY +PREHOOK: Input: default@location +#### A masked pattern was here #### POSTHOOK: query: explain select state, country from location group by state, country with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@location +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -139,8 +147,12 @@ STAGE PLANS: PREHOOK: query: explain select state, country from location group by state, country PREHOOK: type: QUERY +PREHOOK: Input: default@location +#### A masked pattern was here #### POSTHOOK: query: explain select state, country from location group by state, country POSTHOOK: type: QUERY +POSTHOOK: Input: default@location +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -189,8 +201,12 @@ STAGE PLANS: PREHOOK: query: explain select state, votes from location group by state, votes PREHOOK: type: QUERY +PREHOOK: Input: default@location +#### A masked pattern was here #### POSTHOOK: query: explain select state, votes from location group by state, votes POSTHOOK: type: QUERY +POSTHOOK: Input: default@location +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -239,8 +255,12 @@ STAGE PLANS: PREHOOK: query: explain select state, country from location group by state, country with cube PREHOOK: type: QUERY +PREHOOK: Input: default@location +#### A masked pattern was here #### POSTHOOK: query: explain select state, country from location group by state, country with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@location +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -290,8 +310,12 @@ STAGE PLANS: PREHOOK: query: explain select state, country from location group by state, country PREHOOK: type: QUERY +PREHOOK: Input: default@location +#### A masked pattern was here #### POSTHOOK: query: explain select state, country from location group by state, country POSTHOOK: type: QUERY +POSTHOOK: Input: default@location +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -340,8 +364,12 @@ STAGE PLANS: PREHOOK: query: explain select state, country from location group by state, country with cube PREHOOK: type: QUERY +PREHOOK: Input: default@location +#### A masked pattern was here #### POSTHOOK: query: explain select state, country from location group by state, country with cube POSTHOOK: type: QUERY +POSTHOOK: Input: default@location +#### 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/b356aae0/ql/src/test/results/clientpositive/annotate_stats_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/annotate_stats_join.q.out b/ql/src/test/results/clientpositive/annotate_stats_join.q.out index b7b429c..9cd48b0 100644 --- a/ql/src/test/results/clientpositive/annotate_stats_join.q.out +++ b/ql/src/test/results/clientpositive/annotate_stats_join.q.out @@ -126,8 +126,14 @@ POSTHOOK: Output: default@loc #### A masked pattern was here #### PREHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid) PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -193,8 +199,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2,dept_n1 where emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2,dept_n1 where emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -259,8 +271,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid and e.lastname = d.deptname) PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid and e.lastname = d.deptname) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -325,8 +343,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2,dept_n1 where emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2,dept_n1 where emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -391,8 +415,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid) join emp_n2 e1 on (e.deptid = e1.deptid) PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid) join emp_n2 e1 on (e.deptid = e1.deptid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -476,8 +506,16 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid) join loc l on (e.deptid = l.locid) PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +PREHOOK: Input: default@loc +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid) join loc l on (e.deptid = l.locid) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +POSTHOOK: Input: default@loc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -561,8 +599,16 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid and e.lastname = d.deptname) join loc l on (e.deptid = l.locid and e.lastname = l.state) PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +PREHOOK: Input: default@loc +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 e join dept_n1 d on (e.deptid = d.deptid and e.lastname = d.deptname) join loc l on (e.deptid = l.locid and e.lastname = l.state) POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +POSTHOOK: Input: default@loc +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -645,8 +691,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 left outer join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 left outer join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -705,8 +757,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 left semi join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 left semi join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -776,8 +834,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 right outer join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 right outer join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -836,8 +900,14 @@ STAGE PLANS: PREHOOK: query: explain select * from emp_n2 full outer join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname PREHOOK: type: QUERY +PREHOOK: Input: default@dept_n1 +PREHOOK: Input: default@emp_n2 +#### A masked pattern was here #### POSTHOOK: query: explain select * from emp_n2 full outer join dept_n1 on emp_n2.deptid = dept_n1.deptid and emp_n2.lastname = dept_n1.deptname and dept_n1.deptname = emp_n2.lastname POSTHOOK: type: QUERY +POSTHOOK: Input: default@dept_n1 +POSTHOOK: Input: default@emp_n2 +#### 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/b356aae0/ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out b/ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out index d9f6bad..c163022 100644 --- a/ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out +++ b/ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out @@ -360,8 +360,14 @@ POSTHOOK: Output: default@customer_address #### A masked pattern was here #### PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -425,8 +431,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_bigint s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) PREHOOK: type: QUERY +PREHOOK: Input: default@store_bigint +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_bigint s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_bigint +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -490,8 +502,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -555,8 +573,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_company_id > 0 and ss.ss_quantity > 10 PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_company_id > 0 and ss.ss_quantity > 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -620,8 +644,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 0 PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -685,8 +715,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -750,8 +786,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -836,8 +878,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 1000 PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_store_sk > 1000 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -922,8 +970,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 1000 PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where s.s_floor_space > 1000 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1008,8 +1062,14 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 PREHOOK: type: QUERY +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join store_n0 s1 on (s1.s_store_sk = ss.ss_store_sk) where ss.ss_quantity > 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1094,8 +1154,16 @@ STAGE PLANS: PREHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join customer_address ca on (ca.ca_address_sk = ss.ss_addr_sk) PREHOOK: type: QUERY +PREHOOK: Input: default@customer_address +PREHOOK: Input: default@store_n0 +PREHOOK: Input: default@store_sales_n0 +#### A masked pattern was here #### POSTHOOK: query: explain select s.s_store_sk from store_n0 s join store_sales_n0 ss on (s.s_store_sk = ss.ss_store_sk) join customer_address ca on (ca.ca_address_sk = ss.ss_addr_sk) POSTHOOK: type: QUERY +POSTHOOK: Input: default@customer_address +POSTHOOK: Input: default@store_n0 +POSTHOOK: Input: default@store_sales_n0 +#### 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/b356aae0/ql/src/test/results/clientpositive/annotate_stats_limit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/annotate_stats_limit.q.out b/ql/src/test/results/clientpositive/annotate_stats_limit.q.out index 16f8a4f..ec1dc8b 100644 --- a/ql/src/test/results/clientpositive/annotate_stats_limit.q.out +++ b/ql/src/test/results/clientpositive/annotate_stats_limit.q.out @@ -64,8 +64,12 @@ POSTHOOK: Output: default@loc_orc_n5 #### A masked pattern was here #### PREHOOK: query: explain select * from loc_orc_n5 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc_n5 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -85,8 +89,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc_n5 limit 4 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc_n5 limit 4 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -109,8 +117,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc_n5 limit 16 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc_n5 limit 16 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage @@ -133,8 +145,12 @@ STAGE PLANS: PREHOOK: query: explain select * from loc_orc_n5 limit 0 PREHOOK: type: QUERY +PREHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### POSTHOOK: query: explain select * from loc_orc_n5 limit 0 POSTHOOK: type: QUERY +POSTHOOK: Input: default@loc_orc_n5 +#### A masked pattern was here #### STAGE DEPENDENCIES: Stage-0 is a root stage
