You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2018/04/04 18:58:15 UTC
hive git commit: HIVE-19073: StatsOptimizer may mangle constant
columns (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan) (addendum)
Repository: hive
Updated Branches:
refs/heads/master ee3724cdc -> 001ab47fe
HIVE-19073: StatsOptimizer may mangle constant columns (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan) (addendum)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/001ab47f
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/001ab47f
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/001ab47f
Branch: refs/heads/master
Commit: 001ab47fe54e143c806bc0deefff695d16057394
Parents: ee3724c
Author: Jesus Camacho Rodriguez <jc...@apache.org>
Authored: Wed Apr 4 11:50:45 2018 -0700
Committer: Jesus Camacho Rodriguez <jc...@apache.org>
Committed: Wed Apr 4 11:58:08 2018 -0700
----------------------------------------------------------------------
.../queries/clientpositive/statsoptimizer.q | 14 ++++++++
.../results/clientpositive/statsoptimizer.q.out | 37 ++++++++++++++++++++
2 files changed, 51 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/001ab47f/ql/src/test/queries/clientpositive/statsoptimizer.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/statsoptimizer.q b/ql/src/test/queries/clientpositive/statsoptimizer.q
new file mode 100644
index 0000000..428b741
--- /dev/null
+++ b/ql/src/test/queries/clientpositive/statsoptimizer.q
@@ -0,0 +1,14 @@
+set hive.cbo.enable=false;
+set hive.compute.query.using.stats=true;
+
+EXPLAIN
+SELECT to_date(current_date()) as GROUP_BY_FIELD, count (*) as src_cnt
+from src
+WHERE 1=1
+group by to_date(current_date());
+
+SELECT to_date(current_date()) as GROUP_BY_FIELD, count (*) as src_cnt
+from src
+WHERE 1=1
+group by to_date(current_date());
+
http://git-wip-us.apache.org/repos/asf/hive/blob/001ab47f/ql/src/test/results/clientpositive/statsoptimizer.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/statsoptimizer.q.out b/ql/src/test/results/clientpositive/statsoptimizer.q.out
new file mode 100644
index 0000000..1f97de3
--- /dev/null
+++ b/ql/src/test/results/clientpositive/statsoptimizer.q.out
@@ -0,0 +1,37 @@
+PREHOOK: query: EXPLAIN
+SELECT to_date(current_date()) as GROUP_BY_FIELD, count (*) as src_cnt
+from src
+WHERE 1=1
+group by to_date(current_date())
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT to_date(current_date()) as GROUP_BY_FIELD, count (*) as src_cnt
+from src
+WHERE 1=1
+group by to_date(current_date())
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: 1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: SELECT to_date(current_date()) as GROUP_BY_FIELD, count (*) as src_cnt
+from src
+WHERE 1=1
+group by to_date(current_date())
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT to_date(current_date()) as GROUP_BY_FIELD, count (*) as src_cnt
+from src
+WHERE 1=1
+group by to_date(current_date())
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2018-04-04 500