/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/smb_mapjoin_4.q.out
text | 1262 lines | 1197 code | 65 blank | 0 comment | 0 complexity | c2d13e08e4de879779bfb6db2a0514f0 MD5 | raw file
1PREHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE 2PREHOOK: type: CREATETABLE 3POSTHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE 4POSTHOOK: type: CREATETABLE 5POSTHOOK: Output: default@smb_bucket_1 6PREHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE 7PREHOOK: type: CREATETABLE 8POSTHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE 9POSTHOOK: type: CREATETABLE 10POSTHOOK: Output: default@smb_bucket_2 11PREHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE 12PREHOOK: type: CREATETABLE 13POSTHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE 14POSTHOOK: type: CREATETABLE 15POSTHOOK: Output: default@smb_bucket_3 16PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1 17PREHOOK: type: LOAD 18PREHOOK: Output: default@smb_bucket_1 19POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1 20POSTHOOK: type: LOAD 21POSTHOOK: Output: default@smb_bucket_1 22PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2 23PREHOOK: type: LOAD 24PREHOOK: Output: default@smb_bucket_2 25POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2 26POSTHOOK: type: LOAD 27POSTHOOK: Output: default@smb_bucket_2 28PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3 29PREHOOK: type: LOAD 30PREHOOK: Output: default@smb_bucket_3 31POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3 32POSTHOOK: type: LOAD 33POSTHOOK: Output: default@smb_bucket_3 34PREHOOK: query: explain 35select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 36PREHOOK: type: QUERY 37POSTHOOK: query: explain 38select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 39POSTHOOK: type: QUERY 40ABSTRACT SYNTAX TREE: 41 (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 42 43STAGE DEPENDENCIES: 44 Stage-1 is a root stage 45 Stage-0 is a root stage 46 47STAGE PLANS: 48 Stage: Stage-1 49 Map Reduce 50 Alias -> Map Operator Tree: 51 c 52 TableScan 53 alias: c 54 Sorted Merge Bucket Map Join Operator 55 condition map: 56 Inner Join 0 to 1 57 Inner Join 1 to 2 58 condition expressions: 59 0 {key} {value} 60 1 {key} {value} 61 2 {key} {value} 62 handleSkewJoin: false 63 keys: 64 0 [Column[key]] 65 1 [Column[key]] 66 2 [Column[key]] 67 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 68 Position of Big Table: 2 69 Select Operator 70 expressions: 71 expr: _col0 72 type: int 73 expr: _col1 74 type: string 75 expr: _col4 76 type: int 77 expr: _col5 78 type: string 79 expr: _col8 80 type: int 81 expr: _col9 82 type: string 83 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 84 Select Operator 85 expressions: 86 expr: _col0 87 type: int 88 expr: _col1 89 type: string 90 expr: _col4 91 type: int 92 expr: _col5 93 type: string 94 expr: _col8 95 type: int 96 expr: _col9 97 type: string 98 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 99 File Output Operator 100 compressed: false 101 GlobalTableId: 0 102 table: 103 input format: org.apache.hadoop.mapred.TextInputFormat 104 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 105 106 Stage: Stage-0 107 Fetch Operator 108 limit: -1 109 110 111PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 112PREHOOK: type: QUERY 113PREHOOK: Input: default@smb_bucket_1 114PREHOOK: Input: default@smb_bucket_2 115PREHOOK: Input: default@smb_bucket_3 116PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-49_321_3966901017045056953/-mr-10000 117POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 118POSTHOOK: type: QUERY 119POSTHOOK: Input: default@smb_bucket_1 120POSTHOOK: Input: default@smb_bucket_2 121POSTHOOK: Input: default@smb_bucket_3 122POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-49_321_3966901017045056953/-mr-10000 123PREHOOK: query: explain 124select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 125PREHOOK: type: QUERY 126POSTHOOK: query: explain 127select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 128POSTHOOK: type: QUERY 129ABSTRACT SYNTAX TREE: 130 (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 131 132STAGE DEPENDENCIES: 133 Stage-1 is a root stage 134 Stage-0 is a root stage 135 136STAGE PLANS: 137 Stage: Stage-1 138 Map Reduce 139 Alias -> Map Operator Tree: 140 c 141 TableScan 142 alias: c 143 Sorted Merge Bucket Map Join Operator 144 condition map: 145 Left Outer Join0 to 1 146 Inner Join 1 to 2 147 condition expressions: 148 0 {key} {value} 149 1 {key} {value} 150 2 {key} {value} 151 handleSkewJoin: false 152 keys: 153 0 [Column[key]] 154 1 [Column[key]] 155 2 [Column[key]] 156 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 157 Position of Big Table: 2 158 Select Operator 159 expressions: 160 expr: _col0 161 type: int 162 expr: _col1 163 type: string 164 expr: _col4 165 type: int 166 expr: _col5 167 type: string 168 expr: _col8 169 type: int 170 expr: _col9 171 type: string 172 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 173 Select Operator 174 expressions: 175 expr: _col0 176 type: int 177 expr: _col1 178 type: string 179 expr: _col4 180 type: int 181 expr: _col5 182 type: string 183 expr: _col8 184 type: int 185 expr: _col9 186 type: string 187 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 188 File Output Operator 189 compressed: false 190 GlobalTableId: 0 191 table: 192 input format: org.apache.hadoop.mapred.TextInputFormat 193 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 194 195 Stage: Stage-0 196 Fetch Operator 197 limit: -1 198 199 200PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 201PREHOOK: type: QUERY 202PREHOOK: Input: default@smb_bucket_1 203PREHOOK: Input: default@smb_bucket_2 204PREHOOK: Input: default@smb_bucket_3 205PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-52_609_7903256946036561523/-mr-10000 206POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 207POSTHOOK: type: QUERY 208POSTHOOK: Input: default@smb_bucket_1 209POSTHOOK: Input: default@smb_bucket_2 210POSTHOOK: Input: default@smb_bucket_3 211POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-52_609_7903256946036561523/-mr-10000 212PREHOOK: query: explain 213select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 214PREHOOK: type: QUERY 215POSTHOOK: query: explain 216select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 217POSTHOOK: type: QUERY 218ABSTRACT SYNTAX TREE: 219 (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 220 221STAGE DEPENDENCIES: 222 Stage-1 is a root stage 223 Stage-0 is a root stage 224 225STAGE PLANS: 226 Stage: Stage-1 227 Map Reduce 228 Alias -> Map Operator Tree: 229 c 230 TableScan 231 alias: c 232 Sorted Merge Bucket Map Join Operator 233 condition map: 234 Left Outer Join0 to 1 235 Left Outer Join1 to 2 236 condition expressions: 237 0 {key} {value} 238 1 {key} {value} 239 2 {key} {value} 240 handleSkewJoin: false 241 keys: 242 0 [Column[key]] 243 1 [Column[key]] 244 2 [Column[key]] 245 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 246 Position of Big Table: 2 247 Select Operator 248 expressions: 249 expr: _col0 250 type: int 251 expr: _col1 252 type: string 253 expr: _col4 254 type: int 255 expr: _col5 256 type: string 257 expr: _col8 258 type: int 259 expr: _col9 260 type: string 261 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 262 Select Operator 263 expressions: 264 expr: _col0 265 type: int 266 expr: _col1 267 type: string 268 expr: _col4 269 type: int 270 expr: _col5 271 type: string 272 expr: _col8 273 type: int 274 expr: _col9 275 type: string 276 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 277 File Output Operator 278 compressed: false 279 GlobalTableId: 0 280 table: 281 input format: org.apache.hadoop.mapred.TextInputFormat 282 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 283 284 Stage: Stage-0 285 Fetch Operator 286 limit: -1 287 288 289PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 290PREHOOK: type: QUERY 291PREHOOK: Input: default@smb_bucket_1 292PREHOOK: Input: default@smb_bucket_2 293PREHOOK: Input: default@smb_bucket_3 294PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-55_833_4731338482914814383/-mr-10000 295POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 296POSTHOOK: type: QUERY 297POSTHOOK: Input: default@smb_bucket_1 298POSTHOOK: Input: default@smb_bucket_2 299POSTHOOK: Input: default@smb_bucket_3 300POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-55_833_4731338482914814383/-mr-10000 3011 val_1 NULL NULL NULL NULL 3023 val_3 NULL NULL NULL NULL 3034 val_4 NULL NULL NULL NULL 3045 val_5 NULL NULL NULL NULL 30510 val_10 NULL NULL NULL NULL 306PREHOOK: query: explain 307select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 308PREHOOK: type: QUERY 309POSTHOOK: query: explain 310select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 311POSTHOOK: type: QUERY 312ABSTRACT SYNTAX TREE: 313 (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 314 315STAGE DEPENDENCIES: 316 Stage-1 is a root stage 317 Stage-0 is a root stage 318 319STAGE PLANS: 320 Stage: Stage-1 321 Map Reduce 322 Alias -> Map Operator Tree: 323 c 324 TableScan 325 alias: c 326 Sorted Merge Bucket Map Join Operator 327 condition map: 328 Left Outer Join0 to 1 329 Right Outer Join1 to 2 330 condition expressions: 331 0 {key} {value} 332 1 {key} {value} 333 2 {key} {value} 334 handleSkewJoin: false 335 keys: 336 0 [Column[key]] 337 1 [Column[key]] 338 2 [Column[key]] 339 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 340 Position of Big Table: 2 341 Select Operator 342 expressions: 343 expr: _col0 344 type: int 345 expr: _col1 346 type: string 347 expr: _col4 348 type: int 349 expr: _col5 350 type: string 351 expr: _col8 352 type: int 353 expr: _col9 354 type: string 355 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 356 Select Operator 357 expressions: 358 expr: _col0 359 type: int 360 expr: _col1 361 type: string 362 expr: _col4 363 type: int 364 expr: _col5 365 type: string 366 expr: _col8 367 type: int 368 expr: _col9 369 type: string 370 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 371 File Output Operator 372 compressed: false 373 GlobalTableId: 0 374 table: 375 input format: org.apache.hadoop.mapred.TextInputFormat 376 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 377 378 Stage: Stage-0 379 Fetch Operator 380 limit: -1 381 382 383PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 384PREHOOK: type: QUERY 385PREHOOK: Input: default@smb_bucket_1 386PREHOOK: Input: default@smb_bucket_2 387PREHOOK: Input: default@smb_bucket_3 388PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-59_060_6885897898144326961/-mr-10000 389POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 390POSTHOOK: type: QUERY 391POSTHOOK: Input: default@smb_bucket_1 392POSTHOOK: Input: default@smb_bucket_2 393POSTHOOK: Input: default@smb_bucket_3 394POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-59_060_6885897898144326961/-mr-10000 395NULL NULL NULL NULL 4 val_4 396NULL NULL NULL NULL 10 val_10 397NULL NULL NULL NULL 17 val_17 398NULL NULL NULL NULL 19 val_19 399NULL NULL NULL NULL 20 val_20 400NULL NULL NULL NULL 23 val_23 401PREHOOK: query: explain 402select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 403PREHOOK: type: QUERY 404POSTHOOK: query: explain 405select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 406POSTHOOK: type: QUERY 407ABSTRACT SYNTAX TREE: 408 (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 409 410STAGE DEPENDENCIES: 411 Stage-1 is a root stage 412 Stage-0 is a root stage 413 414STAGE PLANS: 415 Stage: Stage-1 416 Map Reduce 417 Alias -> Map Operator Tree: 418 c 419 TableScan 420 alias: c 421 Sorted Merge Bucket Map Join Operator 422 condition map: 423 Left Outer Join0 to 1 424 Outer Join 1 to 2 425 condition expressions: 426 0 {key} {value} 427 1 {key} {value} 428 2 {key} {value} 429 handleSkewJoin: false 430 keys: 431 0 [Column[key]] 432 1 [Column[key]] 433 2 [Column[key]] 434 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 435 Position of Big Table: 2 436 Select Operator 437 expressions: 438 expr: _col0 439 type: int 440 expr: _col1 441 type: string 442 expr: _col4 443 type: int 444 expr: _col5 445 type: string 446 expr: _col8 447 type: int 448 expr: _col9 449 type: string 450 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 451 Select Operator 452 expressions: 453 expr: _col0 454 type: int 455 expr: _col1 456 type: string 457 expr: _col4 458 type: int 459 expr: _col5 460 type: string 461 expr: _col8 462 type: int 463 expr: _col9 464 type: string 465 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 466 File Output Operator 467 compressed: false 468 GlobalTableId: 0 469 table: 470 input format: org.apache.hadoop.mapred.TextInputFormat 471 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 472 473 Stage: Stage-0 474 Fetch Operator 475 limit: -1 476 477 478PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 479PREHOOK: type: QUERY 480PREHOOK: Input: default@smb_bucket_1 481PREHOOK: Input: default@smb_bucket_2 482PREHOOK: Input: default@smb_bucket_3 483PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-02_477_3066768832500086224/-mr-10000 484POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 485POSTHOOK: type: QUERY 486POSTHOOK: Input: default@smb_bucket_1 487POSTHOOK: Input: default@smb_bucket_2 488POSTHOOK: Input: default@smb_bucket_3 489POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-02_477_3066768832500086224/-mr-10000 4901 val_1 NULL NULL NULL NULL 4913 val_3 NULL NULL NULL NULL 4924 val_4 NULL NULL NULL NULL 493NULL NULL NULL NULL 4 val_4 4945 val_5 NULL NULL NULL NULL 49510 val_10 NULL NULL NULL NULL 496NULL NULL NULL NULL 10 val_10 497NULL NULL NULL NULL 17 val_17 498NULL NULL NULL NULL 19 val_19 499NULL NULL NULL NULL 20 val_20 500NULL NULL NULL NULL 23 val_23 501PREHOOK: query: explain 502select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 503PREHOOK: type: QUERY 504POSTHOOK: query: explain 505select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 506POSTHOOK: type: QUERY 507ABSTRACT SYNTAX TREE: 508 (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 509 510STAGE DEPENDENCIES: 511 Stage-1 is a root stage 512 Stage-0 is a root stage 513 514STAGE PLANS: 515 Stage: Stage-1 516 Map Reduce 517 Alias -> Map Operator Tree: 518 c 519 TableScan 520 alias: c 521 Sorted Merge Bucket Map Join Operator 522 condition map: 523 Right Outer Join0 to 1 524 Inner Join 1 to 2 525 condition expressions: 526 0 {key} {value} 527 1 {key} {value} 528 2 {key} {value} 529 handleSkewJoin: false 530 keys: 531 0 [Column[key]] 532 1 [Column[key]] 533 2 [Column[key]] 534 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 535 Position of Big Table: 2 536 Select Operator 537 expressions: 538 expr: _col0 539 type: int 540 expr: _col1 541 type: string 542 expr: _col4 543 type: int 544 expr: _col5 545 type: string 546 expr: _col8 547 type: int 548 expr: _col9 549 type: string 550 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 551 Select Operator 552 expressions: 553 expr: _col0 554 type: int 555 expr: _col1 556 type: string 557 expr: _col4 558 type: int 559 expr: _col5 560 type: string 561 expr: _col8 562 type: int 563 expr: _col9 564 type: string 565 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 566 File Output Operator 567 compressed: false 568 GlobalTableId: 0 569 table: 570 input format: org.apache.hadoop.mapred.TextInputFormat 571 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 572 573 Stage: Stage-0 574 Fetch Operator 575 limit: -1 576 577 578PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 579PREHOOK: type: QUERY 580PREHOOK: Input: default@smb_bucket_1 581PREHOOK: Input: default@smb_bucket_2 582PREHOOK: Input: default@smb_bucket_3 583PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-05_777_1313016308874669202/-mr-10000 584POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 585POSTHOOK: type: QUERY 586POSTHOOK: Input: default@smb_bucket_1 587POSTHOOK: Input: default@smb_bucket_2 588POSTHOOK: Input: default@smb_bucket_3 589POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-05_777_1313016308874669202/-mr-10000 590NULL NULL 20 val_20 20 val_20 591NULL NULL 23 val_23 23 val_23 592PREHOOK: query: explain 593select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 594PREHOOK: type: QUERY 595POSTHOOK: query: explain 596select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 597POSTHOOK: type: QUERY 598ABSTRACT SYNTAX TREE: 599 (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 600 601STAGE DEPENDENCIES: 602 Stage-1 is a root stage 603 Stage-0 is a root stage 604 605STAGE PLANS: 606 Stage: Stage-1 607 Map Reduce 608 Alias -> Map Operator Tree: 609 c 610 TableScan 611 alias: c 612 Sorted Merge Bucket Map Join Operator 613 condition map: 614 Right Outer Join0 to 1 615 Left Outer Join1 to 2 616 condition expressions: 617 0 {key} {value} 618 1 {key} {value} 619 2 {key} {value} 620 handleSkewJoin: false 621 keys: 622 0 [Column[key]] 623 1 [Column[key]] 624 2 [Column[key]] 625 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 626 Position of Big Table: 2 627 Select Operator 628 expressions: 629 expr: _col0 630 type: int 631 expr: _col1 632 type: string 633 expr: _col4 634 type: int 635 expr: _col5 636 type: string 637 expr: _col8 638 type: int 639 expr: _col9 640 type: string 641 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 642 Select Operator 643 expressions: 644 expr: _col0 645 type: int 646 expr: _col1 647 type: string 648 expr: _col4 649 type: int 650 expr: _col5 651 type: string 652 expr: _col8 653 type: int 654 expr: _col9 655 type: string 656 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 657 File Output Operator 658 compressed: false 659 GlobalTableId: 0 660 table: 661 input format: org.apache.hadoop.mapred.TextInputFormat 662 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 663 664 Stage: Stage-0 665 Fetch Operator 666 limit: -1 667 668 669PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 670PREHOOK: type: QUERY 671PREHOOK: Input: default@smb_bucket_1 672PREHOOK: Input: default@smb_bucket_2 673PREHOOK: Input: default@smb_bucket_3 674PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-09_122_6064666085021507736/-mr-10000 675POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 676POSTHOOK: type: QUERY 677POSTHOOK: Input: default@smb_bucket_1 678POSTHOOK: Input: default@smb_bucket_2 679POSTHOOK: Input: default@smb_bucket_3 680POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-09_122_6064666085021507736/-mr-10000 681NULL NULL 20 val_20 20 val_20 682NULL NULL 23 val_23 23 val_23 683NULL NULL 25 val_25 NULL NULL 684NULL NULL 30 val_30 NULL NULL 685PREHOOK: query: explain 686select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 687PREHOOK: type: QUERY 688POSTHOOK: query: explain 689select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 690POSTHOOK: type: QUERY 691ABSTRACT SYNTAX TREE: 692 (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 693 694STAGE DEPENDENCIES: 695 Stage-1 is a root stage 696 Stage-0 is a root stage 697 698STAGE PLANS: 699 Stage: Stage-1 700 Map Reduce 701 Alias -> Map Operator Tree: 702 c 703 TableScan 704 alias: c 705 Sorted Merge Bucket Map Join Operator 706 condition map: 707 Right Outer Join0 to 1 708 Right Outer Join1 to 2 709 condition expressions: 710 0 {key} {value} 711 1 {key} {value} 712 2 {key} {value} 713 handleSkewJoin: false 714 keys: 715 0 [Column[key]] 716 1 [Column[key]] 717 2 [Column[key]] 718 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 719 Position of Big Table: 2 720 Select Operator 721 expressions: 722 expr: _col0 723 type: int 724 expr: _col1 725 type: string 726 expr: _col4 727 type: int 728 expr: _col5 729 type: string 730 expr: _col8 731 type: int 732 expr: _col9 733 type: string 734 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 735 Select Operator 736 expressions: 737 expr: _col0 738 type: int 739 expr: _col1 740 type: string 741 expr: _col4 742 type: int 743 expr: _col5 744 type: string 745 expr: _col8 746 type: int 747 expr: _col9 748 type: string 749 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 750 File Output Operator 751 compressed: false 752 GlobalTableId: 0 753 table: 754 input format: org.apache.hadoop.mapred.TextInputFormat 755 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 756 757 Stage: Stage-0 758 Fetch Operator 759 limit: -1 760 761 762PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 763PREHOOK: type: QUERY 764PREHOOK: Input: default@smb_bucket_1 765PREHOOK: Input: default@smb_bucket_2 766PREHOOK: Input: default@smb_bucket_3 767PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-12_331_9066526170001430264/-mr-10000 768POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 769POSTHOOK: type: QUERY 770POSTHOOK: Input: default@smb_bucket_1 771POSTHOOK: Input: default@smb_bucket_2 772POSTHOOK: Input: default@smb_bucket_3 773POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-12_331_9066526170001430264/-mr-10000 774NULL NULL NULL NULL 4 val_4 775NULL NULL NULL NULL 10 val_10 776NULL NULL NULL NULL 17 val_17 777NULL NULL NULL NULL 19 val_19 778NULL NULL 20 val_20 20 val_20 779NULL NULL 23 val_23 23 val_23 780PREHOOK: query: explain 781select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 782PREHOOK: type: QUERY 783POSTHOOK: query: explain 784select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 785POSTHOOK: type: QUERY 786ABSTRACT SYNTAX TREE: 787 (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 788 789STAGE DEPENDENCIES: 790 Stage-1 is a root stage 791 Stage-0 is a root stage 792 793STAGE PLANS: 794 Stage: Stage-1 795 Map Reduce 796 Alias -> Map Operator Tree: 797 c 798 TableScan 799 alias: c 800 Sorted Merge Bucket Map Join Operator 801 condition map: 802 Right Outer Join0 to 1 803 Outer Join 1 to 2 804 condition expressions: 805 0 {key} {value} 806 1 {key} {value} 807 2 {key} {value} 808 handleSkewJoin: false 809 keys: 810 0 [Column[key]] 811 1 [Column[key]] 812 2 [Column[key]] 813 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 814 Position of Big Table: 2 815 Select Operator 816 expressions: 817 expr: _col0 818 type: int 819 expr: _col1 820 type: string 821 expr: _col4 822 type: int 823 expr: _col5 824 type: string 825 expr: _col8 826 type: int 827 expr: _col9 828 type: string 829 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 830 Select Operator 831 expressions: 832 expr: _col0 833 type: int 834 expr: _col1 835 type: string 836 expr: _col4 837 type: int 838 expr: _col5 839 type: string 840 expr: _col8 841 type: int 842 expr: _col9 843 type: string 844 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 845 File Output Operator 846 compressed: false 847 GlobalTableId: 0 848 table: 849 input format: org.apache.hadoop.mapred.TextInputFormat 850 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 851 852 Stage: Stage-0 853 Fetch Operator 854 limit: -1 855 856 857PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 858PREHOOK: type: QUERY 859PREHOOK: Input: default@smb_bucket_1 860PREHOOK: Input: default@smb_bucket_2 861PREHOOK: Input: default@smb_bucket_3 862PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-15_548_3077982864155533470/-mr-10000 863POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 864POSTHOOK: type: QUERY 865POSTHOOK: Input: default@smb_bucket_1 866POSTHOOK: Input: default@smb_bucket_2 867POSTHOOK: Input: default@smb_bucket_3 868POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-15_548_3077982864155533470/-mr-10000 869NULL NULL NULL NULL 4 val_4 870NULL NULL NULL NULL 10 val_10 871NULL NULL NULL NULL 17 val_17 872NULL NULL NULL NULL 19 val_19 873NULL NULL 20 val_20 20 val_20 874NULL NULL 23 val_23 23 val_23 875NULL NULL 25 val_25 NULL NULL 876NULL NULL 30 val_30 NULL NULL 877PREHOOK: query: explain 878select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 879PREHOOK: type: QUERY 880POSTHOOK: query: explain 881select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 882POSTHOOK: type: QUERY 883ABSTRACT SYNTAX TREE: 884 (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 885 886STAGE DEPENDENCIES: 887 Stage-1 is a root stage 888 Stage-0 is a root stage 889 890STAGE PLANS: 891 Stage: Stage-1 892 Map Reduce 893 Alias -> Map Operator Tree: 894 c 895 TableScan 896 alias: c 897 Sorted Merge Bucket Map Join Operator 898 condition map: 899 Outer Join 0 to 1 900 Inner Join 1 to 2 901 condition expressions: 902 0 {key} {value} 903 1 {key} {value} 904 2 {key} {value} 905 handleSkewJoin: false 906 keys: 907 0 [Column[key]] 908 1 [Column[key]] 909 2 [Column[key]] 910 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 911 Position of Big Table: 2 912 Select Operator 913 expressions: 914 expr: _col0 915 type: int 916 expr: _col1 917 type: string 918 expr: _col4 919 type: int 920 expr: _col5 921 type: string 922 expr: _col8 923 type: int 924 expr: _col9 925 type: string 926 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 927 Select Operator 928 expressions: 929 expr: _col0 930 type: int 931 expr: _col1 932 type: string 933 expr: _col4 934 type: int 935 expr: _col5 936 type: string 937 expr: _col8 938 type: int 939 expr: _col9 940 type: string 941 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 942 File Output Operator 943 compressed: false 944 GlobalTableId: 0 945 table: 946 input format: org.apache.hadoop.mapred.TextInputFormat 947 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 948 949 Stage: Stage-0 950 Fetch Operator 951 limit: -1 952 953 954PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 955PREHOOK: type: QUERY 956PREHOOK: Input: default@smb_bucket_1 957PREHOOK: Input: default@smb_bucket_2 958PREHOOK: Input: default@smb_bucket_3 959PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-18_783_1707777207222799965/-mr-10000 960POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key 961POSTHOOK: type: QUERY 962POSTHOOK: Input: default@smb_bucket_1 963POSTHOOK: Input: default@smb_bucket_2 964POSTHOOK: Input: default@smb_bucket_3 965POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-18_783_1707777207222799965/-mr-10000 966NULL NULL 20 val_20 20 val_20 967NULL NULL 23 val_23 23 val_23 968PREHOOK: query: explain 969select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 970PREHOOK: type: QUERY 971POSTHOOK: query: explain 972select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 973POSTHOOK: type: QUERY 974ABSTRACT SYNTAX TREE: 975 (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 976 977STAGE DEPENDENCIES: 978 Stage-1 is a root stage 979 Stage-0 is a root stage 980 981STAGE PLANS: 982 Stage: Stage-1 983 Map Reduce 984 Alias -> Map Operator Tree: 985 c 986 TableScan 987 alias: c 988 Sorted Merge Bucket Map Join Operator 989 condition map: 990 Outer Join 0 to 1 991 Left Outer Join1 to 2 992 condition expressions: 993 0 {key} {value} 994 1 {key} {value} 995 2 {key} {value} 996 handleSkewJoin: false 997 keys: 998 0 [Column[key]] 999 1 [Column[key]] 1000 2 [Column[key]] 1001 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 1002 Position of Big Table: 2 1003 Select Operator 1004 expressions: 1005 expr: _col0 1006 type: int 1007 expr: _col1 1008 type: string 1009 expr: _col4 1010 type: int 1011 expr: _col5 1012 type: string 1013 expr: _col8 1014 type: int 1015 expr: _col9 1016 type: string 1017 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 1018 Select Operator 1019 expressions: 1020 expr: _col0 1021 type: int 1022 expr: _col1 1023 type: string 1024 expr: _col4 1025 type: int 1026 expr: _col5 1027 type: string 1028 expr: _col8 1029 type: int 1030 expr: _col9 1031 type: string 1032 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 1033 File Output Operator 1034 compressed: false 1035 GlobalTableId: 0 1036 table: 1037 input format: org.apache.hadoop.mapred.TextInputFormat 1038 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 1039 1040 Stage: Stage-0 1041 Fetch Operator 1042 limit: -1 1043 1044 1045PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 1046PREHOOK: type: QUERY 1047PREHOOK: Input: default@smb_bucket_1 1048PREHOOK: Input: default@smb_bucket_2 1049PREHOOK: Input: default@smb_bucket_3 1050PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-22_135_3196413763184480906/-mr-10000 1051POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key 1052POSTHOOK: type: QUERY 1053POSTHOOK: Input: default@smb_bucket_1 1054POSTHOOK: Input: default@smb_bucket_2 1055POSTHOOK: Input: default@smb_bucket_3 1056POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-22_135_3196413763184480906/-mr-10000 10571 val_1 NULL NULL NULL NULL 10583 val_3 NULL NULL NULL NULL 10594 val_4 NULL NULL NULL NULL 10605 val_5 NULL NULL NULL NULL 106110 val_10 NULL NULL NULL NULL 1062NULL NULL 20 val_20 20 val_20 1063NULL NULL 23 val_23 23 val_23 1064NULL NULL 25 val_25 NULL NULL 1065NULL NULL 30 val_30 NULL NULL 1066PREHOOK: query: explain 1067select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 1068PREHOOK: type: QUERY 1069POSTHOOK: query: explain 1070select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 1071POSTHOOK: type: QUERY 1072ABSTRACT SYNTAX TREE: 1073 (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 1074 1075STAGE DEPENDENCIES: 1076 Stage-1 is a root stage 1077 Stage-0 is a root stage 1078 1079STAGE PLANS: 1080 Stage: Stage-1 1081 Map Reduce 1082 Alias -> Map Operator Tree: 1083 c 1084 TableScan 1085 alias: c 1086 Sorted Merge Bucket Map Join Operator 1087 condition map: 1088 Outer Join 0 to 1 1089 Right Outer Join1 to 2 1090 condition expressions: 1091 0 {key} {value} 1092 1 {key} {value} 1093 2 {key} {value} 1094 handleSkewJoin: false 1095 keys: 1096 0 [Column[key]] 1097 1 [Column[key]] 1098 2 [Column[key]] 1099 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 1100 Position of Big Table: 2 1101 Select Operator 1102 expressions: 1103 expr: _col0 1104 type: int 1105 expr: _col1 1106 type: string 1107 expr: _col4 1108 type: int 1109 expr: _col5 1110 type: string 1111 expr: _col8 1112 type: int 1113 expr: _col9 1114 type: string 1115 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 1116 Select Operator 1117 expressions: 1118 expr: _col0 1119 type: int 1120 expr: _col1 1121 type: string 1122 expr: _col4 1123 type: int 1124 expr: _col5 1125 type: string 1126 expr: _col8 1127 type: int 1128 expr: _col9 1129 type: string 1130 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 1131 File Output Operator 1132 compressed: false 1133 GlobalTableId: 0 1134 table: 1135 input format: org.apache.hadoop.mapred.TextInputFormat 1136 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 1137 1138 Stage: Stage-0 1139 Fetch Operator 1140 limit: -1 1141 1142 1143PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 1144PREHOOK: type: QUERY 1145PREHOOK: Input: default@smb_bucket_1 1146PREHOOK: Input: default@smb_bucket_2 1147PREHOOK: Input: default@smb_bucket_3 1148PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-25_402_68522573808341044/-mr-10000 1149POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key 1150POSTHOOK: type: QUERY 1151POSTHOOK: Input: default@smb_bucket_1 1152POSTHOOK: Input: default@smb_bucket_2 1153POSTHOOK: Input: default@smb_bucket_3 1154POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-25_402_68522573808341044/-mr-10000 1155NULL NULL NULL NULL 4 val_4 1156NULL NULL NULL NULL 10 val_10 1157NULL NULL NULL NULL 17 val_17 1158NULL NULL NULL NULL 19 val_19 1159NULL NULL 20 val_20 20 val_20 1160NULL NULL 23 val_23 23 val_23 1161PREHOOK: query: explain 1162select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 1163PREHOOK: type: QUERY 1164POSTHOOK: query: explain 1165select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 1166POSTHOOK: type: QUERY 1167ABSTRACT SYNTAX TREE: 1168 (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF)))) 1169 1170STAGE DEPENDENCIES: 1171 Stage-1 is a root stage 1172 Stage-0 is a root stage 1173 1174STAGE PLANS: 1175 Stage: Stage-1 1176 Map Reduce 1177 Alias -> Map Operator Tree: 1178 c 1179 TableScan 1180 alias: c 1181 Sorted Merge Bucket Map Join Operator 1182 condition map: 1183 Outer Join 0 to 1 1184 Outer Join 1 to 2 1185 condition expressions: 1186 0 {key} {value} 1187 1 {key} {value} 1188 2 {key} {value} 1189 handleSkewJoin: false 1190 keys: 1191 0 [Column[key]] 1192 1 [Column[key]] 1193 2 [Column[key]] 1194 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 1195 Position of Big Table: 2 1196 Select Operator 1197 expressions: 1198 expr: _col0 1199 type: int 1200 expr: _col1 1201 type: string 1202 expr: _col4 1203 type: int 1204 expr: _col5 1205 type: string 1206 expr: _col8 1207 type: int 1208 expr: _col9 1209 type: string 1210 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 1211 Select Operator 1212 expressions: 1213 expr: _col0 1214 type: int 1215 expr: _col1 1216 type: string 1217 expr: _col4 1218 type: int 1219 expr: _col5 1220 type: string 1221 expr: _col8 1222 type: int 1223 expr: _col9 1224 type: string 1225 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 1226 File Output Operator 1227 compressed: false 1228 GlobalTableId: 0 1229 table: 1230 input format: org.apache.hadoop.mapred.TextInputFormat 1231 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 1232 1233 Stage: Stage-0 1234 Fetch Operator 1235 limit: -1 1236 1237 1238PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 1239PREHOOK: type: QUERY 1240PREHOOK: Input: default@smb_bucket_1 1241PREHOOK: Input: default@smb_bucket_2 1242PREHOOK: Input: default@smb_bucket_3 1243PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-28_578_3471954978455115358/-mr-10000 1244POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key 1245POSTHOOK: type: QUERY 1246POSTHOOK: Input: default@smb_bucket_1 1247POSTHOOK: Input: default@smb_bucket_2 1248POSTHOOK: Input: default@smb_bucket_3 1249POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-28_578_3471954978455115358/-mr-10000 12501 val_1 NULL NULL NULL NULL 12513 val_3 NULL NULL NULL NULL 12524 val_4 NULL NULL NULL NULL 1253NULL NULL NULL NULL 4 val_4 12545 val_5 NULL NULL NULL NULL 125510 val_10 NULL NULL NULL NULL 1256NULL NULL NULL NULL 10 val_10 1257NULL NULL NULL NULL 17 val_17 1258NULL NULL NULL NULL 19 val_19 1259NULL NULL 20 val_20 20 val_20 1260NULL NULL 23 val_23 23 val_23 1261NULL NULL 25 val_25 NULL NULL 1262NULL NULL 30 val_30 NULL NULL