[09/13] hive git commit: HIVE-19128 : Update golden files for spark perf tests

[hashutosh]

http://git-wip-us.apache.org/repos/asf/hive/blob/9ce42cba/ql/src/test/results/clientpositive/perf/spark/query47.q.out
--
diff --git a/ql/src/test/results/clientpositive/perf/spark/query47.q.out 
b/ql/src/test/results/clientpositive/perf/spark/query47.q.out
index 5175f80..bc97fdf 100644
--- a/ql/src/test/results/clientpositive/perf/spark/query47.q.out
+++ b/ql/src/test/results/clientpositive/perf/spark/query47.q.out
@@ -397,47 +397,47 @@ STAGE PLANS:
   Statistics: Num rows: 766650239 Data size: 67634106676 Basic 
stats: COMPLETE Column stats: NONE
   Group By Operator
 aggregations: sum(_col3)
-keys: _col5 (type: int), _col6 (type: int), _col8 (type: 
string), _col9 (type: string), _col11 (type: string), _col12 (type: string)
+keys: _col11 (type: string), _col12 (type: string), _col8 
(type: string), _col9 (type: string), _col5 (type: int), _col6 (type: int)
 mode: hash
 outputColumnNames: _col0, _col1, _col2, _col3, _col4, 
_col5, _col6
 Statistics: Num rows: 766650239 Data size: 67634106676 
Basic stats: COMPLETE Column stats: NONE
 Reduce Output Operator
-  key expressions: _col0 (type: int), _col1 (type: int), 
_col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: 
string)
+  key expressions: _col0 (type: string), _col1 (type: 
string), _col2 (type: string), _col3 (type: string), _col4 (type: int), _col5 
(type: int)
   sort order: ++
-  Map-reduce partition columns: _col0 (type: int), _col1 
(type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), 
_col5 (type: string)
+  Map-reduce partition columns: _col0 (type: string), 
_col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: 
int), _col5 (type: int)
   Statistics: Num rows: 766650239 Data size: 67634106676 
Basic stats: COMPLETE Column stats: NONE
   value expressions: _col6 (type: decimal(17,2))
 Reducer 14 
 Reduce Operator Tree:
   Group By Operator
 aggregations: sum(VALUE._col0)
-keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 
(type: string), KEY._col3 (type: string), KEY._col4 (type: string), KEY._col5 
(type: string)
+keys: KEY._col0 (type: string), KEY._col1 (type: string), 
KEY._col2 (type: string), KEY._col3 (type: string), KEY._col4 (type: int), 
KEY._col5 (type: int)
 mode: mergepartial
 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6
 Statistics: Num rows: 383325119 Data size: 33817053293 Basic 
stats: COMPLETE Column stats: NONE
 Reduce Output Operator
-  key expressions: _col3 (type: string), _col2 (type: string), 
_col4 (type: string), _col5 (type: string), _col0 (type: int)
+  key expressions: _col3 (type: string), _col2 (type: string), 
_col0 (type: string), _col1 (type: string), _col4 (type: int)
   sort order: +
-  Map-reduce partition columns: _col3 (type: string), _col2 
(type: string), _col4 (type: string), _col5 (type: string), _col0 (type: int)
+  Map-reduce partition columns: _col3 (type: string), _col2 
(type: string), _col0 (type: string), _col1 (type: string), _col4 (type: int)
   Statistics: Num rows: 383325119 Data size: 33817053293 Basic 
stats: COMPLETE Column stats: NONE
-  value expressions: _col1 (type: int), _col6 (type: 
decimal(17,2))
+  value expressions: _col5 (type: int), _col6 (type: 
decimal(17,2))
 Reducer 15 
 Reduce Operator Tree:
   Select Operator
-expressions: KEY.reducesinkkey4 (type: int), VALUE._col0 
(type: int), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey0 (type: 
string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), 
VALUE._col1 (type: decimal(17,2))
+expressions: KEY.reducesinkkey2 (type: string), 
KEY.reducesinkkey3 (type: string), KEY.reducesinkkey1 (type: string), 
KEY.reducesinkkey0 (type: string), KEY.reducesinkkey4 (type: int), VALUE._col0 
(type: int), VALUE._col1 (type: decimal(17,2))
 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6
 Statistics: Num rows: 383325119 Data size: 33817053293 Basic 
stats: COMPLETE Column stats: NONE
 PTF Operator
   Function definitions:
   Input definition
 input alias: ptf_0
-output shape: _col0: int, _col1: int, _col2: string, 
_col3: string, _col4: string

