Repository: hive Updated Branches: refs/heads/master bd9264fb3 -> ce0f7b034
HIVE-19573: Fix flaky TestMiniLlapLocalCliDriver#explainuser_4.q (Jesus Camacho Rodriguez) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/c9fcdcf3 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/c9fcdcf3 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/c9fcdcf3 Branch: refs/heads/master Commit: c9fcdcf342ddbcd5e32baffb897c9185221eb351 Parents: bd9264f Author: Jesus Camacho Rodriguez <[email protected]> Authored: Wed May 16 09:02:40 2018 -0700 Committer: Jesus Camacho Rodriguez <[email protected]> Committed: Wed May 16 09:02:40 2018 -0700 ---------------------------------------------------------------------- .../test/queries/clientpositive/explainuser_4.q | 8 ++++---- .../clientpositive/llap/explainuser_4.q.out | 18 +++++++++--------- 2 files changed, 13 insertions(+), 13 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/c9fcdcf3/ql/src/test/queries/clientpositive/explainuser_4.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/explainuser_4.q b/ql/src/test/queries/clientpositive/explainuser_4.q index 099971a..a2c25bc 100644 --- a/ql/src/test/queries/clientpositive/explainuser_4.q +++ b/ql/src/test/queries/clientpositive/explainuser_4.q @@ -42,7 +42,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1; +order by c1, a.csmallint; select a.csmallint, count(*) c1 @@ -50,7 +50,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1; +order by c1, a.csmallint; set hive.auto.convert.join=true; set hive.optimize.dynamic.partition.hashjoin=true; @@ -94,7 +94,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1; +order by c1, a.csmallint; select a.csmallint, count(*) c1 @@ -102,7 +102,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1; +order by c1, a.csmallint; -- Left outer join with residual explain http://git-wip-us.apache.org/repos/asf/hive/blob/c9fcdcf3/ql/src/test/results/clientpositive/llap/explainuser_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/explainuser_4.q.out b/ql/src/test/results/clientpositive/llap/explainuser_4.q.out index 26d858c..c75e82c 100644 --- a/ql/src/test/results/clientpositive/llap/explainuser_4.q.out +++ b/ql/src/test/results/clientpositive/llap/explainuser_4.q.out @@ -156,7 +156,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint PREHOOK: type: QUERY POSTHOOK: query: explain select @@ -165,7 +165,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint POSTHOOK: type: QUERY Plan optimized by CBO. @@ -218,7 +218,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### @@ -228,14 +228,14 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### +-13036 1 -8915 1 -3799 1 10782 1 --13036 1 NULL 6 PREHOOK: query: explain select @@ -395,7 +395,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint PREHOOK: type: QUERY POSTHOOK: query: explain select @@ -404,7 +404,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint POSTHOOK: type: QUERY Plan optimized by CBO. @@ -457,7 +457,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc #### A masked pattern was here #### @@ -467,7 +467,7 @@ from alltypesorc a join alltypesorc b on a.cint = b.cint where a.cint between 1000000 and 3000000 and b.cbigint is not null group by a.csmallint -order by c1 +order by c1, a.csmallint POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here ####
