hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vg...@apache.org
Subject [1/3] hive git commit: HIVE-17066: Query78 filter wrong estimatation is generating bad plan (Vineet Garg, reviewed by Ashutosh Chauhan)
Date Wed, 12 Jul 2017 18:14:47 GMT
Repository: hive
Updated Branches:
  refs/heads/master fadfcc67c -> 6bedc3dba


http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
index 6eba119..f7c694b 100644
--- a/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
@@ -105,11 +105,11 @@ STAGE PLANS:
                   1 UDFToInteger(_col0) (type: int)
                   2 (UDFToInteger(_col0) + 0) (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
-                Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                 Reduce Output Operator
                   key expressions: _col1 (type: smallint), _col0 (type: tinyint), _col2 (type:
int)
                   sort order: +++
-                  Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                   value expressions: _col3 (type: bigint), _col4 (type: float), _col5 (type:
double), _col6 (type: string), _col7 (type: string), _col8 (type: timestamp), _col9 (type:
timestamp), _col10 (type: boolean), _col11 (type: boolean)
         Reducer 3 
             Execution mode: llap
@@ -117,10 +117,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey1 (type: tinyint), KEY.reducesinkkey0 (type:
smallint), KEY.reducesinkkey2 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type:
float), VALUE._col2 (type: double), VALUE._col3 (type: string), VALUE._col4 (type: string),
VALUE._col5 (type: timestamp), VALUE._col6 (type: timestamp), VALUE._col7 (type: boolean),
VALUE._col8 (type: boolean)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
-                Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -296,11 +296,11 @@ STAGE PLANS:
                   1 UDFToInteger(_col0) (type: int)
                   2 (UDFToInteger(_col0) + 0) (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
-                Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                 Reduce Output Operator
                   key expressions: _col1 (type: smallint), _col0 (type: tinyint), _col2 (type:
int)
                   sort order: +++
-                  Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                   value expressions: _col3 (type: bigint), _col4 (type: float), _col5 (type:
double), _col6 (type: string), _col7 (type: string), _col8 (type: timestamp), _col9 (type:
timestamp), _col10 (type: boolean), _col11 (type: boolean)
         Reducer 3 
             Execution mode: vectorized, llap
@@ -308,10 +308,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey1 (type: tinyint), KEY.reducesinkkey0 (type:
smallint), KEY.reducesinkkey2 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type:
float), VALUE._col2 (type: double), VALUE._col3 (type: string), VALUE._col4 (type: string),
VALUE._col5 (type: timestamp), VALUE._col6 (type: timestamp), VALUE._col7 (type: boolean),
VALUE._col8 (type: boolean)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
-                Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -487,11 +487,11 @@ STAGE PLANS:
                   1 UDFToInteger(_col0) (type: int)
                   2 (UDFToInteger(_col0) + 0) (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
-                Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                 Reduce Output Operator
                   key expressions: _col1 (type: smallint), _col0 (type: tinyint), _col2 (type:
int)
                   sort order: +++
-                  Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                   value expressions: _col3 (type: bigint), _col4 (type: float), _col5 (type:
double), _col6 (type: string), _col7 (type: string), _col8 (type: timestamp), _col9 (type:
timestamp), _col10 (type: boolean), _col11 (type: boolean)
         Reducer 3 
             Execution mode: vectorized, llap
@@ -499,10 +499,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey1 (type: tinyint), KEY.reducesinkkey0 (type:
smallint), KEY.reducesinkkey2 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type:
float), VALUE._col2 (type: double), VALUE._col3 (type: string), VALUE._col4 (type: string),
VALUE._col5 (type: timestamp), VALUE._col6 (type: timestamp), VALUE._col7 (type: boolean),
VALUE._col8 (type: boolean)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
-                Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 2710 Data size: 840100 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 2710 Data size: 601590 Basic stats: COMPLETE Column
stats: COMPLETE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out b/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out
index 82111bb..6118c73 100644
--- a/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_left_outer_join.q.out
@@ -51,7 +51,7 @@ STAGE PLANS:
                       outputColumnNames: _col0
                       input vertices:
                         1 Map 3