[09/13] hive git commit: HIVE-19128 : Update golden files for spark perf tests

[hashutosh]

http://git-wip-us.apache.org/repos/asf/hive/blob/328d3f93/ql/src/test/results/clientpositive/perf/spark/query47.q.out
--
diff --git a/ql/src/test/results/clientpositive/perf/spark/query47.q.out 
b/ql/src/test/results/clientpositive/perf/spark/query47.q.out
index 5175f80..bc97fdf 100644
--- a/ql/src/test/results/clientpositive/perf/spark/query47.q.out
+++ b/ql/src/test/results/clientpositive/perf/spark/query47.q.out
@@ -397,47 +397,47 @@ STAGE PLANS:
   Statistics: Num rows: 766650239 Data size: 67634106676 Basic 
stats: COMPLETE Column stats: NONE
   Group By Operator
 aggregations: sum(_col3)
-keys: _col5 (type: int), _col6 (type: int), _col8 (type: 
string), _col9 (type: string), _col11 (type: string), _col12 (type: string)
+keys: _col11 (type: string), _col12 (type: string), _col8 
(type: string), _col9 (type: string), _col5 (type: int), _col6 (type: int)
 mode: hash
 outputColumnNames: _col0, _col1, _col2, _col3, _col4, 
_col5, _col6
 Statistics: Num rows: 766650239 Data size: 67634106676 
Basic stats: COMPLETE Column stats: NONE
 Reduce Output Operator
-  key expressions: _col0 (type: int), _col1 (type: int), 
_col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: 
string)
+  key expressions: _col0 (type: string), _col1 (type: 
string), _col2 (type: string), _col3 (type: string), _col4 (type: int), _col5 
(type: int)
   sort order: ++
-  Map-reduce partition columns: _col0 (type: int), _col1 
(type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), 
_col5 (type: string)
+  Map-reduce partition columns: _col0 (type: string), 
_col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: 
int), _col5 (type: int)
   Statistics: Num rows: 766650239 Data size: 67634106676 
Basic stats: COMPLETE Column stats: NONE
   value expressions: _col6 (type: decimal(17,2))
 Reducer 14 
 Reduce Operator Tree:
   Group By Operator
 aggregations: sum(VALUE._col0)
-keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 
(type: string), KEY._col3 (type: string), KEY._col4 (type: string), KEY._col5 
(type: string)
+keys: KEY._col0 (type: string), KEY._col1 (type: string), 
KEY._col2 (type: string), KEY._col3 (type: string), KEY._col4 (type: int), 
KEY._col5 (type: int)
 mode: mergepartial
 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6
 Statistics: Num rows: 383325119 Data size: 33817053293 Basic 
stats: COMPLETE Column stats: NONE
 Reduce Output Operator
-  key expressions: _col3 (type: string), _col2 (type: string), 
_col4 (type: string), _col5 (type: string), _col0 (type: int)
+  key expressions: _col3 (type: string), _col2 (type: string), 
_col0 (type: string), _col1 (type: string), _col4 (type: int)
   sort order: +
-  Map-reduce partition columns: _col3 (type: string), _col2 
(type: string), _col4 (type: string), _col5 (type: string), _col0 (type: int)
+  Map-reduce partition columns: _col3 (type: string), _col2 
(type: string), _col0 (type: string), _col1 (type: string), _col4 (type: int)
   Statistics: Num rows: 383325119 Data size: 33817053293 Basic 
stats: COMPLETE Column stats: NONE
-  value expressions: _col1 (type: int), _col6 (type: 
decimal(17,2))
+  value expressions: _col5 (type: int), _col6 (type: 
decimal(17,2))
 Reducer 15 
 Reduce Operator Tree:
   Select Operator
-expressions: KEY.reducesinkkey4 (type: int), VALUE._col0 
(type: int), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey0 (type: 
string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), 
VALUE._col1 (type: decimal(17,2))
+expressions: KEY.reducesinkkey2 (type: string), 
KEY.reducesinkkey3 (type: string), KEY.reducesinkkey1 (type: string), 
KEY.reducesinkkey0 (type: string), KEY.reducesinkkey4 (type: int), VALUE._col0 
(type: int), VALUE._col1 (type: decimal(17,2))
 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, 
_col6
 Statistics: Num rows: 383325119 Data size: 33817053293 Basic 
stats: COMPLETE Column stats: NONE
 PTF Operator
   Function definitions:
   Input definition
 input alias: ptf_0
-output shape: _col0: int, _col1: int, _col2: string, 
_col3: string, _col4: string