You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2014/10/27 20:57:03 UTC
svn commit: r1634671 [30/46] - in /hive/branches/spark:
itests/src/test/resources/ ql/src/test/results/clientpositive/spark/
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out?rev=1634671&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out Mon Oct 27 19:56:58 2014
@@ -0,0 +1,468 @@
+PREHOOK: query: EXPLAIN
+ FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+ FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((key > '15') and (key < '25')) (type: boolean)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((key > '15') and (key < '25')) (type: boolean)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Right Outer Join0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col5, _col6
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((_col0 > '10') and (_col0 < '20')) and (_col5 > '15')) and (_col5 < '25')) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+150 val_150 150 val_150
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+153 val_153 153 val_153
+155 val_155 155 val_155
+156 val_156 156 val_156
+157 val_157 157 val_157
+158 val_158 158 val_158
+160 val_160 160 val_160
+162 val_162 162 val_162
+163 val_163 163 val_163
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+166 val_166 166 val_166
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+168 val_168 168 val_168
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+17 val_17 17 val_17
+170 val_170 170 val_170
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+177 val_177 177 val_177
+178 val_178 178 val_178
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+180 val_180 180 val_180
+181 val_181 181 val_181
+183 val_183 183 val_183
+186 val_186 186 val_186
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+189 val_189 189 val_189
+19 val_19 19 val_19
+190 val_190 190 val_190
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+192 val_192 192 val_192
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+194 val_194 194 val_194
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+196 val_196 196 val_196
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+2 val_2 2 val_2
+PREHOOK: query: EXPLAIN
+ FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+ FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((key > '15') and (key < '25')) (type: boolean)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((key > '15') and (key < '25')) (type: boolean)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Right Outer Join0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col5, _col6
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((_col0 > '10') and (_col0 < '20')) (type: boolean)
+ Statistics: Num rows: 6 Data size: 64 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 6 Data size: 64 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 64 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: FROM
+ src a
+ RIGHT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+150 val_150 150 val_150
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+153 val_153 153 val_153
+155 val_155 155 val_155
+156 val_156 156 val_156
+157 val_157 157 val_157
+158 val_158 158 val_158
+160 val_160 160 val_160
+162 val_162 162 val_162
+163 val_163 163 val_163
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+166 val_166 166 val_166
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+168 val_168 168 val_168
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+17 val_17 17 val_17
+170 val_170 170 val_170
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+177 val_177 177 val_177
+178 val_178 178 val_178
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+180 val_180 180 val_180
+181 val_181 181 val_181
+183 val_183 183 val_183
+186 val_186 186 val_186
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+189 val_189 189 val_189
+19 val_19 19 val_19
+190 val_190 190 val_190
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+192 val_192 192 val_192
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+194 val_194 194 val_194
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+196 val_196 196 val_196
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+2 val_2 2 val_2
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out?rev=1634671&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out Mon Oct 27 19:56:58 2014
@@ -0,0 +1,456 @@
+PREHOOK: query: EXPLAIN
+ FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+ FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Outer Join 0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col5, _col6
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((_col0 > '10') and (_col0 < '20')) and (_col5 > '15')) and (_col5 < '25')) (type: boolean)
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 63 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+150 val_150 150 val_150
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+153 val_153 153 val_153
+155 val_155 155 val_155
+156 val_156 156 val_156
+157 val_157 157 val_157
+158 val_158 158 val_158
+160 val_160 160 val_160
+162 val_162 162 val_162
+163 val_163 163 val_163
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+166 val_166 166 val_166
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+168 val_168 168 val_168
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+17 val_17 17 val_17
+170 val_170 170 val_170
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+177 val_177 177 val_177
+178 val_178 178 val_178
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+180 val_180 180 val_180
+181 val_181 181 val_181
+183 val_183 183 val_183
+186 val_186 186 val_186
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+189 val_189 189 val_189
+19 val_19 19 val_19
+190 val_190 190 val_190
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+192 val_192 192 val_192
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+194 val_194 194 val_194
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+196 val_196 196 val_196
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+2 val_2 2 val_2
+PREHOOK: query: EXPLAIN
+ FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+ FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Outer Join 0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col5, _col6
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((_col5 > '15') and (_col5 < '25')) and (_col0 > '10')) and (_col0 < '20')) (type: boolean)
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 63 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: FROM
+ src a
+ FULL OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ SELECT a.key, a.value, b.key, b.value
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+150 val_150 150 val_150
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+152 val_152 152 val_152
+153 val_153 153 val_153
+155 val_155 155 val_155
+156 val_156 156 val_156
+157 val_157 157 val_157
+158 val_158 158 val_158
+160 val_160 160 val_160
+162 val_162 162 val_162
+163 val_163 163 val_163
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+164 val_164 164 val_164
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+165 val_165 165 val_165
+166 val_166 166 val_166
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+167 val_167 167 val_167
+168 val_168 168 val_168
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+169 val_169 169 val_169
+17 val_17 17 val_17
+170 val_170 170 val_170
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+172 val_172 172 val_172
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+174 val_174 174 val_174
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+175 val_175 175 val_175
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+176 val_176 176 val_176
+177 val_177 177 val_177
+178 val_178 178 val_178
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+179 val_179 179 val_179
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+18 val_18 18 val_18
+180 val_180 180 val_180
+181 val_181 181 val_181
+183 val_183 183 val_183
+186 val_186 186 val_186
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+187 val_187 187 val_187
+189 val_189 189 val_189
+19 val_19 19 val_19
+190 val_190 190 val_190
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+191 val_191 191 val_191
+192 val_192 192 val_192
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+193 val_193 193 val_193
+194 val_194 194 val_194
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+195 val_195 195 val_195
+196 val_196 196 val_196
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+197 val_197 197 val_197
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+199 val_199 199 val_199
+2 val_2 2 val_2
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out?rev=1634671&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out Mon Oct 27 19:56:58 2014
@@ -0,0 +1,730 @@
+PREHOOK: query: EXPLAIN
+ FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+ FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1), Map 4 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (sqrt(key) <> 13) (type: boolean)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: c
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (sqrt(key) <> 13) (type: boolean)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (sqrt(key) <> 13) (type: boolean)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ Right Outer Join0 to 2
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0}
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10
+ Statistics: Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((((_col0 > '10') and (_col0 < '20')) and (_col5 > '15')) and (_col5 < '25')) and (sqrt(_col10) <> 13)) (type: boolean)
+ Statistics: Num rows: 13 Data size: 138 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics: Num rows: 13 Data size: 138 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 13 Data size: 138 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+150 val_150 150 val_150 150
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+153 val_153 153 val_153 153
+155 val_155 155 val_155 155
+156 val_156 156 val_156 156
+157 val_157 157 val_157 157
+158 val_158 158 val_158 158
+160 val_160 160 val_160 160
+162 val_162 162 val_162 162
+163 val_163 163 val_163 163
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+166 val_166 166 val_166 166
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+168 val_168 168 val_168 168
+17 val_17 17 val_17 17
+170 val_170 170 val_170 170
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+177 val_177 177 val_177 177
+178 val_178 178 val_178 178
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+180 val_180 180 val_180 180
+181 val_181 181 val_181 181
+183 val_183 183 val_183 183
+186 val_186 186 val_186 186
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+189 val_189 189 val_189 189
+19 val_19 19 val_19 19
+190 val_190 190 val_190 190
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+192 val_192 192 val_192 192
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+194 val_194 194 val_194 194
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+196 val_196 196 val_196 196
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+2 val_2 2 val_2 2
+PREHOOK: query: EXPLAIN
+ FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+ FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1), Map 4 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (sqrt(key) <> 13) (type: boolean)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: c
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (sqrt(key) <> 13) (type: boolean)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: a
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (sqrt(key) <> 13) (type: boolean)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ Right Outer Join0 to 2
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ 2 {KEY.reducesinkkey0}
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10
+ Statistics: Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((_col5 > '15') and (_col5 < '25')) and (_col0 > '10')) and (_col0 < '20')) (type: boolean)
+ Statistics: Num rows: 13 Data size: 138 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics: Num rows: 13 Data size: 138 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 13 Data size: 138 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: FROM
+ src a
+ LEFT OUTER JOIN
+ src b
+ ON (a.key = b.key)
+ RIGHT OUTER JOIN
+ src c
+ ON (a.key = c.key)
+ SELECT a.key, a.value, b.key, b.value, c.key
+ WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+150 val_150 150 val_150 150
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+152 val_152 152 val_152 152
+153 val_153 153 val_153 153
+155 val_155 155 val_155 155
+156 val_156 156 val_156 156
+157 val_157 157 val_157 157
+158 val_158 158 val_158 158
+160 val_160 160 val_160 160
+162 val_162 162 val_162 162
+163 val_163 163 val_163 163
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+164 val_164 164 val_164 164
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+165 val_165 165 val_165 165
+166 val_166 166 val_166 166
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+167 val_167 167 val_167 167
+168 val_168 168 val_168 168
+17 val_17 17 val_17 17
+170 val_170 170 val_170 170
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+172 val_172 172 val_172 172
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+174 val_174 174 val_174 174
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+175 val_175 175 val_175 175
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+176 val_176 176 val_176 176
+177 val_177 177 val_177 177
+178 val_178 178 val_178 178
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+179 val_179 179 val_179 179
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+18 val_18 18 val_18 18
+180 val_180 180 val_180 180
+181 val_181 181 val_181 181
+183 val_183 183 val_183 183
+186 val_186 186 val_186 186
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+187 val_187 187 val_187 187
+189 val_189 189 val_189 189
+19 val_19 19 val_19 19
+190 val_190 190 val_190 190
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+191 val_191 191 val_191 191
+192 val_192 192 val_192 192
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+193 val_193 193 val_193 193
+194 val_194 194 val_194 194
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+195 val_195 195 val_195 195
+196 val_196 196 val_196 196
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+197 val_197 197 val_197 197
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+199 val_199 199 val_199 199
+2 val_2 2 val_2 2
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out?rev=1634671&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out Mon Oct 27 19:56:58 2014
@@ -0,0 +1,320 @@
+PREHOOK: query: create table t1 (id int, key string, value string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
+POSTHOOK: query: create table t1 (id int, key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t1
+PREHOOK: query: create table t2 (id int, key string, value string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
+POSTHOOK: query: create table t2 (id int, key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t2
+PREHOOK: query: create table t3 (id int, key string, value string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t3
+POSTHOOK: query: create table t3 (id int, key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t3
+PREHOOK: query: create table t4 (id int, key string, value string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t4
+POSTHOOK: query: create table t4 (id int, key string, value string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t4
+PREHOOK: query: explain select * from t1 full outer join t2 on t1.id=t2.id join t3 on t2.id=t3.id where t3.id=20
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select * from t1 full outer join t2 on t1.id=t2.id join t3 on t2.id=t3.id where t3.id=20
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1), Map 4 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: t3
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: 20 (type: int)
+ sort order: +
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: t2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: id (type: int)
+ sort order: +
+ Map-reduce partition columns: id (type: int)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: t1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: id (type: int)
+ sort order: +
+ Map-reduce partition columns: id (type: int)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Outer Join 0 to 1
+ Inner Join 1 to 2
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+ 1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+ 2 {VALUE._col0} {VALUE._col1}
+ outputColumnNames: _col0, _col1, _col2, _col6, _col7, _col8, _col13, _col14
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col6 (type: int), _col7 (type: string), _col8 (type: string), 20 (type: int), _col13 (type: string), _col14 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: explain select * from t1 join t2 on (t1.id=t2.id) left outer join t3 on (t2.id=t3.id) where t2.id=20
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select * from t1 join t2 on (t1.id=t2.id) left outer join t3 on (t2.id=t3.id) where t2.id=20
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1), Map 4 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: t3
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: id (type: int)
+ sort order: +
+ Map-reduce partition columns: id (type: int)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: t2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: 20 (type: int)
+ sort order: +
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: t1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: 20 (type: int)
+ sort order: +
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Left Outer Join1 to 2
+ condition expressions:
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
+ 2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+ outputColumnNames: _col1, _col2, _col7, _col8, _col12, _col13, _col14
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col7 (type: string), _col8 (type: string), _col12 (type: int), _col13 (type: string), _col14 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: explain select * from t1 join t2 on (t1.id=t2.id) left outer join t3 on (t1.id=t3.id) where t2.id=20
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select * from t1 join t2 on (t1.id=t2.id) left outer join t3 on (t1.id=t3.id) where t2.id=20
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Map 3 (GROUP PARTITION-LEVEL SORT, 1), Map 4 (GROUP PARTITION-LEVEL SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: t3
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: id (type: int)
+ sort order: +
+ Map-reduce partition columns: id (type: int)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: t2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: 20 (type: int)
+ sort order: +
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Map 4
+ Map Operator Tree:
+ TableScan
+ alias: t1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Filter Operator
+ predicate: (id = 20) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: 20 (type: int)
+ sort order: +
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: key (type: string), value (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ Left Outer Join0 to 2
+ condition expressions:
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
+ 2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+ outputColumnNames: _col1, _col2, _col7, _col8, _col12, _col13, _col14
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col7 (type: string), _col8 (type: string), _col12 (type: int), _col13 (type: string), _col14 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: drop table t1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@t1
+PREHOOK: Output: default@t1
+POSTHOOK: query: drop table t1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@t1
+POSTHOOK: Output: default@t1
+PREHOOK: query: drop table t2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@t2
+PREHOOK: Output: default@t2
+POSTHOOK: query: drop table t2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@t2
+POSTHOOK: Output: default@t2
+PREHOOK: query: drop table t3
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@t3
+PREHOOK: Output: default@t3
+POSTHOOK: query: drop table t3
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@t3
+POSTHOOK: Output: default@t3
+PREHOOK: query: drop table t4
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@t4
+PREHOOK: Output: default@t4
+POSTHOOK: query: drop table t4
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@t4
+POSTHOOK: Output: default@t4
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/reduce_deduplicate_exclude_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/reduce_deduplicate_exclude_join.q.out?rev=1634671&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/reduce_deduplicate_exclude_join.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/reduce_deduplicate_exclude_join.q.out Mon Oct 27 19:56:58 2014
@@ -0,0 +1,91 @@
+PREHOOK: query: explain select * from (select * from src cluster by key) a join src b on a.key = b.key limit 1
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select * from (select * from src cluster by key) a join src b on a.key = b.key limit 1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Spark
+ Edges:
+ Reducer 2 <- Map 1 (GROUP PARTITION-LEVEL SORT, 1), Reducer 4 (GROUP PARTITION-LEVEL SORT, 1)
+ Reducer 4 <- Map 3 (GROUP SORT, 1)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: src
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+ Reducer 2
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1 {KEY.reducesinkkey0} {VALUE._col0}
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Limit
+ Number of rows: 1
+ Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 10 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
+ Reducer 4
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 1
+ Processor Tree:
+ ListSink
+
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out?rev=1634671&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/router_join_ppr.q.out Mon Oct 27 19:56:58 2014 differ