PageRenderTime 44ms CodeModel.GetById 10ms app.highlight 21ms RepoModel.GetById 1ms app.codeStats 1ms

/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

Large files files are truncated, but you can click here to view the full 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	NU…

Large files files are truncated, but you can click here to view the full file