Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out Mon Aug 18 17:05:02 2014 @@ -24,10 +24,10 @@ STAGE PLANS: outputColumnNames: key, value Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col1, _col4 + outputColumnNames: _col0, _col1, _col5 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Limit @@ -49,10 +49,10 @@ STAGE PLANS: function name: explode outer lateral view: true Lateral View Join Operator - outputColumnNames: _col0, _col1, _col4 + outputColumnNames: _col0, _col1, _col5 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Limit @@ -116,10 +116,10 @@ STAGE PLANS: outputColumnNames: key, value Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col1, _col4 + outputColumnNames: _col0, _col1, _col5 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: int) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Limit @@ -141,10 +141,10 @@ STAGE PLANS: function name: explode outer lateral view: true Lateral View Join Operator - outputColumnNames: _col0, _col1, _col4 + outputColumnNames: _col0, _col1, _col5 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: int) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Limit @@ -213,10 +213,10 @@ STAGE PLANS: outputColumnNames: key, value Statistics: Num rows: 500 Data size: 5610 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col1, _col4 + outputColumnNames: _col0, _col1, _col5 Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: array<string>), _col4 (type: string) + expressions: _col0 (type: string), _col1 (type: array<string>), _col5 (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE Limit @@ -238,10 +238,10 @@ STAGE PLANS: function name: explode outer lateral view: true Lateral View Join Operator - outputColumnNames: _col0, _col1, _col4 + outputColumnNames: _col0, _col1, _col5 Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: array<string>), _col4 (type: string) + expressions: _col0 (type: string), _col1 (type: array<string>), _col5 (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 1000 Data size: 11220 Basic stats: COMPLETE Column stats: NONE Limit
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out Mon Aug 18 17:05:02 2014 @@ -23,10 +23,10 @@ STAGE PLANS: outputColumnNames: value Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -44,10 +44,10 @@ STAGE PLANS: Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -106,10 +106,10 @@ STAGE PLANS: outputColumnNames: value Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -130,10 +130,10 @@ STAGE PLANS: predicate: (col = 1) (type: boolean) Statistics: Num rows: 14 Data size: 1427 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -183,10 +183,10 @@ STAGE PLANS: outputColumnNames: value Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col6 + outputColumnNames: _col1, _col7 Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col6 (type: int) + expressions: _col1 (type: string), _col7 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Limit @@ -207,10 +207,10 @@ STAGE PLANS: Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col1, _col6 + outputColumnNames: _col1, _col7 Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col6 (type: int) + expressions: _col1 (type: string), _col7 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Limit @@ -277,19 +277,19 @@ STAGE PLANS: outputColumnNames: value Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Lateral View Forward Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) - outputColumnNames: _col1, _col4 + expressions: _col1 (type: string), _col5 (type: int) + outputColumnNames: _col1, _col5 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4, _col5 + outputColumnNames: _col1, _col5, _col6 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -307,10 +307,10 @@ STAGE PLANS: Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col1, _col4, _col5 + outputColumnNames: _col1, _col5, _col6 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -328,19 +328,19 @@ STAGE PLANS: Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Lateral View Forward Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) - outputColumnNames: _col1, _col4 + expressions: _col1 (type: string), _col5 (type: int) + outputColumnNames: _col1, _col5 Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4, _col5 + outputColumnNames: _col1, _col5, _col6 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -358,10 +358,10 @@ STAGE PLANS: Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col1, _col4, _col5 + outputColumnNames: _col1, _col5, _col6 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -440,10 +440,10 @@ STAGE PLANS: outputColumnNames: value Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -464,10 +464,10 @@ STAGE PLANS: predicate: (col > 1) (type: boolean) Statistics: Num rows: 9 Data size: 917 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col1, _col4 + outputColumnNames: _col1, _col5 Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col1 (type: string), _col4 (type: int) + expressions: _col1 (type: string), _col5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out Mon Aug 18 17:05:02 2014 @@ -43,10 +43,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE Limit Modified: hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/lineage1.q.out Mon Aug 18 17:05:02 2014 @@ -72,10 +72,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} - outputColumnNames: _col0, _col5 + outputColumnNames: _col0, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -198,10 +198,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} - outputColumnNames: _col0, _col5 + outputColumnNames: _col0, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out Mon Aug 18 17:05:02 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out Mon Aug 18 17:05:02 2014 @@ -75,10 +75,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Limit @@ -172,10 +172,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Limit @@ -275,10 +275,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 _col0 (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: struct<key:string,value:string>) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: struct<key:string,value:string>) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Limit @@ -366,10 +366,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Limit @@ -461,10 +461,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE Limit @@ -559,10 +559,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 _col0 (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: struct<key:string,value:string>) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: struct<key:string,value:string>) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Limit Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_filter_on_outerjoin.q.out Mon Aug 18 17:05:02 2014 @@ -134,10 +134,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -298,10 +298,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out Mon Aug 18 17:05:02 2014 @@ -74,10 +74,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 5 Data size: 38 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 5 Data size: 38 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out Mon Aug 18 17:05:02 2014 @@ -145,10 +145,10 @@ STAGE PLANS: keys: 0 id (type: int) 1 id (type: int) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col5 (type: int), _col4 (type: string), _col0 (type: int), _col1 (type: string) + expressions: _col6 (type: int), _col5 (type: string), _col0 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Map Join Operator Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out Mon Aug 18 17:05:02 2014 @@ -304,10 +304,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -1137,10 +1137,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/mergejoins.q.out Mon Aug 18 17:05:02 2014 @@ -110,7 +110,7 @@ STAGE PLANS: 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} 3 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -128,7 +128,7 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col1 (type: int) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: int), _col4 (type: int), _col5 (type: int), _col8 (type: int), _col9 (type: int), _col12 (type: int), _col13 (type: int) + value expressions: _col0 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int), _col15 (type: int), _col16 (type: int) TableScan alias: e Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -146,12 +146,12 @@ STAGE PLANS: condition map: Inner Join 0 to 1 condition expressions: - 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8} {VALUE._col11} {VALUE._col12} + 0 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10} {VALUE._col14} {VALUE._col15} 1 {VALUE._col0} {KEY.reducesinkkey0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13, _col16, _col17 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16, _col20, _col21 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: int), _col4 (type: int), _col5 (type: int), _col8 (type: int), _col9 (type: int), _col12 (type: int), _col13 (type: int), _col16 (type: int), _col17 (type: int) + expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int), _col15 (type: int), _col16 (type: int), _col20 (type: int), _col21 (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -222,10 +222,10 @@ STAGE PLANS: 0 1 {(KEY.reducesinkkey0 < 10)} 2 - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out Mon Aug 18 17:05:02 2014 @@ -73,10 +73,10 @@ STAGE PLANS: 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} 3 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -154,10 +154,10 @@ STAGE PLANS: 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} 3 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -235,10 +235,10 @@ STAGE PLANS: 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} 3 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -316,10 +316,10 @@ STAGE PLANS: 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} 3 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -389,7 +389,7 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -403,11 +403,11 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col10 (type: string), _col11 (type: string) TableScan alias: c Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -422,12 +422,12 @@ STAGE PLANS: condition map: Left Outer Join0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col15 (type: string), _col16 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -495,7 +495,7 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -509,11 +509,11 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col10 (type: string), _col11 (type: string) TableScan alias: c Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -528,12 +528,12 @@ STAGE PLANS: condition map: Right Outer Join0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col15 (type: string), _col16 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -601,7 +601,7 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -615,11 +615,11 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col8 (type: string), _col9 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col10 (type: string), _col11 (type: string) TableScan alias: c Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -634,12 +634,12 @@ STAGE PLANS: condition map: Outer Join 0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} {VALUE._col7} {VALUE._col8} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} {VALUE._col9} {VALUE._col10} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col12 (type: string), _col13 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col15 (type: string), _col16 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -705,7 +705,7 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -719,11 +719,11 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string) TableScan alias: c Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -738,9 +738,9 @@ STAGE PLANS: condition map: Left Outer Join0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -767,18 +767,18 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) Reduce Operator Tree: Join Operator condition map: Right Outer Join0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8} + 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -842,7 +842,7 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -856,11 +856,11 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string) TableScan alias: c Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -875,9 +875,9 @@ STAGE PLANS: condition map: Left Outer Join0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -904,18 +904,18 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) Reduce Operator Tree: Join Operator condition map: Outer Join 0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8} + 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -979,7 +979,7 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -993,11 +993,11 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string) TableScan alias: c Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -1012,9 +1012,9 @@ STAGE PLANS: condition map: Right Outer Join0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -1041,18 +1041,18 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) Reduce Operator Tree: Join Operator condition map: Left Outer Join0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8} + 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -1116,7 +1116,7 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -1130,11 +1130,11 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string) TableScan alias: c Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -1149,9 +1149,9 @@ STAGE PLANS: condition map: Right Outer Join0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -1178,18 +1178,18 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + value expressions: _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) Reduce Operator Tree: Join Operator condition map: Outer Join 0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col3} {VALUE._col4} {VALUE._col7} {VALUE._col8} + 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col4} {VALUE._col5} {VALUE._col9} {VALUE._col10} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -1254,7 +1254,7 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -1286,24 +1286,24 @@ STAGE PLANS: value expressions: value (type: string) TableScan Reduce Output Operator - key expressions: _col5 (type: string) + key expressions: _col6 (type: string) sort order: + - Map-reduce partition columns: _col5 (type: string) + Map-reduce partition columns: _col6 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string) + value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string) Reduce Operator Tree: Join Operator condition map: Left Outer Join0 to 1 Left Outer Join1 to 2 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {KEY.reducesinkkey0} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9, _col12, _col13 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11, _col15, _col16 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string), _col12 (type: string), _col13 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string), _col15 (type: string), _col16 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out?rev=1618664&r1=1618663&r2=1618664&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out Mon Aug 18 17:05:02 2014 @@ -885,9 +885,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -1382,9 +1382,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -1428,10 +1428,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} 1 {KEY.reducesinkkey0} - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -1706,10 +1706,10 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Map Join Operator @@ -2010,10 +2010,10 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Map Join Operator @@ -2367,9 +2367,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -2864,9 +2864,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -2910,10 +2910,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} 1 {KEY.reducesinkkey0} - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE File Output Operator
