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 <jcama...@apache.org> Authored: Wed Apr 4 11:50:45 2018 -0700 Committer: Jesus Camacho Rodriguez <jcama...@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