-                      Statistics: Num rows: 26150 Data size: 104600 Basic stats: COMPLETE
Column stats: COMPLETE
+                      Statistics: Num rows: 26150 Data size: 92144 Basic stats: COMPLETE
Column stats: COMPLETE
                       Map Join Operator
                         condition map:
                              Left Outer Join 0 to 1

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out b/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
index f64e739..d95604d 100644
--- a/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
@@ -279,13 +279,13 @@ STAGE PLANS:
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18,
_col19, _col20, _col21, _col22, _col23
                       input vertices:
                         1 Map 2
-                      Statistics: Num rows: 32 Data size: 19648 Basic stats: COMPLETE Column
stats: COMPLETE
+                      Statistics: Num rows: 32 Data size: 17832 Basic stats: COMPLETE Column
stats: COMPLETE
                       File Output Operator
                         compressed: false
                         File Sink Vectorization:
                             className: VectorFileSinkOperator
                             native: false
-                        Statistics: Num rows: 32 Data size: 19648 Basic stats: COMPLETE Column
stats: COMPLETE
+                        Statistics: Num rows: 32 Data size: 17832 Basic stats: COMPLETE Column
stats: COMPLETE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -450,13 +450,13 @@ STAGE PLANS:
                       outputColumnNames: _col0
                       input vertices:
                         1 Map 2
-                      Statistics: Num rows: 112 Data size: 448 Basic stats: COMPLETE Column
stats: COMPLETE
+                      Statistics: Num rows: 112 Data size: 432 Basic stats: COMPLETE Column
stats: COMPLETE
                       File Output Operator
                         compressed: false
                         File Sink Vectorization:
                             className: VectorFileSinkOperator
                             native: false
-                        Statistics: Num rows: 112 Data size: 448 Basic stats: COMPLETE Column
stats: COMPLETE
+                        Statistics: Num rows: 112 Data size: 432 Basic stats: COMPLETE Column
stats: COMPLETE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -712,7 +712,7 @@ STAGE PLANS:
                       outputColumnNames: _col0
                       input vertices:
                         1 Map 3
-                      Statistics: Num rows: 32 Data size: 128 Basic stats: COMPLETE Column
stats: COMPLETE
+                      Statistics: Num rows: 32 Data size: 112 Basic stats: COMPLETE Column
stats: COMPLETE
                       Map Join Operator
                         condition map:
                              Left Outer Join 0 to 1
@@ -730,7 +730,7 @@ STAGE PLANS:
                         outputColumnNames: _col0
                         input vertices:
                           1 Map 4
-                        Statistics: Num rows: 240 Data size: 960 Basic stats: COMPLETE Column
stats: COMPLETE
+                        Statistics: Num rows: 240 Data size: 944 Basic stats: COMPLETE Column
stats: COMPLETE
                         Group By Operator
                           aggregations: count(), sum(_col0)
                           Group By Vectorization:

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out b/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
index c24a2d0..16de760 100644
--- a/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
@@ -294,7 +294,7 @@ STAGE PLANS:
                       outputColumnNames: _col1
                       input vertices:
                         1 Map 3
-                      Statistics: Num rows: 57 Data size: 456 Basic stats: COMPLETE Column
stats: COMPLETE
+                      Statistics: Num rows: 57 Data size: 384 Basic stats: COMPLETE Column
stats: COMPLETE
                       Map Join Operator
                         condition map:
                              Left Outer Join 0 to 1
@@ -312,7 +312,7 @@ STAGE PLANS:
                         outputColumnNames: _col1
                         input vertices:
                           1 Map 4
-                        Statistics: Num rows: 162 Data size: 1296 Basic stats: COMPLETE Column
stats: COMPLETE
+                        Statistics: Num rows: 162 Data size: 1224 Basic stats: COMPLETE Column
stats: COMPLETE
                         Group By Operator
                           aggregations: count(), sum(_col1)
                           Group By Vectorization:

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/vectorized_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/vectorized_mapjoin.q.out
index e56800a..8160bc7 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_mapjoin.q.out
@@ -59,7 +59,7 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1
                         input vertices:
                           1 Map 3
-                        Statistics: Num rows: 19518 Data size: 156144 Basic stats: COMPLETE
Column stats: COMPLETE
+                        Statistics: Num rows: 19518 Data size: 137552 Basic stats: COMPLETE
Column stats: COMPLETE
                         Select Operator
                           expressions: _col0 (type: int), _col1 (type: int), (_col0 + _col1)
