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 <hashut...@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/beeline-cli Commit: 65e9fcf059f5e274c4b7871e7bc4034db98e8591 Parents: 66feedc Author: Pengcheng Xiong <pxi...@hortonworks.com> Authored: Mon Jul 20 12:16:00 2015 -0700 Committer: Ashutosh Chauhan <hashut...@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