You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2015/10/13 02:13:04 UTC
[39/51] [abbrv] hive git commit: HIVE-12042 : LLAP: update some out
files (Sergey Shelukhin) ADDENDUM
HIVE-12042 : LLAP: update some out files (Sergey Shelukhin) ADDENDUM
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/7a239137
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/7a239137
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/7a239137
Branch: refs/heads/master
Commit: 7a2391376e8f8aeefa78a2e0a1d0293809c80df5
Parents: b861b9e
Author: Sergey Shelukhin <se...@apache.org>
Authored: Wed Oct 7 16:35:13 2015 -0700
Committer: Sergey Shelukhin <se...@apache.org>
Committed: Wed Oct 7 16:35:13 2015 -0700
----------------------------------------------------------------------
.../clientpositive/llap/explainuser_1.q.out | 76 ++++++++++----------
1 file changed, 38 insertions(+), 38 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/7a239137/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
index 789180a..3ca2f50 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
@@ -1986,7 +1986,7 @@ Stage-0
Statistics:Num rows: 4 Data size: 728 Basic stats: COMPLETE Column stats: COMPLETE
value expressions:_col1 (type: int), _col2 (type: float), _col3 (type: string), _col4 (type: int)
Filter Operator [FIL_27]
- predicate:((((_col1 + _col4) = 2) and ((_col4 + 1) = 2)) and _col0 is not null) (type: boolean)
+ predicate:((((_col1 + _col4) = 2) and _col0 is not null) and ((_col4 + 1) = 2)) (type: boolean)
Statistics:Num rows: 4 Data size: 728 Basic stats: COMPLETE Column stats: COMPLETE
Merge Join Operator [MERGEJOIN_31]
| condition map:[{"":"Outer Join 0 to 1"}]
@@ -2797,7 +2797,7 @@ Stage-0
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
| Filter Operator [FIL_61]
- | predicate:(((UDFToDouble(_col0) >= 1.0) or (_col3 >= 1)) and ((UDFToDouble(_col0) + UDFToDouble(_col3)) >= 0.0)) (type: boolean)
+ | predicate:(((UDFToDouble(_col0) + UDFToDouble(_col3)) >= 0.0) and ((UDFToDouble(_col0) >= 1.0) or (_col3 >= 1))) (type: boolean)
| Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
| Select Operator [SEL_65]
| outputColumnNames:["_col0","_col1","_col3"]
@@ -4240,7 +4240,7 @@ Stage-0
Select Operator [SEL_13]
Statistics:Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator [FIL_45]
- predicate:(((_col2 - _col1) > 600.0) and (_col0 is null or _col1 is null)) (type: boolean)
+ predicate:((_col0 is null or _col1 is null) and ((_col2 - _col1) > 600.0)) (type: boolean)
Statistics:Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator [GBY_11]
| aggregations:["min(VALUE._col0)","max(VALUE._col1)"]
@@ -6031,36 +6031,36 @@ Stage-0
Reducer 2
File Output Operator [FS_6]
compressed:true
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator [MERGEJOIN_7]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"key (type: int)","1":"key (type: int)"}
| outputColumnNames:["_col0","_col1","_col5","_col6"]
- | Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_2]
| key expressions:key (type: int)
| Map-reduce partition columns:key (type: int)
| sort order:+
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
| value expressions:value (type: int)
| TableScan [TS_0]
| alias:a
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
|<-Map 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_3]
key expressions:key (type: int)
Map-reduce partition columns:key (type: int)
sort order:+
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
value expressions:value (type: int)
TableScan [TS_1]
alias:b
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
PREHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key <=> b.key AND a.value <=> b.value
PREHOOK: type: QUERY
@@ -6078,34 +6078,34 @@ Stage-0
Reducer 2
File Output Operator [FS_6]
compressed:true
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator [MERGEJOIN_7]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"key (type: int), value (type: int)","1":"key (type: int), value (type: int)"}
| outputColumnNames:["_col0","_col1","_col5","_col6"]
- | Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_2]
| key expressions:key (type: int), value (type: int)
| Map-reduce partition columns:key (type: int), value (type: int)
| sort order:++
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_0]
| alias:a
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
|<-Map 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_3]
key expressions:key (type: int), value (type: int)
Map-reduce partition columns:key (type: int), value (type: int)
sort order:++
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_1]
alias:b
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
PREHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key <=> b.key
PREHOOK: type: QUERY
@@ -6123,36 +6123,36 @@ Stage-0
Reducer 2
File Output Operator [FS_6]
compressed:true
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator [MERGEJOIN_7]
| condition map:[{"":"Right Outer Join0 to 1"}]
| keys:{"0":"key (type: int)","1":"key (type: int)"}
| outputColumnNames:["_col0","_col1","_col5","_col6"]
- | Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_2]
| key expressions:key (type: int)
| Map-reduce partition columns:key (type: int)
| sort order:+
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
| value expressions:value (type: int)
| TableScan [TS_0]
| alias:a
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
|<-Map 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_3]
key expressions:key (type: int)
Map-reduce partition columns:key (type: int)
sort order:+
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
value expressions:value (type: int)
TableScan [TS_1]
alias:b
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key <=> b.key
PREHOOK: type: QUERY
@@ -6170,36 +6170,36 @@ Stage-0
Reducer 2
File Output Operator [FS_6]
compressed:true
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator [MERGEJOIN_7]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"key (type: int)","1":"key (type: int)"}
| outputColumnNames:["_col0","_col1","_col5","_col6"]
- | Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_2]
| key expressions:key (type: int)
| Map-reduce partition columns:key (type: int)
| sort order:+
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
| value expressions:value (type: int)
| TableScan [TS_0]
| alias:a
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
|<-Map 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_3]
key expressions:key (type: int)
Map-reduce partition columns:key (type: int)
sort order:+
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
value expressions:value (type: int)
TableScan [TS_1]
alias:b
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key <=> b.key
PREHOOK: type: QUERY
@@ -6217,36 +6217,36 @@ Stage-0
Reducer 2
File Output Operator [FS_6]
compressed:true
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1","_col2","_col3"]
- Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
Merge Join Operator [MERGEJOIN_7]
| condition map:[{"":"Left Outer Join0 to 1"}]
| keys:{"0":"key (type: int)","1":"key (type: int)"}
| outputColumnNames:["_col0","_col1","_col5","_col6"]
- | Statistics:Num rows: 28 Data size: 209 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 24 Data size: 174 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
| Reduce Output Operator [RS_2]
| key expressions:key (type: int)
| Map-reduce partition columns:key (type: int)
| sort order:+
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
| value expressions:value (type: int)
| TableScan [TS_0]
| alias:a
- | Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
|<-Map 3 [SIMPLE_EDGE]
Reduce Output Operator [RS_3]
key expressions:key (type: int)
Map-reduce partition columns:key (type: int)
sort order:+
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
value expressions:value (type: int)
TableScan [TS_1]
alias:b
- Statistics:Num rows: 26 Data size: 190 Basic stats: COMPLETE Column stats: NONE
+ Statistics:Num rows: 22 Data size: 159 Basic stats: COMPLETE Column stats: NONE
PREHOOK: query: drop table sales
PREHOOK: type: DROPTABLE