You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2015/07/13 18:32:52 UTC
hive git commit: HIVE-11231 : CBO: Calcite Operator To Hive Operator
(Calcite Return Path): make the output of ba_table_union.q more stable
(Pengcheng Xiong via Ashutosh Chauhan)
Repository: hive
Updated Branches:
refs/heads/master 66feedc55 -> 65e9fcf05
HIVE-11231 : CBO: Calcite Operator To Hive Operator (Calcite Return Path): make the output of ba_table_union.q more stable (Pengcheng Xiong via Ashutosh Chauhan)
Signed-off-by: Ashutosh Chauhan <ha...@apache.org>
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/65e9fcf0
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/65e9fcf0
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/65e9fcf0
Branch: refs/heads/master
Commit: 65e9fcf059f5e274c4b7871e7bc4034db98e8591
Parents: 66feedc
Author: Pengcheng Xiong <px...@hortonworks.com>
Authored: Mon Jul 20 12:16:00 2015 -0700
Committer: Ashutosh Chauhan <ha...@apache.org>
Committed: Mon Jul 13 09:32:29 2015 -0700
----------------------------------------------------------------------
ql/src/test/queries/clientpositive/ba_table_union.q | 2 +-
.../results/clientpositive/ba_table_union.q.out | 16 ++++++++--------
2 files changed, 9 insertions(+), 9 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/65e9fcf0/ql/src/test/queries/clientpositive/ba_table_union.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/ba_table_union.q b/ql/src/test/queries/clientpositive/ba_table_union.q
index 9804659..bf35d0e 100644
--- a/ql/src/test/queries/clientpositive/ba_table_union.q
+++ b/ql/src/test/queries/clientpositive/ba_table_union.q
@@ -7,7 +7,7 @@ describe extended ba_test;
from src insert overwrite table ba_test select cast (src.key as binary), cast (src.value as binary);
-select * from ( select key from src where key < 50 union all select cast(ba_key as string) as key from ba_test limit 50) unioned order by key limit 10;
+select * from ( select key from src where key < 50 union all select cast(ba_key as string) as key from ba_test order by key limit 50) unioned order by key limit 10;
drop table ba_test;
http://git-wip-us.apache.org/repos/asf/hive/blob/65e9fcf0/ql/src/test/results/clientpositive/ba_table_union.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/ba_table_union.q.out b/ql/src/test/results/clientpositive/ba_table_union.q.out
index 639ffda..53f16b6 100644
--- a/ql/src/test/results/clientpositive/ba_table_union.q.out
+++ b/ql/src/test/results/clientpositive/ba_table_union.q.out
@@ -32,12 +32,12 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@ba_test
POSTHOOK: Lineage: ba_test.ba_key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: ba_test.ba_val EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from ( select key from src where key < 50 union all select cast(ba_key as string) as key from ba_test limit 50) unioned order by key limit 10
+PREHOOK: query: select * from ( select key from src where key < 50 union all select cast(ba_key as string) as key from ba_test order by key limit 50) unioned order by key limit 10
PREHOOK: type: QUERY
PREHOOK: Input: default@ba_test
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: select * from ( select key from src where key < 50 union all select cast(ba_key as string) as key from ba_test limit 50) unioned order by key limit 10
+POSTHOOK: query: select * from ( select key from src where key < 50 union all select cast(ba_key as string) as key from ba_test order by key limit 50) unioned order by key limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ba_test
POSTHOOK: Input: default@src
@@ -45,13 +45,13 @@ POSTHOOK: Input: default@src
0
0
0
+0
+0
+0
+10
10
-11
-12
-12
-15
-15
-153
+100
+100
PREHOOK: query: drop table ba_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@ba_test