http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/udf_width_bucket.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udf_width_bucket.q.out b/ql/src/test/results/clientpositive/udf_width_bucket.q.out index eeca88a..729171a 100644 --- a/ql/src/test/results/clientpositive/udf_width_bucket.q.out +++ b/ql/src/test/results/clientpositive/udf_width_bucket.q.out @@ -214,12 +214,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@alldecimaltypes PREHOOK: query: insert into table alldecimaltypes values (0.1, 0.1), (0.25, 0.25), (0.3456, 0.3456), (0.654321, 0.654321) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@alldecimaltypes POSTHOOK: query: insert into table alldecimaltypes values (0.1, 0.1), (0.25, 0.25), (0.3456, 0.3456), (0.654321, 0.654321) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@alldecimaltypes -POSTHOOK: Lineage: alldecimaltypes.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: alldecimaltypes.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: alldecimaltypes.cdouble SCRIPT [] +POSTHOOK: Lineage: alldecimaltypes.cfloat SCRIPT [] PREHOOK: query: select width_bucket(cfloat, 0, 1, 10), width_bucket(cdouble, 0, 1, 10) @@ -288,6 +290,7 @@ PREHOOK: query: insert into table alltypes values (72, 72, 72, 72, 72.0, 72.0), (100, 100, 100, 100, 100.0, 100.0) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@alltypes POSTHOOK: query: insert into table alltypes values (0, 0, 0, 0, 0.0, 0.0), @@ -297,13 +300,14 @@ POSTHOOK: query: insert into table alltypes values (72, 72, 72, 72, 72.0, 72.0), (100, 100, 100, 100, 100.0, 100.0) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@alltypes -POSTHOOK: Lineage: alltypes.cbigint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.cdouble EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.cfloat EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.cint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.csmallint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.ctinyint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: alltypes.cbigint SCRIPT [] +POSTHOOK: Lineage: alltypes.cdouble SCRIPT [] +POSTHOOK: Lineage: alltypes.cfloat SCRIPT [] +POSTHOOK: Lineage: alltypes.cint SCRIPT [] +POSTHOOK: Lineage: alltypes.csmallint SCRIPT [] +POSTHOOK: Lineage: alltypes.ctinyint SCRIPT [] PREHOOK: query: select width_bucket(ctinyint, 0, 100, 10), width_bucket(csmallint, 0, 100, 10), @@ -340,16 +344,18 @@ POSTHOOK: type: TRUNCATETABLE POSTHOOK: Output: default@alltypes PREHOOK: query: insert into table alltypes values (5, 5, 5, 10, 4.5, 7.25) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@alltypes POSTHOOK: query: insert into table alltypes values (5, 5, 5, 10, 4.5, 7.25) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@alltypes -POSTHOOK: Lineage: alltypes.cbigint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.cdouble EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.cfloat EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.cint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.csmallint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: alltypes.ctinyint EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: alltypes.cbigint SCRIPT [] +POSTHOOK: Lineage: alltypes.cdouble SCRIPT [] +POSTHOOK: Lineage: alltypes.cfloat SCRIPT [] +POSTHOOK: Lineage: alltypes.cint SCRIPT [] +POSTHOOK: Lineage: alltypes.csmallint SCRIPT [] +POSTHOOK: Lineage: alltypes.ctinyint SCRIPT [] PREHOOK: query: select width_bucket(cdouble, ctinyint, cbigint, 10), width_bucket(cdouble, csmallint, cbigint, 10), @@ -387,14 +393,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@alltinyints PREHOOK: query: insert into table alltinyints values (5, 1, 10, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@alltinyints POSTHOOK: query: insert into table alltinyints values (5, 1, 10, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@alltinyints -POSTHOOK: Lineage: alltinyints.cint EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: alltinyints.ctinyint1 EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: alltinyints.ctinyint2 EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: alltinyints.ctinyint3 EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: alltinyints.cint SCRIPT [] +POSTHOOK: Lineage: alltinyints.ctinyint1 SCRIPT [] +POSTHOOK: Lineage: alltinyints.ctinyint2 SCRIPT [] +POSTHOOK: Lineage: alltinyints.ctinyint3 SCRIPT [] PREHOOK: query: select width_bucket(ctinyint1, ctinyint2, ctinyint3, cint) from alltinyints PREHOOK: type: QUERY PREHOOK: Input: default@alltinyints @@ -422,14 +430,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@allsmallints PREHOOK: query: insert into table allsmallints values (5, 1, 10, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@allsmallints POSTHOOK: query: insert into table allsmallints values (5, 1, 10, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@allsmallints -POSTHOOK: Lineage: allsmallints.cint EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: allsmallints.csmallint1 EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: allsmallints.csmallint2 EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: allsmallints.csmallint3 EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: allsmallints.cint SCRIPT [] +POSTHOOK: Lineage: allsmallints.csmallint1 SCRIPT [] +POSTHOOK: Lineage: allsmallints.csmallint2 SCRIPT [] +POSTHOOK: Lineage: allsmallints.csmallint3 SCRIPT [] PREHOOK: query: select width_bucket(csmallint1, csmallint2, csmallint3, cint) from allsmallints PREHOOK: type: QUERY PREHOOK: Input: default@allsmallints @@ -457,14 +467,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@allints PREHOOK: query: insert into table allints values (5, 1, 10, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@allints POSTHOOK: query: insert into table allints values (5, 1, 10, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@allints -POSTHOOK: Lineage: allints.cint1 EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: allints.cint2 EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: allints.cint3 EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: allints.cint4 EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: allints.cint1 SCRIPT [] +POSTHOOK: Lineage: allints.cint2 SCRIPT [] +POSTHOOK: Lineage: allints.cint3 SCRIPT [] +POSTHOOK: Lineage: allints.cint4 SCRIPT [] PREHOOK: query: select width_bucket(cint1, cint2, cint3, cint4) from allints PREHOOK: type: QUERY PREHOOK: Input: default@allints @@ -492,14 +504,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@allbigints PREHOOK: query: insert into table allbigints values (5, 1, 10, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@allbigints POSTHOOK: query: insert into table allbigints values (5, 1, 10, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@allbigints -POSTHOOK: Lineage: allbigints.cbigint1 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: allbigints.cbigint2 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: allbigints.cbigint3 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: allbigints.cint EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: allbigints.cbigint1 SCRIPT [] +POSTHOOK: Lineage: allbigints.cbigint2 SCRIPT [] +POSTHOOK: Lineage: allbigints.cbigint3 SCRIPT [] +POSTHOOK: Lineage: allbigints.cint SCRIPT [] PREHOOK: query: select width_bucket(cbigint1, cbigint2, cbigint3, cint) from allbigints PREHOOK: type: QUERY PREHOOK: Input: default@allbigints @@ -527,14 +541,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@allfloats PREHOOK: query: insert into table allfloats values (5.0, 1.0, 10.0, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@allfloats POSTHOOK: query: insert into table allfloats values (5.0, 1.0, 10.0, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@allfloats -POSTHOOK: Lineage: allfloats.cfloat1 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: allfloats.cfloat2 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: allfloats.cfloat3 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: allfloats.cint EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: allfloats.cfloat1 SCRIPT [] +POSTHOOK: Lineage: allfloats.cfloat2 SCRIPT [] +POSTHOOK: Lineage: allfloats.cfloat3 SCRIPT [] +POSTHOOK: Lineage: allfloats.cint SCRIPT [] PREHOOK: query: select width_bucket(cfloat1, cfloat2, cfloat3, cint) from allfloats PREHOOK: type: QUERY PREHOOK: Input: default@allfloats @@ -562,14 +578,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@alldoubles PREHOOK: query: insert into table alldoubles values (5.0, 1.0, 10.0, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@alldoubles POSTHOOK: query: insert into table alldoubles values (5.0, 1.0, 10.0, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@alldoubles -POSTHOOK: Lineage: alldoubles.cdouble1 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: alldoubles.cdouble2 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: alldoubles.cdouble3 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: alldoubles.cint EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: alldoubles.cdouble1 SCRIPT [] +POSTHOOK: Lineage: alldoubles.cdouble2 SCRIPT [] +POSTHOOK: Lineage: alldoubles.cdouble3 SCRIPT [] +POSTHOOK: Lineage: alldoubles.cint SCRIPT [] PREHOOK: query: select width_bucket(cdouble1, cdouble2, cdouble3, cint) from alldoubles PREHOOK: type: QUERY PREHOOK: Input: default@alldoubles @@ -589,12 +607,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@testgroupingsets PREHOOK: query: insert into table testgroupingsets values (1, 1), (2, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@testgroupingsets POSTHOOK: query: insert into table testgroupingsets values (1, 1), (2, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@testgroupingsets -POSTHOOK: Lineage: testgroupingsets.c1 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: testgroupingsets.c2 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: testgroupingsets.c1 SCRIPT [] +POSTHOOK: Lineage: testgroupingsets.c2 SCRIPT [] PREHOOK: query: select c1, c2, width_bucket(5, c1, 10, case when grouping(c2) = 0 then 10 else 5 end) from testgroupingsets group by cube(c1, c2) PREHOOK: type: QUERY PREHOOK: Input: default@testgroupingsets
http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/udtf_replicate_rows.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udtf_replicate_rows.q.out b/ql/src/test/results/clientpositive/udtf_replicate_rows.q.out index 2967d6b..d402289 100644 --- a/ql/src/test/results/clientpositive/udtf_replicate_rows.q.out +++ b/ql/src/test/results/clientpositive/udtf_replicate_rows.q.out @@ -20,13 +20,15 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@t PREHOOK: query: insert into table t values (3,'2',0),(2,'3',1),(0,'2',2),(-1,'k',3) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@t POSTHOOK: query: insert into table t values (3,'2',0),(2,'3',1),(0,'2',2),(-1,'k',3) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@t -POSTHOOK: Lineage: t.x EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: t.y SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: t.z EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: t.x SCRIPT [] +POSTHOOK: Lineage: t.y SCRIPT [] +POSTHOOK: Lineage: t.z SCRIPT [] PREHOOK: query: SELECT replicate_rows(x,y) FROM t PREHOOK: type: QUERY PREHOOK: Input: default@t http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/union37.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/union37.q.out b/ql/src/test/results/clientpositive/union37.q.out index b67de4f..1b9ac10 100644 --- a/ql/src/test/results/clientpositive/union37.q.out +++ b/ql/src/test/results/clientpositive/union37.q.out @@ -8,13 +8,15 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@l_test1 PREHOOK: query: insert into l_test1 values (1, "table_1", "2016-08-11") PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@l_test1 POSTHOOK: query: insert into l_test1 values (1, "table_1", "2016-08-11") POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@l_test1 -POSTHOOK: Lineage: l_test1.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: l_test1.trans_date SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: l_test1.val SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: l_test1.id SCRIPT [] +POSTHOOK: Lineage: l_test1.trans_date SCRIPT [] +POSTHOOK: Lineage: l_test1.val SCRIPT [] PREHOOK: query: create table l_test2 (id bigint,val string,trans_date string) row format delimited fields terminated by ' ' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -25,13 +27,15 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@l_test2 PREHOOK: query: insert into l_test2 values (2, "table_2", "2016-08-11") PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@l_test2 POSTHOOK: query: insert into l_test2 values (2, "table_2", "2016-08-11") POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@l_test2 -POSTHOOK: Lineage: l_test2.id EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: l_test2.trans_date SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: l_test2.val SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: l_test2.id SCRIPT [] +POSTHOOK: Lineage: l_test2.trans_date SCRIPT [] +POSTHOOK: Lineage: l_test2.val SCRIPT [] PREHOOK: query: explain select id, http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/union_paren.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/union_paren.q.out b/ql/src/test/results/clientpositive/union_paren.q.out index 6bfd427..b78dd20 100644 --- a/ql/src/test/results/clientpositive/union_paren.q.out +++ b/ql/src/test/results/clientpositive/union_paren.q.out @@ -59,11 +59,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@t1 PREHOOK: query: insert into t1 values (1),(1),(2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@t1 POSTHOOK: query: insert into t1 values (1),(1),(2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@t1 -POSTHOOK: Lineage: t1.c EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: t1.c SCRIPT [] PREHOOK: query: create table t2(c int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -74,11 +76,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@t2 PREHOOK: query: insert into t2 values (2),(1),(2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@t2 POSTHOOK: query: insert into t2 values (2),(1),(2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@t2 -POSTHOOK: Lineage: t2.c EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: t2.c SCRIPT [] PREHOOK: query: create table t3(c int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -89,11 +93,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@t3 PREHOOK: query: insert into t3 values (2),(3),(2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@t3 POSTHOOK: query: insert into t3 values (2),(3),(2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@t3 -POSTHOOK: Lineage: t3.c EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: t3.c SCRIPT [] PREHOOK: query: (select * from t1) union all select * from t2 union select * from t3 order by c PREHOOK: type: QUERY PREHOOK: Input: default@t1 http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/unionall_unbalancedppd.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/unionall_unbalancedppd.q.out b/ql/src/test/results/clientpositive/unionall_unbalancedppd.q.out index 625063a..965c405 100644 --- a/ql/src/test/results/clientpositive/unionall_unbalancedppd.q.out +++ b/ql/src/test/results/clientpositive/unionall_unbalancedppd.q.out @@ -144,34 +144,42 @@ POSTHOOK: Input: default@union_all_bug_test_2 #### A masked pattern was here #### PREHOOK: query: insert into table union_all_bug_test_1 values (1,1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@union_all_bug_test_1 POSTHOOK: query: insert into table union_all_bug_test_1 values (1,1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@union_all_bug_test_1 -POSTHOOK: Lineage: union_all_bug_test_1.f1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: union_all_bug_test_1.f2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: union_all_bug_test_1.f1 SCRIPT [] +POSTHOOK: Lineage: union_all_bug_test_1.f2 SCRIPT [] PREHOOK: query: insert into table union_all_bug_test_2 values (1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@union_all_bug_test_2 POSTHOOK: query: insert into table union_all_bug_test_2 values (1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@union_all_bug_test_2 -POSTHOOK: Lineage: union_all_bug_test_2.f1 EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: union_all_bug_test_2.f1 SCRIPT [] PREHOOK: query: insert into table union_all_bug_test_1 values (0,0) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@union_all_bug_test_1 POSTHOOK: query: insert into table union_all_bug_test_1 values (0,0) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@union_all_bug_test_1 -POSTHOOK: Lineage: union_all_bug_test_1.f1 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: union_all_bug_test_1.f2 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: union_all_bug_test_1.f1 SCRIPT [] +POSTHOOK: Lineage: union_all_bug_test_1.f2 SCRIPT [] PREHOOK: query: insert into table union_all_bug_test_2 values (0) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@union_all_bug_test_2 POSTHOOK: query: insert into table union_all_bug_test_2 values (0) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@union_all_bug_test_2 -POSTHOOK: Lineage: union_all_bug_test_2.f1 EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: union_all_bug_test_2.f1 SCRIPT [] PREHOOK: query: SELECT f1 FROM ( http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/updateBasicStats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/updateBasicStats.q.out b/ql/src/test/results/clientpositive/updateBasicStats.q.out index ad035f3..7bae1ae 100644 --- a/ql/src/test/results/clientpositive/updateBasicStats.q.out +++ b/ql/src/test/results/clientpositive/updateBasicStats.q.out @@ -128,11 +128,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@calendarp PREHOOK: query: insert into table calendarp partition (p=1) values (2010), (2011), (2012) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@calendarp@p=1 POSTHOOK: query: insert into table calendarp partition (p=1) values (2010), (2011), (2012) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@calendarp@p=1 -POSTHOOK: Lineage: calendarp PARTITION(p=1).year EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: calendarp PARTITION(p=1).year SCRIPT [] PREHOOK: query: explain select * from calendarp where p=1 PREHOOK: type: QUERY POSTHOOK: query: explain select * from calendarp where p=1 http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out b/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out index 36f2aa4..98a26e0 100644 --- a/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out +++ b/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out @@ -14,28 +14,32 @@ PREHOOK: query: insert into table acid_uami 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 POSTHOOK: query: insert into table acid_uami 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 -POSTHOOK: Lineage: acid_uami.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: acid_uami.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: acid_uami.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: acid_uami.de SCRIPT [] +POSTHOOK: Lineage: acid_uami.i SCRIPT [] +POSTHOOK: Lineage: acid_uami.vc SCRIPT [] PREHOOK: query: insert into table acid_uami values (10, 119.23, 'and everywhere that mary went'), (65530, 823.19, 'the lamb was sure to go') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@acid_uami POSTHOOK: query: insert into table acid_uami values (10, 119.23, 'and everywhere that mary went'), (65530, 823.19, 'the lamb was sure to go') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@acid_uami -POSTHOOK: Lineage: acid_uami.de EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: acid_uami.i EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: acid_uami.vc EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: acid_uami.de SCRIPT [] +POSTHOOK: Lineage: acid_uami.i SCRIPT [] +POSTHOOK: Lineage: acid_uami.vc SCRIPT [] PREHOOK: query: select * from acid_uami order by de PREHOOK: type: QUERY PREHOOK: Input: default@acid_uami http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/update_after_multiple_inserts_special_characters.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/update_after_multiple_inserts_special_characters.q.out b/ql/src/test/results/clientpositive/update_after_multiple_inserts_special_characters.q.out index e690ac1..0724093 100644 --- a/ql/src/test/results/clientpositive/update_after_multiple_inserts_special_characters.q.out +++ b/ql/src/test/results/clientpositive/update_after_multiple_inserts_special_characters.q.out @@ -14,28 +14,32 @@ PREHOOK: query: insert into table `aci/d_u/ami` 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@aci/d_u/ami POSTHOOK: query: insert into table `aci/d_u/ami` 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@aci/d_u/ami -POSTHOOK: Lineage: aci/d_u/ami.d?*de e EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: aci/d_u/ami.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: aci/d_u/ami.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: aci/d_u/ami.d?*de e SCRIPT [] +POSTHOOK: Lineage: aci/d_u/ami.i SCRIPT [] +POSTHOOK: Lineage: aci/d_u/ami.vc SCRIPT [] PREHOOK: query: insert into table `aci/d_u/ami` values (10, 119.23, 'and everywhere that mary went'), (65530, 823.19, 'the lamb was sure to go') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@aci/d_u/ami POSTHOOK: query: insert into table `aci/d_u/ami` values (10, 119.23, 'and everywhere that mary went'), (65530, 823.19, 'the lamb was sure to go') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@aci/d_u/ami -POSTHOOK: Lineage: aci/d_u/ami.d?*de e EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: aci/d_u/ami.i EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: aci/d_u/ami.vc EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: aci/d_u/ami.d?*de e SCRIPT [] +POSTHOOK: Lineage: aci/d_u/ami.i SCRIPT [] +POSTHOOK: Lineage: aci/d_u/ami.vc SCRIPT [] PREHOOK: query: select * from `aci/d_u/ami` order by `d?*de e` PREHOOK: type: QUERY PREHOOK: Input: default@aci/d_u/ami http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_acid3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_acid3.q.out b/ql/src/test/results/clientpositive/vector_acid3.q.out index bb4012e..46c82fc 100644 --- a/ql/src/test/results/clientpositive/vector_acid3.q.out +++ b/ql/src/test/results/clientpositive/vector_acid3.q.out @@ -12,11 +12,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@testacid1 PREHOOK: query: insert into table testacid1 values (1),(2),(3),(4) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@testacid1 POSTHOOK: query: insert into table testacid1 values (1),(2),(3),(4) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@testacid1 -POSTHOOK: Lineage: testacid1.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: testacid1.id SCRIPT [] hive.vectorized.execution.enabled=true PREHOOK: query: select count(1) from testacid1 PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_aggregate_without_gby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_aggregate_without_gby.q.out b/ql/src/test/results/clientpositive/vector_aggregate_without_gby.q.out index 79028b4..eab3b7a 100644 --- a/ql/src/test/results/clientpositive/vector_aggregate_without_gby.q.out +++ b/ql/src/test/results/clientpositive/vector_aggregate_without_gby.q.out @@ -16,6 +16,7 @@ values (6,20150314, '2015-03-14'), (7,20150404, '2015-04-04') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@testvec POSTHOOK: query: insert into table testvec values @@ -27,10 +28,11 @@ values (6,20150314, '2015-03-14'), (7,20150404, '2015-04-04') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@testvec -POSTHOOK: Lineage: testvec.dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: testvec.greg_dt SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: testvec.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: testvec.dt SCRIPT [] +POSTHOOK: Lineage: testvec.greg_dt SCRIPT [] +POSTHOOK: Lineage: testvec.id SCRIPT [] PREHOOK: query: explain vectorization detail select max(dt), max(greg_dt) from testvec where id=5 PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_bround.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_bround.q.out b/ql/src/test/results/clientpositive/vector_bround.q.out index 29fa6fa..a2b745a 100644 --- a/ql/src/test/results/clientpositive/vector_bround.q.out +++ b/ql/src/test/results/clientpositive/vector_bround.q.out @@ -17,6 +17,7 @@ values (2.51, 1.251), (3.51, 1.351) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test_vector_bround POSTHOOK: query: insert into table test_vector_bround values @@ -29,9 +30,10 @@ values (2.51, 1.251), (3.51, 1.351) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test_vector_bround -POSTHOOK: Lineage: test_vector_bround.v0 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: test_vector_bround.v1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: test_vector_bround.v0 SCRIPT [] +POSTHOOK: Lineage: test_vector_bround.v1 SCRIPT [] PREHOOK: query: explain vectorization detail select bround(v0), bround(v1, 1) from test_vector_bround PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_bucket.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_bucket.q.out b/ql/src/test/results/clientpositive/vector_bucket.q.out index 34977a0..b6ddf67 100644 --- a/ql/src/test/results/clientpositive/vector_bucket.q.out +++ b/ql/src/test/results/clientpositive/vector_bucket.q.out @@ -26,50 +26,40 @@ STAGE PLANS: Map Reduce Map Operator Tree: TableScan - alias: values__tmp__table__1 - Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE - TableScan Vectorization: - native: true + alias: _dummy_table + Row Limit Per Split: 1 + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator - expressions: tmp_values_col1 (type: string), tmp_values_col2 (type: string) - outputColumnNames: _col0, _col1 - Select Vectorization: - className: VectorSelectOperator - native: true - projectedOutputColumnNums: [0, 1] - Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Map-reduce partition columns: UDFToInteger(_col0) (type: int) - Reduce Sink Vectorization: - className: VectorReduceSinkOperator - native: false - nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true - nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Execution mode: vectorized + expressions: array(const struct(1,'one'),const struct(1,'one'),const struct(2,'two'),const struct(3,'three')) (type: array<struct<col1:int,col2:string>>) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 72 Basic stats: COMPLETE Column stats: COMPLETE + UDTF Operator + Statistics: Num rows: 1 Data size: 72 Basic stats: COMPLETE Column stats: COMPLETE + function name: inline + Select Operator + expressions: col1 (type: int), col2 (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE + Reduce Output Operator + sort order: + Map-reduce partition columns: _col0 (type: int) + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE + value expressions: _col0 (type: int), _col1 (type: string) Map Vectorization: - enabled: true - enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true - inputFormatFeatureSupport: [DECIMAL_64] - featureSupportInUse: [DECIMAL_64] - inputFileFormats: org.apache.hadoop.mapred.TextInputFormat - allNative: false - usesVectorUDFAdaptor: false - vectorized: true + enabled: false +#### A masked pattern was here #### Reduce Vectorization: enabled: false enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true enableConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false Reduce Operator Tree: Select Operator - expressions: UDFToInteger(VALUE._col0) (type: int), VALUE._col1 (type: string) + expressions: VALUE._col0 (type: int), VALUE._col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 260 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -100,12 +90,14 @@ POSTHOOK: Input: default@non_orc_table #### A masked pattern was here #### PREHOOK: query: insert into table non_orc_table values(1, 'one'),(1, 'one'), (2, 'two'),(3, 'three') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@non_orc_table POSTHOOK: query: insert into table non_orc_table values(1, 'one'),(1, 'one'), (2, 'two'),(3, 'three') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@non_orc_table -POSTHOOK: Lineage: non_orc_table.a EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: non_orc_table.b SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: non_orc_table.a SCRIPT [] +POSTHOOK: Lineage: non_orc_table.b SCRIPT [] PREHOOK: query: select a, b from non_orc_table order by a PREHOOK: type: QUERY PREHOOK: Input: default@non_orc_table http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_char_cast.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_char_cast.q.out b/ql/src/test/results/clientpositive/vector_char_cast.q.out index c836dd8..14b0d6b 100644 --- a/ql/src/test/results/clientpositive/vector_char_cast.q.out +++ b/ql/src/test/results/clientpositive/vector_char_cast.q.out @@ -8,11 +8,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@s1 PREHOOK: query: insert into table s1 values (1000),(1001),(1002),(1003),(1000) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@s1 POSTHOOK: query: insert into table s1 values (1000),(1001),(1002),(1003),(1000) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@s1 -POSTHOOK: Lineage: s1.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: s1.id SCRIPT [] PREHOOK: query: select count(1) from s1 where cast(id as char(4))='1000' PREHOOK: type: QUERY PREHOOK: Input: default@s1 http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_coalesce_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_coalesce_2.q.out b/ql/src/test/results/clientpositive/vector_coalesce_2.q.out index 9c40d2c..a5a7915 100644 --- a/ql/src/test/results/clientpositive/vector_coalesce_2.q.out +++ b/ql/src/test/results/clientpositive/vector_coalesce_2.q.out @@ -8,12 +8,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@str_str_orc PREHOOK: query: insert into table str_str_orc values (null, "X"), ("0", "X"), ("1", "X"), (null, "y") PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@str_str_orc POSTHOOK: query: insert into table str_str_orc values (null, "X"), ("0", "X"), ("1", "X"), (null, "y") POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@str_str_orc -POSTHOOK: Lineage: str_str_orc.str1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: str_str_orc.str2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: str_str_orc.str1 SCRIPT [] +POSTHOOK: Lineage: str_str_orc.str2 SCRIPT [] PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT str2, ROUND(sum(cast(COALESCE(str1, 0) as int))/60, 2) as result http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_coalesce_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_coalesce_3.q.out b/ql/src/test/results/clientpositive/vector_coalesce_3.q.out index 0e75593..0e602f0 100644 --- a/ql/src/test/results/clientpositive/vector_coalesce_3.q.out +++ b/ql/src/test/results/clientpositive/vector_coalesce_3.q.out @@ -16,19 +16,23 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@test_2 PREHOOK: query: INSERT INTO test_1 VALUES (3,1),(2,2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test_1 POSTHOOK: query: INSERT INTO test_1 VALUES (3,1),(2,2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test_1 -POSTHOOK: Lineage: test_1.attr EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: test_1.member EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: test_1.attr SCRIPT [] +POSTHOOK: Lineage: test_1.member SCRIPT [] PREHOOK: query: INSERT INTO test_2 VALUES (1),(2),(3),(4) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test_2 POSTHOOK: query: INSERT INTO test_2 VALUES (1),(2),(3),(4) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test_2 -POSTHOOK: Lineage: test_2.member EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: test_2.member SCRIPT [] PREHOOK: query: EXPLAIN SELECT m.member, (CASE WHEN COALESCE(n.attr, 5)>1 THEN n.attr END) AS attr FROM test_2 m LEFT JOIN test_1 n ON m.member = n.member http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_complex_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_complex_join.q.out b/ql/src/test/results/clientpositive/vector_complex_join.q.out index 2832096..487ba5b 100644 --- a/ql/src/test/results/clientpositive/vector_complex_join.q.out +++ b/ql/src/test/results/clientpositive/vector_complex_join.q.out @@ -165,12 +165,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@test2b PREHOOK: query: INSERT OVERWRITE TABLE test2b VALUES (2), (3), (4) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test2b POSTHOOK: query: INSERT OVERWRITE TABLE test2b VALUES (2), (3), (4) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test2b -POSTHOOK: Lineage: test2b.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 +POSTHOOK: Lineage: test2b.a SCRIPT [] +col1 PREHOOK: query: explain vectorization expression select * from test2b join test2a on test2b.a = test2a.a[1] PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_const.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_const.q.out b/ql/src/test/results/clientpositive/vector_const.q.out index d25673d..a2f3d9e 100644 --- a/ql/src/test/results/clientpositive/vector_const.q.out +++ b/ql/src/test/results/clientpositive/vector_const.q.out @@ -8,11 +8,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@varchar_const_1 PREHOOK: query: INSERT INTO varchar_const_1 values(42) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@varchar_const_1 POSTHOOK: query: INSERT INTO varchar_const_1 values(42) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@varchar_const_1 -POSTHOOK: Lineage: varchar_const_1.c1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: varchar_const_1.c1 SCRIPT [] PREHOOK: query: EXPLAIN SELECT CONCAT(CAST('F' AS CHAR(2)), CAST('F' AS VARCHAR(2))) FROM VARCHAR_CONST_1 PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_custom_udf_configure.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_custom_udf_configure.q.out b/ql/src/test/results/clientpositive/vector_custom_udf_configure.q.out index d73d5d8..98e69a7 100644 --- a/ql/src/test/results/clientpositive/vector_custom_udf_configure.q.out +++ b/ql/src/test/results/clientpositive/vector_custom_udf_configure.q.out @@ -14,12 +14,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@testorc1 PREHOOK: query: insert into table testorc1 values(1, 'a1'), (2,'a2') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@testorc1 POSTHOOK: query: insert into table testorc1 values(1, 'a1'), (2,'a2') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@testorc1 -POSTHOOK: Lineage: testorc1.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: testorc1.name SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: testorc1.id SCRIPT [] +POSTHOOK: Lineage: testorc1.name SCRIPT [] PREHOOK: query: explain select id, UDFHelloTest(name) from testorc1 PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_decimal_round.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_round.q.out b/ql/src/test/results/clientpositive/vector_decimal_round.q.out index dd32a51..79c2cd5 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_round.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_round.q.out @@ -14,11 +14,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@decimal_tbl_txt PREHOOK: query: insert into table decimal_tbl_txt values(101) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@decimal_tbl_txt POSTHOOK: query: insert into table decimal_tbl_txt values(101) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@decimal_tbl_txt -POSTHOOK: Lineage: decimal_tbl_txt.dec EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: decimal_tbl_txt.dec SCRIPT [] PREHOOK: query: select * from decimal_tbl_txt PREHOOK: type: QUERY PREHOOK: Input: default@decimal_tbl_txt @@ -222,11 +224,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@decimal_tbl_rc PREHOOK: query: insert into table decimal_tbl_rc values(101) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@decimal_tbl_rc POSTHOOK: query: insert into table decimal_tbl_rc values(101) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@decimal_tbl_rc -POSTHOOK: Lineage: decimal_tbl_rc.dec EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: decimal_tbl_rc.dec SCRIPT [] PREHOOK: query: select * from decimal_tbl_rc PREHOOK: type: QUERY PREHOOK: Input: default@decimal_tbl_rc @@ -430,11 +434,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@decimal_tbl_orc PREHOOK: query: insert into table decimal_tbl_orc values(101) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@decimal_tbl_orc POSTHOOK: query: insert into table decimal_tbl_orc values(101) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@decimal_tbl_orc -POSTHOOK: Lineage: decimal_tbl_orc.dec EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: decimal_tbl_orc.dec SCRIPT [] PREHOOK: query: select * from decimal_tbl_orc PREHOOK: type: QUERY PREHOOK: Input: default@decimal_tbl_orc http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out b/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out index f6121a2..76dd8ab 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out @@ -10,11 +10,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@decimal_tbl_1_orc PREHOOK: query: insert into table decimal_tbl_1_orc values(55555) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@decimal_tbl_1_orc POSTHOOK: query: insert into table decimal_tbl_1_orc values(55555) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@decimal_tbl_1_orc -POSTHOOK: Lineage: decimal_tbl_1_orc.dec EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: decimal_tbl_1_orc.dec SCRIPT [] PREHOOK: query: select * from decimal_tbl_1_orc PREHOOK: type: QUERY PREHOOK: Input: default@decimal_tbl_1_orc @@ -143,12 +145,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@decimal_tbl_2_orc PREHOOK: query: insert into table decimal_tbl_2_orc values(125.315, -125.315) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@decimal_tbl_2_orc POSTHOOK: query: insert into table decimal_tbl_2_orc values(125.315, -125.315) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@decimal_tbl_2_orc -POSTHOOK: Lineage: decimal_tbl_2_orc.neg EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: decimal_tbl_2_orc.pos EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: decimal_tbl_2_orc.neg SCRIPT [] +POSTHOOK: Lineage: decimal_tbl_2_orc.pos SCRIPT [] PREHOOK: query: select * from decimal_tbl_2_orc PREHOOK: type: QUERY PREHOOK: Input: default@decimal_tbl_2_orc @@ -289,11 +293,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@decimal_tbl_3_orc PREHOOK: query: insert into table decimal_tbl_3_orc values(3.141592653589793) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@decimal_tbl_3_orc POSTHOOK: query: insert into table decimal_tbl_3_orc values(3.141592653589793) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@decimal_tbl_3_orc -POSTHOOK: Lineage: decimal_tbl_3_orc.dec EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: decimal_tbl_3_orc.dec SCRIPT [] PREHOOK: query: select * from decimal_tbl_3_orc PREHOOK: type: QUERY PREHOOK: Input: default@decimal_tbl_3_orc @@ -478,12 +484,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@decimal_tbl_4_orc PREHOOK: query: insert into table decimal_tbl_4_orc values(1809242.3151111344, -1809242.3151111344) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@decimal_tbl_4_orc POSTHOOK: query: insert into table decimal_tbl_4_orc values(1809242.3151111344, -1809242.3151111344) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@decimal_tbl_4_orc -POSTHOOK: Lineage: decimal_tbl_4_orc.neg EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: decimal_tbl_4_orc.pos EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: decimal_tbl_4_orc.neg SCRIPT [] +POSTHOOK: Lineage: decimal_tbl_4_orc.pos SCRIPT [] PREHOOK: query: select * from decimal_tbl_4_orc PREHOOK: type: QUERY PREHOOK: Input: default@decimal_tbl_4_orc http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_gather_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_gather_stats.q.out b/ql/src/test/results/clientpositive/vector_gather_stats.q.out index cf9bc85..0c87383 100644 --- a/ql/src/test/results/clientpositive/vector_gather_stats.q.out +++ b/ql/src/test/results/clientpositive/vector_gather_stats.q.out @@ -43,18 +43,20 @@ POSTHOOK: Output: default@cd POSTHOOK: Output: default@cd@cd_education_status=Primary PREHOOK: query: insert into table cd partition (cd_education_status='Primary') values (1, 'M', 'M', 500, 'Good', 0, 0, 0) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@cd@cd_education_status=Primary POSTHOOK: query: insert into table cd partition (cd_education_status='Primary') values (1, 'M', 'M', 500, 'Good', 0, 0, 0) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@cd@cd_education_status=Primary -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_credit_rating SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_demo_sk EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_dep_college_count EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ] -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_dep_count EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_dep_employed_count EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_gender SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_marital_status SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_purchase_estimate EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_credit_rating SCRIPT [] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_demo_sk SCRIPT [] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_dep_college_count SCRIPT [] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_dep_count SCRIPT [] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_dep_employed_count SCRIPT [] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_gender SCRIPT [] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_marital_status SCRIPT [] +POSTHOOK: Lineage: cd PARTITION(cd_education_status=Primary).cd_purchase_estimate SCRIPT [] PREHOOK: query: explain vectorization detail analyze table cd partition (cd_education_status) compute statistics PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_if_expr_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_if_expr_2.q.out b/ql/src/test/results/clientpositive/vector_if_expr_2.q.out index 40dc259..fe4f77c 100644 --- a/ql/src/test/results/clientpositive/vector_if_expr_2.q.out +++ b/ql/src/test/results/clientpositive/vector_if_expr_2.q.out @@ -12,12 +12,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@foo PREHOOK: query: insert into foo values(1,1),(2,NULL),(3,1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@foo POSTHOOK: query: insert into foo values(1,1),(2,NULL),(3,1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@foo -POSTHOOK: Lineage: foo.x EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: foo.y EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: foo.x SCRIPT [] +POSTHOOK: Lineage: foo.y SCRIPT [] PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION select x, IF(x > 0,y,0) from foo order by x PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_join_part_col_char.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_join_part_col_char.q.out b/ql/src/test/results/clientpositive/vector_join_part_col_char.q.out index 16fdeeb..40dd181 100644 --- a/ql/src/test/results/clientpositive/vector_join_part_col_char.q.out +++ b/ql/src/test/results/clientpositive/vector_join_part_col_char.q.out @@ -16,13 +16,15 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@studenttab PREHOOK: query: insert into table studenttab values ('calvin garcia',56,2.50), ('oscar miller',66,3.00), ('(yuri xylophone',30,2.74),('alice underhill',46,3.50) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@studenttab POSTHOOK: query: insert into table studenttab values ('calvin garcia',56,2.50), ('oscar miller',66,3.00), ('(yuri xylophone',30,2.74),('alice underhill',46,3.50) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@studenttab -POSTHOOK: Lineage: studenttab.age EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: studenttab.gpa EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: studenttab.name SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: studenttab.age SCRIPT [] +POSTHOOK: Lineage: studenttab.gpa SCRIPT [] +POSTHOOK: Lineage: studenttab.name SCRIPT [] PREHOOK: query: create table char_tbl1(name string, age int) partitioned by(gpa char(50)) stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_like_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_like_2.q.out b/ql/src/test/results/clientpositive/vector_like_2.q.out index eef9094..26ff792 100644 --- a/ql/src/test/results/clientpositive/vector_like_2.q.out +++ b/ql/src/test/results/clientpositive/vector_like_2.q.out @@ -12,11 +12,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@foo PREHOOK: query: insert into foo values("some foo"),("some bar"),(null) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@foo POSTHOOK: query: insert into foo values("some foo"),("some bar"),(null) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@foo -POSTHOOK: Lineage: foo.a SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: foo.a SCRIPT [] PREHOOK: query: EXPLAIN VECTORIZATION DETAIL select a, a like "%bar" from foo order by a PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_null_projection.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_null_projection.q.out b/ql/src/test/results/clientpositive/vector_null_projection.q.out index f4daa1d..8e491ff 100644 --- a/ql/src/test/results/clientpositive/vector_null_projection.q.out +++ b/ql/src/test/results/clientpositive/vector_null_projection.q.out @@ -16,18 +16,22 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@b PREHOOK: query: insert into table a values('aaa') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@a POSTHOOK: query: insert into table a values('aaa') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@a -POSTHOOK: Lineage: a.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: a.s SCRIPT [] PREHOOK: query: insert into table b values('aaa') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@b POSTHOOK: query: insert into table b values('aaa') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@b -POSTHOOK: Lineage: b.s SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: b.s SCRIPT [] PREHOOK: query: explain vectorization expression select NULL from a PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_order_null.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_order_null.q.out b/ql/src/test/results/clientpositive/vector_order_null.q.out index 3417eb6..c50e275 100644 --- a/ql/src/test/results/clientpositive/vector_order_null.q.out +++ b/ql/src/test/results/clientpositive/vector_order_null.q.out @@ -8,58 +8,70 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@src_null PREHOOK: query: insert into src_null values (1, 'A') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@src_null POSTHOOK: query: insert into src_null values (1, 'A') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@src_null -POSTHOOK: Lineage: src_null.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: src_null.b SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -_col0 _col1 +POSTHOOK: Lineage: src_null.a SCRIPT [] +POSTHOOK: Lineage: src_null.b SCRIPT [] +col1 col2 PREHOOK: query: insert into src_null values (null, null) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@src_null POSTHOOK: query: insert into src_null values (null, null) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@src_null -POSTHOOK: Lineage: src_null.a EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: src_null.b SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: src_null.a EXPRESSION [] +POSTHOOK: Lineage: src_null.b EXPRESSION [] _col0 _col1 PREHOOK: query: insert into src_null values (3, null) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@src_null POSTHOOK: query: insert into src_null values (3, null) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@src_null -POSTHOOK: Lineage: src_null.a EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: src_null.b SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: src_null.a SCRIPT [] +POSTHOOK: Lineage: src_null.b EXPRESSION [] _col0 _col1 PREHOOK: query: insert into src_null values (2, null) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@src_null POSTHOOK: query: insert into src_null values (2, null) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@src_null -POSTHOOK: Lineage: src_null.a EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: src_null.b SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: src_null.a SCRIPT [] +POSTHOOK: Lineage: src_null.b EXPRESSION [] _col0 _col1 PREHOOK: query: insert into src_null values (2, 'A') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@src_null POSTHOOK: query: insert into src_null values (2, 'A') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@src_null -POSTHOOK: Lineage: src_null.a EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: src_null.b SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -_col0 _col1 +POSTHOOK: Lineage: src_null.a SCRIPT [] +POSTHOOK: Lineage: src_null.b SCRIPT [] +col1 col2 PREHOOK: query: insert into src_null values (2, 'B') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@src_null POSTHOOK: query: insert into src_null values (2, 'B') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@src_null -POSTHOOK: Lineage: src_null.a EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: src_null.b SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -_col0 _col1 +POSTHOOK: Lineage: src_null.a SCRIPT [] +POSTHOOK: Lineage: src_null.b SCRIPT [] +col1 col2 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT x.* FROM src_null x ORDER BY a asc, b asc PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_outer_join0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_outer_join0.q.out b/ql/src/test/results/clientpositive/vector_outer_join0.q.out index 603571d..de6c894 100644 --- a/ql/src/test/results/clientpositive/vector_outer_join0.q.out +++ b/ql/src/test/results/clientpositive/vector_outer_join0.q.out @@ -16,20 +16,24 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@orc_table_2 PREHOOK: query: insert into table orc_table_1 values ("<null1>", null),("one", 1),("one", 1),("two", 2),("three", 3),("<null2>", null) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@orc_table_1 POSTHOOK: query: insert into table orc_table_1 values ("<null1>", null),("one", 1),("one", 1),("two", 2),("three", 3),("<null2>", null) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@orc_table_1 -POSTHOOK: Lineage: orc_table_1.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: orc_table_1.v1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: orc_table_1.a SCRIPT [] +POSTHOOK: Lineage: orc_table_1.v1 SCRIPT [] PREHOOK: query: insert into table orc_table_2 values (0, "ZERO"),(2, "TWO"), (3, "THREE"),(null, "<NULL1>"),(4, "FOUR"),(null, "<NULL2>") PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@orc_table_2 POSTHOOK: query: insert into table orc_table_2 values (0, "ZERO"),(2, "TWO"), (3, "THREE"),(null, "<NULL1>"),(4, "FOUR"),(null, "<NULL2>") POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@orc_table_2 -POSTHOOK: Lineage: orc_table_2.c EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: orc_table_2.v2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: orc_table_2.c SCRIPT [] +POSTHOOK: Lineage: orc_table_2.v2 SCRIPT [] PREHOOK: query: select * from orc_table_1 PREHOOK: type: QUERY PREHOOK: Input: default@orc_table_1 http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_reduce_groupby_duplicate_cols.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_reduce_groupby_duplicate_cols.q.out b/ql/src/test/results/clientpositive/vector_reduce_groupby_duplicate_cols.q.out index 9432a66..7ccbf8f 100644 --- a/ql/src/test/results/clientpositive/vector_reduce_groupby_duplicate_cols.q.out +++ b/ql/src/test/results/clientpositive/vector_reduce_groupby_duplicate_cols.q.out @@ -8,13 +8,15 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@demo PREHOOK: query: insert into table demo values (1, 2) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@demo POSTHOOK: query: insert into table demo values (1, 2) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@demo -POSTHOOK: Lineage: demo.one EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: demo.two EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -_col0 _col1 +POSTHOOK: Lineage: demo.one SCRIPT [] +POSTHOOK: Lineage: demo.two SCRIPT [] +col1 col2 PREHOOK: query: explain vectorization detail select one as one_0, two, one as one_1 from demo a http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_string_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_string_decimal.q.out b/ql/src/test/results/clientpositive/vector_string_decimal.q.out index edd8cdd..59b0588 100644 --- a/ql/src/test/results/clientpositive/vector_string_decimal.q.out +++ b/ql/src/test/results/clientpositive/vector_string_decimal.q.out @@ -24,11 +24,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@staging PREHOOK: query: insert into staging values (34324.0), (100000000.0), (200000000.0), (300000000.0) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@staging POSTHOOK: query: insert into staging values (34324.0), (100000000.0), (200000000.0), (300000000.0) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@staging -POSTHOOK: Lineage: staging.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: staging.id SCRIPT [] PREHOOK: query: insert overwrite table orc_decimal select id from staging PREHOOK: type: QUERY PREHOOK: Input: default@staging http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_struct_in.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_struct_in.q.out b/ql/src/test/results/clientpositive/vector_struct_in.q.out index 43c4ac4..773908b 100644 --- a/ql/src/test/results/clientpositive/vector_struct_in.q.out +++ b/ql/src/test/results/clientpositive/vector_struct_in.q.out @@ -8,12 +8,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@test_1 PREHOOK: query: insert into table test_1 values ('one','1'), ('seven','1') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test_1 POSTHOOK: query: insert into table test_1 values ('one','1'), ('seven','1') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test_1 -POSTHOOK: Lineage: test_1.id SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: test_1.lineid SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: test_1.id SCRIPT [] +POSTHOOK: Lineage: test_1.lineid SCRIPT [] PREHOOK: query: explain vectorization expression select * from test_1 where struct(`id`, `lineid`) IN ( @@ -256,12 +258,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@test_2 PREHOOK: query: insert into table test_2 values (1,1), (7,1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test_2 POSTHOOK: query: insert into table test_2 values (1,1), (7,1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test_2 -POSTHOOK: Lineage: test_2.id EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: test_2.lineid EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: test_2.id SCRIPT [] +POSTHOOK: Lineage: test_2.lineid SCRIPT [] PREHOOK: query: explain vectorization expression select * from test_2 where struct(`id`, `lineid`) IN ( @@ -504,12 +508,14 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@test_3 PREHOOK: query: insert into table test_3 values ('one',1), ('seven',1) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test_3 POSTHOOK: query: insert into table test_3 values ('one',1), ('seven',1) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test_3 -POSTHOOK: Lineage: test_3.id SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: test_3.lineid EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: test_3.id SCRIPT [] +POSTHOOK: Lineage: test_3.lineid SCRIPT [] PREHOOK: query: explain vectorization expression select * from test_3 where struct(`id`, `lineid`) IN ( @@ -752,13 +758,15 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@test_4 PREHOOK: query: insert into table test_4 values (1, "b", 1.5), (1, "a", 0.5), (2, "b", 1.5) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@test_4 POSTHOOK: query: insert into table test_4 values (1, "b", 1.5), (1, "a", 0.5), (2, "b", 1.5) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@test_4 -POSTHOOK: Lineage: test_4.my_bigint EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: test_4.my_double EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: test_4.my_string SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: test_4.my_bigint SCRIPT [] +POSTHOOK: Lineage: test_4.my_double SCRIPT [] +POSTHOOK: Lineage: test_4.my_string SCRIPT [] PREHOOK: query: explain vectorization expression select * from test_4 where struct(`my_bigint`, `my_string`, `my_double`) IN ( http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_udf2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_udf2.q.out b/ql/src/test/results/clientpositive/vector_udf2.q.out index 9ae0e8d..222a901 100644 --- a/ql/src/test/results/clientpositive/vector_udf2.q.out +++ b/ql/src/test/results/clientpositive/vector_udf2.q.out @@ -144,11 +144,13 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@HIVE_14349 PREHOOK: query: insert into HIVE_14349 values('XYZa'), ('badXYZa') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@hive_14349 POSTHOOK: query: insert into HIVE_14349 values('XYZa'), ('badXYZa') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@hive_14349 -POSTHOOK: Lineage: hive_14349.a SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: hive_14349.a SCRIPT [] PREHOOK: query: select * from HIVE_14349 where a LIKE 'XYZ%a%' PREHOOK: type: QUERY PREHOOK: Input: default@hive_14349 @@ -160,11 +162,13 @@ POSTHOOK: Input: default@hive_14349 XYZa PREHOOK: query: insert into HIVE_14349 values ('XYZab'), ('XYZabBAD'), ('badXYZab'), ('badXYZabc') PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@hive_14349 POSTHOOK: query: insert into HIVE_14349 values ('XYZab'), ('XYZabBAD'), ('badXYZab'), ('badXYZabc') POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@hive_14349 -POSTHOOK: Lineage: hive_14349.a SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: hive_14349.a SCRIPT [] PREHOOK: query: select * from HIVE_14349 where a LIKE 'XYZ%a_' PREHOOK: type: QUERY PREHOOK: Input: default@hive_14349 http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_udf_character_length.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_udf_character_length.q.out b/ql/src/test/results/clientpositive/vector_udf_character_length.q.out index 2960cd6..23bb5fb 100644 --- a/ql/src/test/results/clientpositive/vector_udf_character_length.q.out +++ b/ql/src/test/results/clientpositive/vector_udf_character_length.q.out @@ -194,11 +194,13 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@dest1 PREHOOK: query: INSERT INTO dest1 VALUES(NULL) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@dest1 POSTHOOK: query: INSERT INTO dest1 VALUES(NULL) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@dest1 -POSTHOOK: Lineage: dest1.name SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: dest1.name EXPRESSION [] PREHOOK: query: CREATE TABLE dest2 STORED AS ORC AS SELECT * FROM dest1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@dest1 @@ -252,8 +254,8 @@ POSTHOOK: query: SELECT character_length(dest2.name) FROM dest2 POSTHOOK: type: QUERY POSTHOOK: Input: default@dest2 #### A masked pattern was here #### -2 NULL +2 PREHOOK: query: EXPLAIN SELECT char_length(dest2.name) FROM dest2 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT char_length(dest2.name) FROM dest2 @@ -296,8 +298,8 @@ POSTHOOK: query: SELECT char_length(dest2.name) FROM dest2 POSTHOOK: type: QUERY POSTHOOK: Input: default@dest2 #### A masked pattern was here #### -2 NULL +2 PREHOOK: query: DROP TABLE dest1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@dest1 http://git-wip-us.apache.org/repos/asf/hive/blob/7e64114d/ql/src/test/results/clientpositive/vector_udf_octet_length.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_udf_octet_length.q.out b/ql/src/test/results/clientpositive/vector_udf_octet_length.q.out index 46f5d65..d3b12c0 100644 --- a/ql/src/test/results/clientpositive/vector_udf_octet_length.q.out +++ b/ql/src/test/results/clientpositive/vector_udf_octet_length.q.out @@ -177,11 +177,13 @@ POSTHOOK: type: LOAD POSTHOOK: Output: default@dest1 PREHOOK: query: INSERT INTO dest1 VALUES(NULL) PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table PREHOOK: Output: default@dest1 POSTHOOK: query: INSERT INTO dest1 VALUES(NULL) POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table POSTHOOK: Output: default@dest1 -POSTHOOK: Lineage: dest1.name SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: dest1.name EXPRESSION [] PREHOOK: query: CREATE TABLE dest2 STORED AS ORC AS SELECT * FROM dest1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@dest1 @@ -235,8 +237,8 @@ POSTHOOK: query: SELECT octet_length(dest2.name) FROM dest2 POSTHOOK: type: QUERY POSTHOOK: Input: default@dest2 #### A masked pattern was here #### -6 NULL +6 PREHOOK: query: DROP TABLE dest1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@dest1