Repository: hive Updated Branches: refs/heads/branch-2.1 c92af0dcd -> 2812ca001
HIVE-14339 : Fix UT failure for acid_globallimit.q (Wei Zheng, reviewed by Pengcheng Xiong) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/2812ca00 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/2812ca00 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/2812ca00 Branch: refs/heads/branch-2.1 Commit: 2812ca00100ee1e0252635ab3e74352678cf36bb Parents: c92af0d Author: Wei Zheng <w...@apache.org> Authored: Tue Jul 26 15:45:38 2016 -0700 Committer: Wei Zheng <w...@apache.org> Committed: Tue Jul 26 15:45:38 2016 -0700 ---------------------------------------------------------------------- .../queries/clientpositive/acid_globallimit.q | 4 -- .../clientpositive/acid_globallimit.q.out | 73 -------------------- .../clientpositive/tez/acid_globallimit.q.out | 21 ------ 3 files changed, 98 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/2812ca00/ql/src/test/queries/clientpositive/acid_globallimit.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_globallimit.q b/ql/src/test/queries/clientpositive/acid_globallimit.q index 7f04c2b..7fa4c07 100644 --- a/ql/src/test/queries/clientpositive/acid_globallimit.q +++ b/ql/src/test/queries/clientpositive/acid_globallimit.q @@ -11,10 +11,6 @@ TBLPROPERTIES ("transactional"="true"); insert into table acidtest1 select cint, cstring1 from alltypesorc where cint is not null order by cint; -desc formatted acidtest1; - -explain -select cast (c1 as string) from acidtest1 limit 10; select cast (c1 as string) from acidtest1 limit 10; drop table acidtest1; http://git-wip-us.apache.org/repos/asf/hive/blob/2812ca00/ql/src/test/results/clientpositive/acid_globallimit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/acid_globallimit.q.out b/ql/src/test/results/clientpositive/acid_globallimit.q.out index d5ed34f..fe738a6 100644 --- a/ql/src/test/results/clientpositive/acid_globallimit.q.out +++ b/ql/src/test/results/clientpositive/acid_globallimit.q.out @@ -24,79 +24,6 @@ POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@acidtest1 POSTHOOK: Lineage: acidtest1.c1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] POSTHOOK: Lineage: acidtest1.c2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: desc formatted acidtest1 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@acidtest1 -POSTHOOK: query: desc formatted acidtest1 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@acidtest1 -# col_name data_type comment - -c1 int -c2 string - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - numFiles 3 - numRows 0 - rawDataSize 0 - totalSize 101663 - transactional true -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: 3 -Bucket Columns: [c1] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: explain -select cast (c1 as string) from acidtest1 limit 10 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select cast (c1 as string) from acidtest1 limit 10 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: acidtest1 - Statistics: Num rows: 25415 Data size: 101663 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: UDFToString(c1) (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 25415 Data size: 101663 Basic stats: COMPLETE Column stats: NONE - Limit - Number of rows: 10 - Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 40 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 - PREHOOK: query: select cast (c1 as string) from acidtest1 limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@acidtest1 http://git-wip-us.apache.org/repos/asf/hive/blob/2812ca00/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out b/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out index e6b3686..6f0e46e 100644 --- a/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out +++ b/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out @@ -24,27 +24,6 @@ POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@acidtest1 POSTHOOK: Lineage: acidtest1.c1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] POSTHOOK: Lineage: acidtest1.c2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: explain -select cast (c1 as string) from acidtest1 limit 10 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select cast (c1 as string) from acidtest1 limit 10 -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:10 - Stage-1 - Map 1 - File Output Operator [FS_3] - Limit [LIM_2] (rows=10 width=10) - Number of rows:10 - Select Operator [SEL_1] (rows=9173 width=10) - Output:["_col0"] - TableScan [TS_0] (rows=9173 width=10) - default@acidtest1,acidtest1, ACID table,Tbl:COMPLETE,Col:NONE,Output:["c1"] - PREHOOK: query: select cast (c1 as string) from acidtest1 limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@acidtest1
