HIVE-17800: input_part6.q wants to test partition pruning, but tests expression evaluation (Peter Vary reviewed by Barna Zsombor Klara via Zoltan Haindrich)
Signed-off-by: Zoltan Haindrich <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/2218bd27 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/2218bd27 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/2218bd27 Branch: refs/heads/master Commit: 2218bd279473040ee7183dff67a1eb6d237c9d92 Parents: 3681b85 Author: Peter Vary <[email protected]> Authored: Thu Oct 19 11:03:42 2017 +0200 Committer: Zoltan Haindrich <[email protected]> Committed: Thu Oct 19 11:03:49 2017 +0200 ---------------------------------------------------------------------- .../test/queries/clientpositive/input_part6.q | 4 +- .../results/clientpositive/input_part6.q.out | 61 +++++++++----------- 2 files changed, 28 insertions(+), 37 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/2218bd27/ql/src/test/queries/clientpositive/input_part6.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/input_part6.q b/ql/src/test/queries/clientpositive/input_part6.q index e87fc58..dd43a83 100644 --- a/ql/src/test/queries/clientpositive/input_part6.q +++ b/ql/src/test/queries/clientpositive/input_part6.q @@ -1,5 +1,5 @@ set hive.mapred.mode=nonstrict; EXPLAIN -SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10; +SELECT x.* FROM SRCPART x WHERE x.ds = "2008-04-08" LIMIT 10; -SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10; +SELECT x.* FROM SRCPART x WHERE x.ds = "2008-04-08" LIMIT 10; http://git-wip-us.apache.org/repos/asf/hive/blob/2218bd27/ql/src/test/results/clientpositive/input_part6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input_part6.q.out b/ql/src/test/results/clientpositive/input_part6.q.out index c6253f5..90e8ba3 100644 --- a/ql/src/test/results/clientpositive/input_part6.q.out +++ b/ql/src/test/results/clientpositive/input_part6.q.out @@ -1,57 +1,48 @@ PREHOOK: query: EXPLAIN -SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 +SELECT x.* FROM SRCPART x WHERE x.ds = "2008-04-08" LIMIT 10 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN -SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 +SELECT x.* FROM SRCPART x WHERE x.ds = "2008-04-08" LIMIT 10 POSTHOOK: type: QUERY STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 + Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: x - Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (UDFToDouble(ds) = 1996.0) (type: boolean) - Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string), ds (type: string), hr (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE - Limit - Number of rows: 10 - Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - Stage: Stage-0 Fetch Operator limit: 10 Processor Tree: - ListSink + TableScan + alias: x + Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: string), value (type: string), '2008-04-08' (type: string), hr (type: string) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE + Limit + Number of rows: 10 + Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE + ListSink -PREHOOK: query: SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 +PREHOOK: query: SELECT x.* FROM SRCPART x WHERE x.ds = "2008-04-08" LIMIT 10 PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 #### A masked pattern was here #### -POSTHOOK: query: SELECT x.* FROM SRCPART x WHERE x.ds = 2008-04-08 LIMIT 10 +POSTHOOK: query: SELECT x.* FROM SRCPART x WHERE x.ds = "2008-04-08" LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 #### A masked pattern was here #### +238 val_238 2008-04-08 11 +86 val_86 2008-04-08 11 +311 val_311 2008-04-08 11 +27 val_27 2008-04-08 11 +165 val_165 2008-04-08 11 +409 val_409 2008-04-08 11 +255 val_255 2008-04-08 11 +278 val_278 2008-04-08 11 +98 val_98 2008-04-08 11 +484 val_484 2008-04-08 11
