http://git-wip-us.apache.org/repos/asf/hive/blob/b356aae0/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out b/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out index ab8c7a1..4daa7b9 100644 --- a/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out +++ b/ql/src/test/results/clientpositive/llap/enforce_constraint_notnull.q.out @@ -8,8 +8,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@table1_n7 PREHOOK: query: explain INSERT INTO table1_n7 values('not', 'null', 'constraint') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT INTO table1_n7 values('not', 'null', 'constraint') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -126,8 +130,12 @@ POSTHOOK: Input: default@table1_n7 not null constraint PREHOOK: query: explain insert into table1_n7(a,c) values('1','2') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain insert into table1_n7(a,c) values('1','2') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -235,8 +243,12 @@ POSTHOOK: Lineage: table1_n7.b SIMPLE [] POSTHOOK: Lineage: table1_n7.c SCRIPT [] PREHOOK: query: explain INSERT INTO table1_n7 select key, src.value, value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT INTO table1_n7 select key, src.value, value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -846,8 +858,12 @@ POSTHOOK: Input: default@table1_n7 not null constraint PREHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 select src.*, value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 select src.*, value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -1455,8 +1471,12 @@ POSTHOOK: Input: default@table1_n7 98 val_98 val_98 PREHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 if not exists select src.key, src.key, src.value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@table1_n7 POSTHOOK: query: explain INSERT OVERWRITE TABLE table1_n7 if not exists select src.key, src.key, src.value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@table1_n7 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2091,11 +2111,17 @@ from src insert overwrite table src_multi1_n0 select * where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n0 +PREHOOK: Output: default@src_multi2_n1 POSTHOOK: query: explain from src insert overwrite table src_multi1_n0 select * where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n0 +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2269,11 +2295,17 @@ from src insert into table src_multi1_n0 select * where src.key < 10 insert into table src_multi2_n1 select src.* where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi1_n0 +PREHOOK: Output: default@src_multi2_n1 POSTHOOK: query: explain from src insert into table src_multi1_n0 select * where src.key < 10 insert into table src_multi2_n1 select src.* where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi1_n0 +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -2458,10 +2490,14 @@ PREHOOK: query: explain insert into table acid_uami_n1 values (1, 109.23, 'mary had a little lamb'), (6553, 923.19, 'its fleece was white as snow') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 values (1, 109.23, 'mary had a little lamb'), (6553, 923.19, 'its fleece was white as snow') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2599,9 +2635,13 @@ POSTHOOK: Input: default@acid_uami_n1 PREHOOK: query: --insert into select explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: --insert into select explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2716,8 +2756,12 @@ POSTHOOK: Lineage: acid_uami_n1.i EXPRESSION [(src)src.FieldSchema(name:key, typ POSTHOOK: Lineage: acid_uami_n1.vc EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2840,9 +2884,13 @@ STAGE PLANS: PREHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src order by key limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src order by key limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -2963,9 +3011,13 @@ STAGE PLANS: PREHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src group by key, value order by key limit 2 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src group by key, value order by key limit 2 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3096,9 +3148,13 @@ STAGE PLANS: PREHOOK: query: --overwrite explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: --overwrite explain insert into table acid_uami_n1 select cast(key as int), cast (key as decimal(5,2)), value from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3213,8 +3269,12 @@ POSTHOOK: Lineage: acid_uami_n1.i EXPRESSION [(src)src.FieldSchema(name:key, typ POSTHOOK: Lineage: acid_uami_n1.vc EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: explain update acid_uami_n1 set de = 3.14 where de = 109.23 or de = 119.23 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n1 +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain update acid_uami_n1 set de = 3.14 where de = 109.23 or de = 119.23 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n1 +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3306,8 +3366,12 @@ POSTHOOK: Input: default@acid_uami_n1 POSTHOOK: Output: default@acid_uami_n1 PREHOOK: query: explain update acid_uami_n1 set de = 3.14159 where de = 3.14 PREHOOK: type: QUERY +PREHOOK: Input: default@acid_uami_n1 +PREHOOK: Output: default@acid_uami_n1 POSTHOOK: query: explain update acid_uami_n1 set de = 3.14159 where de = 3.14 POSTHOOK: type: QUERY +POSTHOOK: Input: default@acid_uami_n1 +POSTHOOK: Output: default@acid_uami_n1 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3390,11 +3454,17 @@ from src insert overwrite table acid_uami_n1 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@acid_uami_n1 +PREHOOK: Output: default@src_multi2_n1 POSTHOOK: query: explain from src insert overwrite table acid_uami_n1 select cast(key as int), cast(key as decimal(5,2)), value where key < 10 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@acid_uami_n1 +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -3575,8 +3645,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tablePartitioned PREHOOK: query: explain INSERT INTO tablePartitioned partition(p1='today', p2=10) values('not', 'null', 'constraint') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tablepartitioned@p1=today/p2=10 POSTHOOK: query: explain INSERT INTO tablePartitioned partition(p1='today', p2=10) values('not', 'null', 'constraint') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tablepartitioned@p1=today/p2=10 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3695,8 +3769,11 @@ POSTHOOK: Lineage: tablepartitioned PARTITION(p1=today,p2=10).b SCRIPT [] POSTHOOK: Lineage: tablepartitioned PARTITION(p1=today,p2=10).c SCRIPT [] PREHOOK: query: explain INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, key as p1, 3 as p2 from src limit 10 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@tablepartitioned POSTHOOK: query: explain INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, key as p1, 3 as p2 from src limit 10 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -3905,11 +3982,16 @@ from src INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, 'yesterday' as p1, 3 as p2 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_multi2_n1 +PREHOOK: Output: default@tablepartitioned POSTHOOK: query: explain from src INSERT INTO tablePartitioned partition(p1, p2) select key, value, value, 'yesterday' as p1, 3 as p2 insert overwrite table src_multi2_n1 select * where key > 10 and key < 20 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_multi2_n1 STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -4120,11 +4202,21 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -4355,11 +4447,23 @@ WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-4 is a root stage Stage-5 depends on stages: Stage-4 @@ -4673,10 +4777,20 @@ PREHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -4943,10 +5057,20 @@ PREHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 3 THEN UPDATE set a1 = '1' WHEN NOT MATCHED THEN INSERT VALUES (s.key, s.a1, s.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-3 is a root stage Stage-4 depends on stages: Stage-3 @@ -5213,9 +5337,17 @@ STAGE PLANS: PREHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE PREHOOK: type: QUERY +PREHOOK: Input: default@masking_test_n4 +PREHOOK: Input: default@nonacid_n2 +PREHOOK: Output: default@masking_test_n4 +PREHOOK: Output: default@merge_tmp_table POSTHOOK: query: explain MERGE INTO masking_test_n4 as t using nonacid_n2 as s ON t.key = s.key WHEN MATCHED AND s.key < 5 THEN DELETE POSTHOOK: type: QUERY +POSTHOOK: Input: default@masking_test_n4 +POSTHOOK: Input: default@nonacid_n2 +POSTHOOK: Output: default@masking_test_n4 +POSTHOOK: Output: default@merge_tmp_table STAGE DEPENDENCIES: Stage-2 is a root stage Stage-3 depends on stages: Stage-2 @@ -5430,8 +5562,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@table2_n3 PREHOOK: query: explain insert into table2_n3 values(2, 3) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table2_n3 POSTHOOK: query: explain insert into table2_n3 values(2, 3) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table2_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5532,8 +5668,12 @@ POSTHOOK: query: alter table table2_n3 drop constraint nn5 POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT PREHOOK: query: explain insert into table2_n3 values(2, 3) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@table2_n3 POSTHOOK: query: explain insert into table2_n3 values(2, 3) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@table2_n3 STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5643,8 +5783,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@tttemp PREHOOK: query: explain insert into tttemp values(1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@tttemp POSTHOOK: query: explain insert into tttemp values(1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@tttemp STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5741,8 +5885,12 @@ STAGE PLANS: PREHOOK: query: explain insert into tttemp select cast(key as int) from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@tttemp POSTHOOK: query: explain insert into tttemp select cast(key as int) from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@tttemp STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1 @@ -5847,8 +5995,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_mm_n1 PREHOOK: query: explain insert into table part_mm_n1 partition(key_mm=455) select key from src order by value limit 3 PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@part_mm_n1@key_mm=455 POSTHOOK: query: explain insert into table part_mm_n1 partition(key_mm=455) select key from src order by value limit 3 POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@part_mm_n1@key_mm=455 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/llap/except_distinct.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/except_distinct.q.out b/ql/src/test/results/clientpositive/llap/except_distinct.q.out index 961a855..ea0224c 100644 --- a/ql/src/test/results/clientpositive/llap/except_distinct.q.out +++ b/ql/src/test/results/clientpositive/llap/except_distinct.q.out @@ -203,8 +203,12 @@ POSTHOOK: Output: hdfs://### HDFS PATH ### 2 20 PREHOOK: query: explain select * from src except distinct select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select * from src except distinct select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -365,8 +369,12 @@ POSTHOOK: Input: default@src POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select * from src except distinct select * from src except distinct select * from src except distinct select * from src PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select * from src except distinct select * from src except distinct select * from src except distinct select * from src POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: hdfs://### HDFS PATH ### STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -689,8 +697,14 @@ POSTHOOK: Input: default@src POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain select value from a_n16 group by value except distinct select key from b_n12 group by key PREHOOK: type: QUERY +PREHOOK: Input: default@a_n16 +PREHOOK: Input: default@b_n12 +PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: explain select value from a_n16 group by value except distinct select key from b_n12 group by key POSTHOOK: type: QUERY +POSTHOOK: Input: default@a_n16 +POSTHOOK: Input: default@b_n12 +POSTHOOK: Output: hdfs://### HDFS PATH ### 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/llap/explainanalyze_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out b/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out index 0c6bd6a..3f1105a 100644 --- a/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out +++ b/ql/src/test/results/clientpositive/llap/explainanalyze_2.q.out @@ -29,6 +29,9 @@ SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select * from src1 union select * from src)z ON (x.value = z.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain analyze SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -38,6 +41,9 @@ SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select * from src1 union select * from src)z ON (x.value = z.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -208,6 +214,9 @@ SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select key, value from src1 union select key, value from src union select key, value from src union select key, value from src)z ON (x.value = z.value) PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +#### A masked pattern was here #### POSTHOOK: query: explain analyze SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -221,6 +230,9 @@ SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) JOIN (select key, value from src1 union select key, value from src union select key, value from src union select key, value from src)z ON (x.value = z.value) POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -598,9 +610,15 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -637,9 +655,15 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key join tab_n6 s2 on s1.value=s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key join tab_n6 s2 on s1.value=s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -704,9 +728,19 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key PREHOOK: type: QUERY +PREHOOK: Input: default@tab2_n3 +PREHOOK: Input: default@tab2_n3@ds=2008-04-08 +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab2_n3 +POSTHOOK: Input: default@tab2_n3@ds=2008-04-08 +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Stage-0 @@ -747,9 +781,19 @@ POSTHOOK: Input: default@tab_n6@ds=2008-04-08 PREHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key join tab2_n3 s2 on s1.value=s2.value PREHOOK: type: QUERY +PREHOOK: Input: default@tab2_n3 +PREHOOK: Input: default@tab2_n3@ds=2008-04-08 +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select s1.key as key, s1.value as value from tab_n6 s1 join tab2_n3 s3 on s1.key=s3.key join tab2_n3 s2 on s1.value=s2.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab2_n3 +POSTHOOK: Input: default@tab2_n3@ds=2008-04-08 +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -823,12 +867,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n7 +PREHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select count(*) from (select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n7 +POSTHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -912,12 +966,22 @@ UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) PREHOOK: type: QUERY +PREHOOK: Input: default@tab_n6 +PREHOOK: Input: default@tab_n6@ds=2008-04-08 +PREHOOK: Input: default@tab_part_n7 +PREHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### POSTHOOK: query: explain analyze select count(*) from (select s1.key as key, s1.value as value from tab_n6 s1 join tab_n6 s3 on s1.key=s3.key join tab_n6 s2 on s1.value=s2.value UNION ALL select s2.key as key, s2.value as value from tab_n6 s2 ) a_n14 join tab_part_n7 b_n10 on (a_n14.key = b_n10.key) POSTHOOK: type: QUERY +POSTHOOK: Input: default@tab_n6 +POSTHOOK: Input: default@tab_n6@ds=2008-04-08 +POSTHOOK: Input: default@tab_part_n7 +POSTHOOK: Input: default@tab_part_n7@ds=2008-04-08 +#### A masked pattern was here #### Plan optimized by CBO. Vertex dependency in root stage @@ -1085,6 +1149,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@a_n14 +PREHOOK: Output: default@b_n10 +PREHOOK: Output: default@c_n3 POSTHOOK: query: explain analyze from ( @@ -1104,6 +1173,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@a_n14 +POSTHOOK: Output: default@b_n10 +POSTHOOK: Output: default@c_n3 Plan optimized by CBO. Vertex dependency in root stage @@ -1440,6 +1514,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +PREHOOK: Output: default@a_n14 +PREHOOK: Output: default@b_n10 +PREHOOK: Output: default@c_n3 POSTHOOK: query: explain analyze FROM ( @@ -1456,6 +1535,11 @@ INSERT OVERWRITE TABLE a_n14 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE b_n10 SELECT tmp.key, tmp.value INSERT OVERWRITE TABLE c_n3 SELECT tmp.key, tmp.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +POSTHOOK: Output: default@a_n14 +POSTHOOK: Output: default@b_n10 +POSTHOOK: Output: default@c_n3 Plan optimized by CBO. Vertex dependency in root stage @@ -1796,6 +1880,9 @@ FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n105 +PREHOOK: Output: default@dest2_n29 POSTHOOK: query: explain analyze FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 UNION DISTINCT @@ -1803,6 +1890,9 @@ FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1 INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n105 +POSTHOOK: Output: default@dest2_n29 Plan optimized by CBO. Vertex dependency in root stage @@ -1903,8 +1993,24 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: explain analyze FROM UNIQUEJOIN PRESERVE src a_n14 (a_n14.key), PRESERVE src1 b_n10 (b_n10.key), PRESERVE srcpart c_n3 (c_n3.key) SELECT a_n14.key, b_n10.key, c_n3.key PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Input: default@src1 +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 +#### A masked pattern was here #### POSTHOOK: query: explain analyze FROM UNIQUEJOIN PRESERVE src a_n14 (a_n14.key), PRESERVE src1 b_n10 (b_n10.key), PRESERVE srcpart c_n3 (c_n3.key) SELECT a_n14.key, b_n10.key, c_n3.key POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Input: default@src1 +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 +#### A masked pattern was here #### Plan not optimized by CBO due to missing feature [Unique_join]. Vertex dependency in root stage @@ -1979,6 +2085,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n105 +PREHOOK: Output: default@dest2_n29 POSTHOOK: query: explain analyze FROM ( select key, value from ( @@ -1992,6 +2101,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n105 +POSTHOOK: Output: default@dest2_n29 Plan optimized by CBO. Vertex dependency in root stage @@ -2119,6 +2231,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@dest1_n105 +PREHOOK: Output: default@dest2_n29 POSTHOOK: query: explain analyze FROM ( select 'tst1' as key, cast(count(1) as string) as value, 'tst1' as value2 from src s1 @@ -2129,6 +2244,9 @@ INSERT OVERWRITE TABLE DEST1_n105 SELECT unionsrc_n3.key, COUNT(DISTINCT SUBSTR( INSERT OVERWRITE TABLE DEST2_n29 SELECT unionsrc_n3.key, unionsrc_n3.value, COUNT(DISTINCT SUBSTR(unionsrc_n3.value,5)) GROUP BY unionsrc_n3.key, unionsrc_n3.value POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@dest1_n105 +POSTHOOK: Output: default@dest2_n29 Plan optimized by CBO. Vertex dependency in root stage