You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2015/09/18 09:05:32 UTC
hive git commit: HIVE-11877: LLAP: Fix ordering difference in
acid_vectorization_partition.q (Prasanth Jayachandran)
Repository: hive
Updated Branches:
refs/heads/llap c6667ddcc -> 754c27900
HIVE-11877: LLAP: Fix ordering difference in acid_vectorization_partition.q (Prasanth Jayachandran)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/754c2790
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/754c2790
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/754c2790
Branch: refs/heads/llap
Commit: 754c2790041efc5957f234ad97b176948c4f1683
Parents: c6667dd
Author: Prasanth Jayachandran <j....@gmail.com>
Authored: Fri Sep 18 02:05:18 2015 -0500
Committer: Prasanth Jayachandran <j....@gmail.com>
Committed: Fri Sep 18 02:05:18 2015 -0500
----------------------------------------------------------------------
.../acid_vectorization_partition.q | 2 +-
.../llap/acid_vectorization_partition.q.out | 60 ++++++++++++++++++++
.../tez/acid_vectorization_partition.q.out | 18 +++---
3 files changed, 70 insertions(+), 10 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/754c2790/ql/src/test/queries/clientpositive/acid_vectorization_partition.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/acid_vectorization_partition.q b/ql/src/test/queries/clientpositive/acid_vectorization_partition.q
index 9348d05..00449bb 100644
--- a/ql/src/test/queries/clientpositive/acid_vectorization_partition.q
+++ b/ql/src/test/queries/clientpositive/acid_vectorization_partition.q
@@ -7,4 +7,4 @@ CREATE TABLE acid_vectorized_part(a INT, b STRING) partitioned by (ds string) CL
insert into table acid_vectorized_part partition (ds = 'today') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10;
insert into table acid_vectorized_part partition (ds = 'tomorrow') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10;
set hive.vectorized.execution.enabled=true;
-select * from acid_vectorized_part order by a, b;
+select * from acid_vectorized_part order by a, b, ds;
http://git-wip-us.apache.org/repos/asf/hive/blob/754c2790/ql/src/test/results/clientpositive/llap/acid_vectorization_partition.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/acid_vectorization_partition.q.out b/ql/src/test/results/clientpositive/llap/acid_vectorization_partition.q.out
new file mode 100644
index 0000000..f608b10
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/acid_vectorization_partition.q.out
@@ -0,0 +1,60 @@
+PREHOOK: query: CREATE TABLE acid_vectorized_part(a INT, b STRING) partitioned by (ds string) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true')
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_vectorized_part
+POSTHOOK: query: CREATE TABLE acid_vectorized_part(a INT, b STRING) partitioned by (ds string) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true')
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_vectorized_part
+PREHOOK: query: insert into table acid_vectorized_part partition (ds = 'today') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_vectorized_part@ds=today
+POSTHOOK: query: insert into table acid_vectorized_part partition (ds = 'today') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_vectorized_part@ds=today
+POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=today).b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_vectorized_part partition (ds = 'tomorrow') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_vectorized_part@ds=tomorrow
+POSTHOOK: query: insert into table acid_vectorized_part partition (ds = 'tomorrow') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_vectorized_part@ds=tomorrow
+POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=tomorrow).b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_vectorized_part order by a, b, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_vectorized_part
+PREHOOK: Input: default@acid_vectorized_part@ds=today
+PREHOOK: Input: default@acid_vectorized_part@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_vectorized_part order by a, b, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_vectorized_part
+POSTHOOK: Input: default@acid_vectorized_part@ds=today
+POSTHOOK: Input: default@acid_vectorized_part@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073279343 oj1YrV5Wa tomorrow
+-1073051226 A34p7oRr2WvUJNf today
+-1073051226 A34p7oRr2WvUJNf tomorrow
+-1072910839 0iqrc5 today
+-1072910839 0iqrc5 tomorrow
+-1072081801 dPkN74F7 today
+-1072081801 dPkN74F7 tomorrow
+-1072076362 2uLyD28144vklju213J1mr today
+-1072076362 2uLyD28144vklju213J1mr tomorrow
+-1071480828 aw724t8c5558x2xneC624 today
+-1071480828 aw724t8c5558x2xneC624 tomorrow
+-1071363017 Anj0oF today
+-1071363017 Anj0oF tomorrow
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070883071 0ruyd6Y50JpdGRf6HqD tomorrow
+-1070551679 iUR3Q today
+-1070551679 iUR3Q tomorrow
+-1069736047 k17Am8uPHWk02cEf1jet today
+-1069736047 k17Am8uPHWk02cEf1jet tomorrow
http://git-wip-us.apache.org/repos/asf/hive/blob/754c2790/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out b/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out
index 3b37c72..f608b10 100644
--- a/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out
+++ b/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out
@@ -26,35 +26,35 @@ POSTHOOK: Input: default@alltypesorc
POSTHOOK: Output: default@acid_vectorized_part@ds=tomorrow
POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=tomorrow).b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
-PREHOOK: query: select * from acid_vectorized_part order by a, b
+PREHOOK: query: select * from acid_vectorized_part order by a, b, ds
PREHOOK: type: QUERY
PREHOOK: Input: default@acid_vectorized_part
PREHOOK: Input: default@acid_vectorized_part@ds=today
PREHOOK: Input: default@acid_vectorized_part@ds=tomorrow
#### A masked pattern was here ####
-POSTHOOK: query: select * from acid_vectorized_part order by a, b
+POSTHOOK: query: select * from acid_vectorized_part order by a, b, ds
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_vectorized_part
POSTHOOK: Input: default@acid_vectorized_part@ds=today
POSTHOOK: Input: default@acid_vectorized_part@ds=tomorrow
#### A masked pattern was here ####
--1073279343 oj1YrV5Wa tomorrow
-1073279343 oj1YrV5Wa today
--1073051226 A34p7oRr2WvUJNf tomorrow
+-1073279343 oj1YrV5Wa tomorrow
-1073051226 A34p7oRr2WvUJNf today
--1072910839 0iqrc5 tomorrow
+-1073051226 A34p7oRr2WvUJNf tomorrow
-1072910839 0iqrc5 today
--1072081801 dPkN74F7 tomorrow
+-1072910839 0iqrc5 tomorrow
-1072081801 dPkN74F7 today
+-1072081801 dPkN74F7 tomorrow
-1072076362 2uLyD28144vklju213J1mr today
-1072076362 2uLyD28144vklju213J1mr tomorrow
--1071480828 aw724t8c5558x2xneC624 tomorrow
-1071480828 aw724t8c5558x2xneC624 today
--1071363017 Anj0oF tomorrow
+-1071480828 aw724t8c5558x2xneC624 tomorrow
-1071363017 Anj0oF today
+-1071363017 Anj0oF tomorrow
-1070883071 0ruyd6Y50JpdGRf6HqD today
-1070883071 0ruyd6Y50JpdGRf6HqD tomorrow
--1070551679 iUR3Q tomorrow
-1070551679 iUR3Q today
+-1070551679 iUR3Q tomorrow
-1069736047 k17Am8uPHWk02cEf1jet today
-1069736047 k17Am8uPHWk02cEf1jet tomorrow