HIVE-19102: Vectorization: Suppress known Q file bugs (Matt McCline, reviewed by Teddy Choi)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/1417370c Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/1417370c Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/1417370c Branch: refs/heads/master Commit: 1417370ca4bd51dcba6e4e44a04a9713fe53eda8 Parents: 2fb7695 Author: Matt McCline <mmccl...@hortonworks.com> Authored: Fri Apr 6 18:44:04 2018 -0500 Committer: Matt McCline <mmccl...@hortonworks.com> Committed: Fri Apr 6 18:44:04 2018 -0500 ---------------------------------------------------------------------- .../clientpositive/udf_example_arraymapstruct.q | 4 + .../queries/clientpositive/delete_orig_table.q | 4 + .../test/queries/clientpositive/escape_crlf.q | 4 + .../queries/clientpositive/input_lazyserde.q | 4 + .../queries/clientpositive/input_lazyserde2.q | 4 + .../clientpositive/nested_column_pruning.q | 4 + .../offset_limit_global_optimizer.q | 32 +- .../parquet_map_of_arrays_of_ints.q | 4 + .../clientpositive/parquet_map_of_maps.q | 4 + .../clientpositive/parquet_nested_complex.q | 4 + .../clientpositive/parquet_ppd_decimal.q | 4 + .../queries/clientpositive/udf_context_aware.q | 1 + .../queries/clientpositive/vector_data_types.q | 2 +- .../clientpositive/vector_left_outer_join2.q | 2 +- .../test/queries/clientpositive/vector_udf3.q | 1 + ...insert_overwrite_local_directory_1_bug.q.out | 71 + .../clientpositive/llap/vector_data_types.q.out | 8 +- .../llap/vector_left_outer_join2.q.out | 8 +- .../offset_limit_global_optimizer.q.out | 3376 ++++++++++-------- .../spark/vector_data_types.q.out | 8 +- .../clientpositive/vector_data_types.q.out | 8 +- .../vector_left_outer_join2.q.out | 8 +- 22 files changed, 2036 insertions(+), 1529 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/contrib/src/test/queries/clientpositive/udf_example_arraymapstruct.q ---------------------------------------------------------------------- diff --git a/contrib/src/test/queries/clientpositive/udf_example_arraymapstruct.q b/contrib/src/test/queries/clientpositive/udf_example_arraymapstruct.q index 2c36520..a8ab751 100644 --- a/contrib/src/test/queries/clientpositive/udf_example_arraymapstruct.q +++ b/contrib/src/test/queries/clientpositive/udf_example_arraymapstruct.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19110. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=disable; + add jar ${system:maven.local.repository}/org/apache/hive/hive-contrib/${system:hive.version}/hive-contrib-${system:hive.version}.jar; CREATE TEMPORARY FUNCTION example_arraysum AS 'org.apache.hadoop.hive.contrib.udf.example.UDFExampleArraySum'; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/delete_orig_table.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/delete_orig_table.q b/ql/src/test/queries/clientpositive/delete_orig_table.q index 81c7cba..c73b21c 100644 --- a/ql/src/test/queries/clientpositive/delete_orig_table.q +++ b/ql/src/test/queries/clientpositive/delete_orig_table.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19109. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=disable; + set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/escape_crlf.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/escape_crlf.q b/ql/src/test/queries/clientpositive/escape_crlf.q index 2d6e05e..46c3605 100644 --- a/ql/src/test/queries/clientpositive/escape_crlf.q +++ b/ql/src/test/queries/clientpositive/escape_crlf.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19118. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=disable; + DROP TABLE IF EXISTS base_tab; CREATE TABLE base_tab(a STRING, b STRING) ROW FORMAT DELIMITED http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/input_lazyserde.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/input_lazyserde.q b/ql/src/test/queries/clientpositive/input_lazyserde.q index c29cb82..c37e48b 100644 --- a/ql/src/test/queries/clientpositive/input_lazyserde.q +++ b/ql/src/test/queries/clientpositive/input_lazyserde.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19088. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=none; + -- SORT_QUERY_RESULTS DROP TABLE dest1; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/input_lazyserde2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/input_lazyserde2.q b/ql/src/test/queries/clientpositive/input_lazyserde2.q index 0f58907..2a2cf06 100644 --- a/ql/src/test/queries/clientpositive/input_lazyserde2.q +++ b/ql/src/test/queries/clientpositive/input_lazyserde2.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19088. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=none; + -- SORT_QUERY_RESULTS DROP TABLE dest1; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/nested_column_pruning.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/nested_column_pruning.q b/ql/src/test/queries/clientpositive/nested_column_pruning.q index aaadebd..ab5e16b 100644 --- a/ql/src/test/queries/clientpositive/nested_column_pruning.q +++ b/ql/src/test/queries/clientpositive/nested_column_pruning.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19016. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=none; + set hive.fetch.task.conversion = none; set hive.exec.dynamic.partition.mode = nonstrict; set hive.strict.checks.cartesian.product=false; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/offset_limit_global_optimizer.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/offset_limit_global_optimizer.q b/ql/src/test/queries/clientpositive/offset_limit_global_optimizer.q index 5ddb9a6..8e08fbd 100644 --- a/ql/src/test/queries/clientpositive/offset_limit_global_optimizer.q +++ b/ql/src/test/queries/clientpositive/offset_limit_global_optimizer.q @@ -3,43 +3,43 @@ set hive.limit.row.max.size=12; set hive.mapred.mode=nonstrict; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 400,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 400,10; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 400,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 400,10; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,10; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,10; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,20; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,20; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,20; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,20; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,600; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,600; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,600; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,600; set hive.cbo.enable=false; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 400,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 400,10; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 400,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 400,10; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,10; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,10; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,10; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,20; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,20; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,20; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,20; EXPLAIN EXTENDED -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,600; +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,600; -SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,600; \ No newline at end of file +SELECT srcpart.key, substr(srcpart.value,5) as csubstr, ds, hr FROM srcpart ORDER BY srcpart.key, csubstr, ds, hr LIMIT 490,600; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q b/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q index 8517848..87b9a00 100644 --- a/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q +++ b/ql/src/test/queries/clientpositive/parquet_map_of_arrays_of_ints.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19015. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=none; + -- this test reads and writes a parquet file with a map of arrays of ints -- validates PARQUET-26 is fixed http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/parquet_map_of_maps.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_map_of_maps.q b/ql/src/test/queries/clientpositive/parquet_map_of_maps.q index 4289f37..8afd26d 100644 --- a/ql/src/test/queries/clientpositive/parquet_map_of_maps.q +++ b/ql/src/test/queries/clientpositive/parquet_map_of_maps.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19015. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=none; + -- this test reads and writes a parquet file with a map of maps CREATE TABLE parquet_map_of_maps ( http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/parquet_nested_complex.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_nested_complex.q b/ql/src/test/queries/clientpositive/parquet_nested_complex.q index 9ada66f..717e16f 100644 --- a/ql/src/test/queries/clientpositive/parquet_nested_complex.q +++ b/ql/src/test/queries/clientpositive/parquet_nested_complex.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19016. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=none; + -- start with the original nestedcomplex test create table nestedcomplex ( http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q b/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q index ff883db..ade49a3 100644 --- a/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q +++ b/ql/src/test/queries/clientpositive/parquet_ppd_decimal.q @@ -1,3 +1,7 @@ +-- Suppress vectorization due to known bug. See HIVE-19108. +set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=disable; + SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; SET mapred.min.split.size=1000; SET mapred.max.split.size=5000; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/udf_context_aware.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/udf_context_aware.q b/ql/src/test/queries/clientpositive/udf_context_aware.q index b12c213..bfbc73f 100644 --- a/ql/src/test/queries/clientpositive/udf_context_aware.q +++ b/ql/src/test/queries/clientpositive/udf_context_aware.q @@ -1,4 +1,5 @@ SET hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=disable; create temporary function counter as 'org.apache.hadoop.hive.ql.udf.generic.DummyContextUDF'; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/vector_data_types.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/vector_data_types.q b/ql/src/test/queries/clientpositive/vector_data_types.q index b796e71..41146d7 100644 --- a/ql/src/test/queries/clientpositive/vector_data_types.q +++ b/ql/src/test/queries/clientpositive/vector_data_types.q @@ -42,7 +42,7 @@ insert into over1korc values (NULL, NULL,NULL, NULL,NULL, NULL,NULL, NULL,NULL, SET hive.vectorized.execution.enabled=false; -EXPLAIN VECTORIZATION EXPRESSION SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc ORDER BY t, si, i LIMIT 20; +EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc ORDER BY t, si, i LIMIT 20; SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc ORDER BY t, si, i LIMIT 20; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/vector_left_outer_join2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/vector_left_outer_join2.q b/ql/src/test/queries/clientpositive/vector_left_outer_join2.q index ccceb36..3e5ec7e 100644 --- a/ql/src/test/queries/clientpositive/vector_left_outer_join2.q +++ b/ql/src/test/queries/clientpositive/vector_left_outer_join2.q @@ -27,7 +27,7 @@ select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left out set hive.vectorized.execution.enabled=false; set hive.mapjoin.hybridgrace.hashtable=true; -explain vectorization expression +explain select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ); select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ); http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/queries/clientpositive/vector_udf3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/vector_udf3.q b/ql/src/test/queries/clientpositive/vector_udf3.q index bc3a5e1..bfaa2e7 100644 --- a/ql/src/test/queries/clientpositive/vector_udf3.q +++ b/ql/src/test/queries/clientpositive/vector_udf3.q @@ -10,5 +10,6 @@ EXPLAIN VECTORIZATION EXPRESSION SELECT rot13(cstring1) from alltypesorc; SELECT cstring1, rot13(cstring1) from alltypesorc order by cstring1 desc limit 10; set hive.vectorized.execution.enabled=false; +set hive.test.vectorized.execution.enabled.override=disable; SELECT cstring1, rot13(cstring1) from alltypesorc order by cstring1 desc limit 10; http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out b/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out new file mode 100644 index 0000000..502404d --- /dev/null +++ b/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out @@ -0,0 +1,71 @@ +PREHOOK: query: create table map_table (foo STRING , bar MAP<STRING, STRING>) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY '\t' +COLLECTION ITEMS TERMINATED BY ',' +MAP KEYS TERMINATED BY ':' +STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@map_table +POSTHOOK: query: create table map_table (foo STRING , bar MAP<STRING, STRING>) +ROW FORMAT DELIMITED +FIELDS TERMINATED BY '\t' +COLLECTION ITEMS TERMINATED BY ',' +MAP KEYS TERMINATED BY ':' +STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@map_table +PREHOOK: query: load data local inpath "../../data/files/map_table.txt" overwrite into table map_table +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@map_table +POSTHOOK: query: load data local inpath "../../data/files/map_table.txt" overwrite into table map_table +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@map_table +PREHOOK: query: explain +select * from map_table +PREHOOK: type: QUERY +POSTHOOK: query: explain +select * from map_table +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: map_table + Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: foo (type: string), bar (type: map<string,string>) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select * from map_table +PREHOOK: type: QUERY +PREHOOK: Input: default@map_table +#### A masked pattern was here #### +POSTHOOK: query: select * from map_table +POSTHOOK: type: QUERY +POSTHOOK: Input: default@map_table +#### A masked pattern was here #### +foo1 {"k1":"v1","k2":"v2","k3":"v3"} +foo2 {"k21":"v21","k22":"v22","k31":"v31"} http://git-wip-us.apache.org/repos/asf/hive/blob/1417370c/ql/src/test/results/clientpositive/llap/vector_data_types.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_data_types.q.out b/ql/src/test/results/clientpositive/llap/vector_data_types.q.out index 961261d..8dd959e 100644 --- a/ql/src/test/results/clientpositive/llap/vector_data_types.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_data_types.q.out @@ -114,14 +114,10 @@ POSTHOOK: Lineage: over1korc.s EXPRESSION [] POSTHOOK: Lineage: over1korc.si EXPRESSION [] POSTHOOK: Lineage: over1korc.t EXPRESSION [] POSTHOOK: Lineage: over1korc.ts EXPRESSION [] -PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc ORDER BY t, si, i LIMIT 20 +PREHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc ORDER BY t, si, i LIMIT 20 PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc ORDER BY t, si, i LIMIT 20 +POSTHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc ORDER BY t, si, i LIMIT 20 POSTHOOK: type: QUERY -PLAN VECTORIZATION: - enabled: false - enabledConditionsNotMet: [hive.vectorized.execution.enabled IS false] - 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/1417370c/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out b/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out index 821ea3a..25a644d 100644 --- a/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_left_outer_join2.q.out @@ -170,16 +170,12 @@ POSTHOOK: Input: default@tjoin2 0 10 15 NULL 1 20 25 NULL 2 NULL 50 NULL -PREHOOK: query: explain vectorization expression +PREHOOK: query: explain select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) PREHOOK: type: QUERY -POSTHOOK: query: explain vectorization expression +POSTHOOK: query: explain select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 ) POSTHOOK: type: QUERY -PLAN VECTORIZATION: - enabled: false - enabledConditionsNotMet: [hive.vectorized.execution.enabled IS false] - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1