(type: int)
                           outputColumnNames: _col0, _col1, _col2
@@ -68,7 +68,7 @@ STAGE PLANS:
                               native: true
                               projectedOutputColumns: [2, 2, 12]
                               selectExpressions: LongColAddLongColumn(col 2, col 2) ->
12:long
-                          Statistics: Num rows: 19518 Data size: 156144 Basic stats: COMPLETE
Column stats: COMPLETE
+                          Statistics: Num rows: 19518 Data size: 137552 Basic stats: COMPLETE
Column stats: COMPLETE
                           Group By Operator
                             aggregations: count(_col0), max(_col1), min(_col0), avg(_col2)
                             Group By Vectorization:

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/vectorized_nested_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_nested_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/vectorized_nested_mapjoin.q.out
index ed28530..28a8340 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_nested_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_nested_mapjoin.q.out
@@ -40,11 +40,11 @@ STAGE PLANS:
                         outputColumnNames: _col2, _col3
                         input vertices:
                           1 Map 3
-                        Statistics: Num rows: 884742 Data size: 10616904 Basic stats: COMPLETE
Column stats: COMPLETE
+                        Statistics: Num rows: 884742 Data size: 10596096 Basic stats: COMPLETE
Column stats: COMPLETE
                         Select Operator
                           expressions: _col2 (type: smallint), _col3 (type: double)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 884742 Data size: 10616904 Basic stats: COMPLETE
Column stats: COMPLETE
+                          Statistics: Num rows: 884742 Data size: 10596096 Basic stats: COMPLETE
Column stats: COMPLETE
                           Map Join Operator
                             condition map:
                                  Inner Join 0 to 1
@@ -54,7 +54,7 @@ STAGE PLANS:
                             outputColumnNames: _col1
                             input vertices:
                               1 Map 4
-                            Statistics: Num rows: 1966236 Data size: 15729888 Basic stats:
COMPLETE Column stats: COMPLETE
+                            Statistics: Num rows: 1966236 Data size: 15716016 Basic stats:
COMPLETE Column stats: COMPLETE
                             Group By Operator
                               aggregations: sum(_col1)
                               mode: hash

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/vectorized_shufflejoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_shufflejoin.q.out b/ql/src/test/results/clientpositive/llap/vectorized_shufflejoin.q.out
index a750d9f..73ab9fc 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_shufflejoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_shufflejoin.q.out
@@ -118,11 +118,11 @@ STAGE PLANS:
                   0 _col0 (type: int)
                   1 _col0 (type: int)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 19518 Data size: 156144 Basic stats: COMPLETE Column
stats: COMPLETE
+                Statistics: Num rows: 19518 Data size: 137552 Basic stats: COMPLETE Column
stats: COMPLETE
                 Select Operator
                   expressions: _col0 (type: int), _col1 (type: int), (_col0 + _col1) (type:
int)
                   outputColumnNames: _col0, _col1, _col2
-                  Statistics: Num rows: 19518 Data size: 156144 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 19518 Data size: 137552 Basic stats: COMPLETE Column
stats: COMPLETE
                   Group By Operator
                     aggregations: count(_col0), max(_col1), min(_col0), avg(_col2)
                     Group By Vectorization:

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/llap/windowing_gby.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/windowing_gby.q.out b/ql/src/test/results/clientpositive/llap/windowing_gby.q.out
index 945f8e0..2c47b8b 100644
--- a/ql/src/test/results/clientpositive/llap/windowing_gby.q.out
+++ b/ql/src/test/results/clientpositive/llap/windowing_gby.q.out
@@ -39,9 +39,9 @@ Stage-0
                   <-Reducer 2 [SIMPLE_EDGE] llap
                     SHUFFLE [RS_11]
                       PartitionCols:_col0
-                      Group By Operator [GBY_10] (rows=2 width=20)
+                      Group By Operator [GBY_10] (rows=3 width=20)
                         Output:["_col0","_col1","_col2"],aggregations:["sum(_col3)","sum(_col1)"],keys:_col2
-                        Merge Join Operator [MERGEJOIN_24] (rows=29 width=12)
+                        Merge Join Operator [MERGEJOIN_24] (rows=29 width=7)
                           Conds:RS_6._col0=RS_7._col1(Inner),Output:["_col1","_col2","_col3"]
                         <-Map 1 [SIMPLE_EDGE] llap
                           SHUFFLE [RS_6]

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/perf/query14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query14.q.out b/ql/src/test/results/clientpositive/perf/query14.q.out
index 42bad8d..37156ec 100644
--- a/ql/src/test/results/clientpositive/perf/query14.q.out
+++ b/ql/src/test/results/clientpositive/perf/query14.q.out
@@ -1,5 +1,5 @@
-Warning: Shuffle Join MERGEJOIN[891][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer
12' is a cross product
 Warning: Shuffle Join MERGEJOIN[890][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer
5' is a cross product
+Warning: Shuffle Join MERGEJOIN[891][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer
12' is a cross product
 Warning: Shuffle Join MERGEJOIN[892][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer
16' is a cross product
 PREHOOK: query: explain
 with  cross_items as

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out b/ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out
index d09bc52..519e155 100644
--- a/ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out
+++ b/ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out
@@ -752,10 +752,10 @@ STAGE PLANS:
                   0 _col0 (type: string), _col1 (type: int)
                   1 _col1 (type: string), _col0 (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                Statistics: Num rows: 48 Data size: 9312 Basic stats: COMPLETE Column stats:
COMPLETE
+                Statistics: Num rows: 48 Data size: 5417 Basic stats: COMPLETE Column stats:
COMPLETE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 48 Data size: 9312 Basic stats: COMPLETE Column stats:
COMPLETE
+                  Statistics: Num rows: 48 Data size: 5417 Basic stats: COMPLETE Column stats:
COMPLETE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -967,10 +967,10 @@ STAGE PLANS:
                   0 _col0 (type: string), _col1 (type: int)
                   1 _col1 (type: string), _col0 (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                Statistics: Num rows: 54 Data size: 10476 Basic stats: COMPLETE Column stats:
COMPLETE
+                Statistics: Num rows: 54 Data size: 1358 Basic stats: COMPLETE Column stats:
COMPLETE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 54 Data size: 10476 Basic stats: COMPLETE Column
stats: COMPLETE
+                  Statistics: Num rows: 54 Data size: 1358 Basic stats: COMPLETE Column stats:
COMPLETE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/6bedc3db/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
index 14535f6..9fbe8c5 100644
--- a/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainanalyze_4.q.out
@@ -44,11 +44,11 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_12]
-        Select Operator [SEL_11] (rows=2166/10 width=620)
+        Select Operator [SEL_11] (rows=2166/10 width=556)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
         <-Reducer 2 [SIMPLE_EDGE]
           SHUFFLE [RS_10]
-            Merge Join Operator [MERGEJOIN_17] (rows=2166/10 width=620)
+            Merge Join Operator [MERGEJOIN_17] (rows=2166/10 width=556)
               Conds:RS_6._col2=RS_7._col2(Inner),Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23"]
             <-Map 1 [SIMPLE_EDGE]
               SHUFFLE [RS_6]
@@ -232,16 +232,16 @@ Stage-0
     Stage-1
       Reducer 4
       File Output Operator [FS_15]
-        Select Operator [SEL_14] (rows=615/5 width=12)
+        Select Operator [SEL_14] (rows=616/5 width=11)
           Output:["_col0","_col1"]
         <-Reducer 3 [SIMPLE_EDGE]
           SHUFFLE [RS_13]
-            Group By Operator [GBY_11] (rows=615/5 width=12)
+            Group By Operator [GBY_11] (rows=616/5 width=11)
               Output:["_col0","_col1"],aggregations:["count()"],keys:KEY._col0
             <-Reducer 2 [SIMPLE_EDGE]
               SHUFFLE [RS_10]
                 PartitionCols:_col0
-                Merge Join Operator [MERGEJOIN_20] (rows=2166/10 width=4)
+                Merge Join Operator [MERGEJOIN_20] (rows=2166/10 width=3)
                   Conds:RS_6._col1=RS_7._col0(Inner),Output:["_col0"]
                 <-Map 1 [SIMPLE_EDGE]
                   SHUFFLE [RS_6]


Mime
View raw message