PageRenderTime 36ms CodeModel.GetById 16ms app.highlight 11ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/router_join_ppr.q.out

#
text | 1293 lines | 1257 code | 36 blank | 0 comment | 0 complexity | 7871a23d208e652ce4edd528e1676d4d MD5 | raw file

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

   1PREHOOK: query: EXPLAIN EXTENDED
   2 FROM 
   3  src a
   4 RIGHT OUTER JOIN 
   5  srcpart b 
   6 ON (a.key = b.key AND b.ds = '2008-04-08')
   7 SELECT a.key, a.value, b.key, b.value
   8 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
   9PREHOOK: type: QUERY
  10POSTHOOK: query: EXPLAIN EXTENDED
  11 FROM 
  12  src a
  13 RIGHT OUTER JOIN 
  14  srcpart b 
  15 ON (a.key = b.key AND b.ds = '2008-04-08')
  16 SELECT a.key, a.value, b.key, b.value
  17 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
  18POSTHOOK: type: QUERY
  19ABSTRACT SYNTAX TREE:
  20  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) a) (TOK_TABREF (TOK_TABNAME srcpart) b) (AND (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)) (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08')))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)))))
  21
  22STAGE DEPENDENCIES:
  23  Stage-1 is a root stage
  24  Stage-0 is a root stage
  25
  26STAGE PLANS:
  27  Stage: Stage-1
  28    Map Reduce
  29      Alias -> Map Operator Tree:
  30        a 
  31          TableScan
  32            alias: a
  33            GatherStats: false
  34            Reduce Output Operator
  35              key expressions:
  36                    expr: key
  37                    type: string
  38              sort order: +
  39              Map-reduce partition columns:
  40                    expr: key
  41                    type: string
  42              tag: 0
  43              value expressions:
  44                    expr: key
  45                    type: string
  46                    expr: value
  47                    type: string
  48        b 
  49          TableScan
  50            alias: b
  51            GatherStats: false
  52            Filter Operator
  53              isSamplingPred: false
  54              predicate:
  55                  expr: ((key > 15) and (key < 25))
  56                  type: boolean
  57              Reduce Output Operator
  58                key expressions:
  59                      expr: key
  60                      type: string
  61                sort order: +
  62                Map-reduce partition columns:
  63                      expr: key
  64                      type: string
  65                tag: 1
  66                value expressions:
  67                      expr: key
  68                      type: string
  69                      expr: value
  70                      type: string
  71                      expr: ds
  72                      type: string
  73      Needs Tagging: true
  74      Path -> Alias:
  75        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [a]
  76        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
  77        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
  78        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [b]
  79        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [b]
  80      Path -> Partition:
  81        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src 
  82          Partition
  83            base file name: src
  84            input format: org.apache.hadoop.mapred.TextInputFormat
  85            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  86            properties:
  87              bucket_count -1
  88              columns key,value
  89              columns.types string:string
  90              file.inputformat org.apache.hadoop.mapred.TextInputFormat
  91              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  92              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
  93              name default.src
  94              serialization.ddl struct src { string key, string value}
  95              serialization.format 1
  96              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  97              transient_lastDdlTime 1297378968
  98            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  99          
 100              input format: org.apache.hadoop.mapred.TextInputFormat
 101              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 102              properties:
 103                bucket_count -1
 104                columns key,value
 105                columns.types string:string
 106                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 107                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 108                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 109                name default.src
 110                serialization.ddl struct src { string key, string value}
 111                serialization.format 1
 112                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 113                transient_lastDdlTime 1297378968
 114              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 115              name: default.src
 116            name: default.src
 117        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
 118          Partition
 119            base file name: hr=11
 120            input format: org.apache.hadoop.mapred.TextInputFormat
 121            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 122            partition values:
 123              ds 2008-04-08
 124              hr 11
 125            properties:
 126              bucket_count -1
 127              columns key,value
 128              columns.types string:string
 129              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 130              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 131              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
 132              name default.srcpart
 133              partition_columns ds/hr
 134              serialization.ddl struct srcpart { string key, string value}
 135              serialization.format 1
 136              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 137              transient_lastDdlTime 1297378962
 138            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 139          
 140              input format: org.apache.hadoop.mapred.TextInputFormat
 141              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 142              properties:
 143                bucket_count -1
 144                columns key,value
 145                columns.types string:string
 146                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 147                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 148                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 149                name default.srcpart
 150                partition_columns ds/hr
 151                serialization.ddl struct srcpart { string key, string value}
 152                serialization.format 1
 153                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 154                transient_lastDdlTime 1297378962
 155              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 156              name: default.srcpart
 157            name: default.srcpart
 158        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
 159          Partition
 160            base file name: hr=12
 161            input format: org.apache.hadoop.mapred.TextInputFormat
 162            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 163            partition values:
 164              ds 2008-04-08
 165              hr 12
 166            properties:
 167              bucket_count -1
 168              columns key,value
 169              columns.types string:string
 170              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 171              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 172              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
 173              name default.srcpart
 174              partition_columns ds/hr
 175              serialization.ddl struct srcpart { string key, string value}
 176              serialization.format 1
 177              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 178              transient_lastDdlTime 1297378962
 179            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 180          
 181              input format: org.apache.hadoop.mapred.TextInputFormat
 182              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 183              properties:
 184                bucket_count -1
 185                columns key,value
 186                columns.types string:string
 187                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 188                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 189                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 190                name default.srcpart
 191                partition_columns ds/hr
 192                serialization.ddl struct srcpart { string key, string value}
 193                serialization.format 1
 194                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 195                transient_lastDdlTime 1297378962
 196              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 197              name: default.srcpart
 198            name: default.srcpart
 199        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
 200          Partition
 201            base file name: hr=11
 202            input format: org.apache.hadoop.mapred.TextInputFormat
 203            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 204            partition values:
 205              ds 2008-04-09
 206              hr 11
 207            properties:
 208              bucket_count -1
 209              columns key,value
 210              columns.types string:string
 211              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 212              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 213              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
 214              name default.srcpart
 215              partition_columns ds/hr
 216              serialization.ddl struct srcpart { string key, string value}
 217              serialization.format 1
 218              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 219              transient_lastDdlTime 1297378962
 220            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 221          
 222              input format: org.apache.hadoop.mapred.TextInputFormat
 223              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 224              properties:
 225                bucket_count -1
 226                columns key,value
 227                columns.types string:string
 228                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 229                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 230                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 231                name default.srcpart
 232                partition_columns ds/hr
 233                serialization.ddl struct srcpart { string key, string value}
 234                serialization.format 1
 235                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 236                transient_lastDdlTime 1297378962
 237              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 238              name: default.srcpart
 239            name: default.srcpart
 240        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
 241          Partition
 242            base file name: hr=12
 243            input format: org.apache.hadoop.mapred.TextInputFormat
 244            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 245            partition values:
 246              ds 2008-04-09
 247              hr 12
 248            properties:
 249              bucket_count -1
 250              columns key,value
 251              columns.types string:string
 252              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 253              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 254              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
 255              name default.srcpart
 256              partition_columns ds/hr
 257              serialization.ddl struct srcpart { string key, string value}
 258              serialization.format 1
 259              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 260              transient_lastDdlTime 1297378962
 261            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 262          
 263              input format: org.apache.hadoop.mapred.TextInputFormat
 264              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 265              properties:
 266                bucket_count -1
 267                columns key,value
 268                columns.types string:string
 269                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 270                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 271                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 272                name default.srcpart
 273                partition_columns ds/hr
 274                serialization.ddl struct srcpart { string key, string value}
 275                serialization.format 1
 276                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 277                transient_lastDdlTime 1297378962
 278              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 279              name: default.srcpart
 280            name: default.srcpart
 281      Reduce Operator Tree:
 282        Join Operator
 283          condition map:
 284               Right Outer Join0 to 1
 285          condition expressions:
 286            0 {VALUE._col0} {VALUE._col1}
 287            1 {VALUE._col0} {VALUE._col1}
 288          filter predicates:
 289            0 
 290            1 {(VALUE._col2 = '2008-04-08')}
 291          handleSkewJoin: false
 292          outputColumnNames: _col0, _col1, _col4, _col5
 293          Filter Operator
 294            isSamplingPred: false
 295            predicate:
 296                expr: ((_col0 > 10) and (_col0 < 20))
 297                type: boolean
 298            Select Operator
 299              expressions:
 300                    expr: _col0
 301                    type: string
 302                    expr: _col1
 303                    type: string
 304                    expr: _col4
 305                    type: string
 306                    expr: _col5
 307                    type: string
 308              outputColumnNames: _col0, _col1, _col2, _col3
 309              File Output Operator
 310                compressed: false
 311                GlobalTableId: 0
 312                directory: file:/tmp/sdong/hive_2011-02-10_17-01-51_944_8007180207485477580/-ext-10001
 313                NumFilesPerFileSink: 1
 314                Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-01-51_944_8007180207485477580/-ext-10001/
 315                table:
 316                    input format: org.apache.hadoop.mapred.TextInputFormat
 317                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 318                    properties:
 319                      columns _col0,_col1,_col2,_col3
 320                      columns.types string:string:string:string
 321                      serialization.format 1
 322                TotalFiles: 1
 323                GatherStats: false
 324                MultiFileSpray: false
 325
 326  Stage: Stage-0
 327    Fetch Operator
 328      limit: -1
 329
 330
 331PREHOOK: query: FROM 
 332  src a
 333 RIGHT OUTER JOIN 
 334  srcpart b 
 335 ON (a.key = b.key AND b.ds = '2008-04-08')
 336 SELECT a.key, a.value, b.key, b.value
 337 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 338PREHOOK: type: QUERY
 339PREHOOK: Input: default@src
 340PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 341PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 342PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
 343PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
 344PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-52_113_3892314008195573376/-mr-10000
 345POSTHOOK: query: FROM 
 346  src a
 347 RIGHT OUTER JOIN 
 348  srcpart b 
 349 ON (a.key = b.key AND b.ds = '2008-04-08')
 350 SELECT a.key, a.value, b.key, b.value
 351 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 352POSTHOOK: type: QUERY
 353POSTHOOK: Input: default@src
 354POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 355POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 356POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
 357POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
 358POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-52_113_3892314008195573376/-mr-10000
 35917	val_17	17	val_17
 36017	val_17	17	val_17
 36118	val_18	18	val_18
 36218	val_18	18	val_18
 36318	val_18	18	val_18
 36418	val_18	18	val_18
 36518	val_18	18	val_18
 36618	val_18	18	val_18
 36718	val_18	18	val_18
 36818	val_18	18	val_18
 36919	val_19	19	val_19
 37019	val_19	19	val_19
 371PREHOOK: query: EXPLAIN EXTENDED
 372 FROM 
 373  srcpart a
 374 RIGHT OUTER JOIN 
 375  src b 
 376 ON (a.key = b.key AND a.ds = '2008-04-08')
 377 SELECT a.key, a.value, b.key, b.value
 378 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 379PREHOOK: type: QUERY
 380POSTHOOK: query: EXPLAIN EXTENDED
 381 FROM 
 382  srcpart a
 383 RIGHT OUTER JOIN 
 384  src b 
 385 ON (a.key = b.key AND a.ds = '2008-04-08')
 386 SELECT a.key, a.value, b.key, b.value
 387 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 388POSTHOOK: type: QUERY
 389ABSTRACT SYNTAX TREE:
 390  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME src) b) (AND (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)) (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08')))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)))))
 391
 392STAGE DEPENDENCIES:
 393  Stage-1 is a root stage
 394  Stage-0 is a root stage
 395
 396STAGE PLANS:
 397  Stage: Stage-1
 398    Map Reduce
 399      Alias -> Map Operator Tree:
 400        a 
 401          TableScan
 402            alias: a
 403            GatherStats: false
 404            Reduce Output Operator
 405              key expressions:
 406                    expr: key
 407                    type: string
 408              sort order: +
 409              Map-reduce partition columns:
 410                    expr: key
 411                    type: string
 412              tag: 0
 413              value expressions:
 414                    expr: key
 415                    type: string
 416                    expr: value
 417                    type: string
 418        b 
 419          TableScan
 420            alias: b
 421            GatherStats: false
 422            Filter Operator
 423              isSamplingPred: false
 424              predicate:
 425                  expr: ((key > 15) and (key < 25))
 426                  type: boolean
 427              Reduce Output Operator
 428                key expressions:
 429                      expr: key
 430                      type: string
 431                sort order: +
 432                Map-reduce partition columns:
 433                      expr: key
 434                      type: string
 435                tag: 1
 436                value expressions:
 437                      expr: key
 438                      type: string
 439                      expr: value
 440                      type: string
 441      Needs Tagging: true
 442      Path -> Alias:
 443        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [b]
 444        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
 445        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
 446      Path -> Partition:
 447        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src 
 448          Partition
 449            base file name: src
 450            input format: org.apache.hadoop.mapred.TextInputFormat
 451            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 452            properties:
 453              bucket_count -1
 454              columns key,value
 455              columns.types string:string
 456              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 457              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 458              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 459              name default.src
 460              serialization.ddl struct src { string key, string value}
 461              serialization.format 1
 462              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 463              transient_lastDdlTime 1297378968
 464            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 465          
 466              input format: org.apache.hadoop.mapred.TextInputFormat
 467              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 468              properties:
 469                bucket_count -1
 470                columns key,value
 471                columns.types string:string
 472                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 473                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 474                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 475                name default.src
 476                serialization.ddl struct src { string key, string value}
 477                serialization.format 1
 478                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 479                transient_lastDdlTime 1297378968
 480              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 481              name: default.src
 482            name: default.src
 483        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
 484          Partition
 485            base file name: hr=11
 486            input format: org.apache.hadoop.mapred.TextInputFormat
 487            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 488            partition values:
 489              ds 2008-04-08
 490              hr 11
 491            properties:
 492              bucket_count -1
 493              columns key,value
 494              columns.types string:string
 495              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 496              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 497              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
 498              name default.srcpart
 499              partition_columns ds/hr
 500              serialization.ddl struct srcpart { string key, string value}
 501              serialization.format 1
 502              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 503              transient_lastDdlTime 1297378962
 504            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 505          
 506              input format: org.apache.hadoop.mapred.TextInputFormat
 507              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 508              properties:
 509                bucket_count -1
 510                columns key,value
 511                columns.types string:string
 512                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 513                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 514                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 515                name default.srcpart
 516                partition_columns ds/hr
 517                serialization.ddl struct srcpart { string key, string value}
 518                serialization.format 1
 519                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 520                transient_lastDdlTime 1297378962
 521              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 522              name: default.srcpart
 523            name: default.srcpart
 524        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
 525          Partition
 526            base file name: hr=12
 527            input format: org.apache.hadoop.mapred.TextInputFormat
 528            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 529            partition values:
 530              ds 2008-04-08
 531              hr 12
 532            properties:
 533              bucket_count -1
 534              columns key,value
 535              columns.types string:string
 536              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 537              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 538              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
 539              name default.srcpart
 540              partition_columns ds/hr
 541              serialization.ddl struct srcpart { string key, string value}
 542              serialization.format 1
 543              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 544              transient_lastDdlTime 1297378962
 545            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 546          
 547              input format: org.apache.hadoop.mapred.TextInputFormat
 548              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 549              properties:
 550                bucket_count -1
 551                columns key,value
 552                columns.types string:string
 553                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 554                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 555                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 556                name default.srcpart
 557                partition_columns ds/hr
 558                serialization.ddl struct srcpart { string key, string value}
 559                serialization.format 1
 560                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 561                transient_lastDdlTime 1297378962
 562              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 563              name: default.srcpart
 564            name: default.srcpart
 565      Reduce Operator Tree:
 566        Join Operator
 567          condition map:
 568               Right Outer Join0 to 1
 569          condition expressions:
 570            0 {VALUE._col0} {VALUE._col1}
 571            1 {VALUE._col0} {VALUE._col1}
 572          handleSkewJoin: false
 573          outputColumnNames: _col0, _col1, _col6, _col7
 574          Filter Operator
 575            isSamplingPred: false
 576            predicate:
 577                expr: ((_col0 > 10) and (_col0 < 20))
 578                type: boolean
 579            Select Operator
 580              expressions:
 581                    expr: _col0
 582                    type: string
 583                    expr: _col1
 584                    type: string
 585                    expr: _col6
 586                    type: string
 587                    expr: _col7
 588                    type: string
 589              outputColumnNames: _col0, _col1, _col2, _col3
 590              File Output Operator
 591                compressed: false
 592                GlobalTableId: 0
 593                directory: file:/tmp/sdong/hive_2011-02-10_17-01-56_698_3650606708384403170/-ext-10001
 594                NumFilesPerFileSink: 1
 595                Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-01-56_698_3650606708384403170/-ext-10001/
 596                table:
 597                    input format: org.apache.hadoop.mapred.TextInputFormat
 598                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 599                    properties:
 600                      columns _col0,_col1,_col2,_col3
 601                      columns.types string:string:string:string
 602                      serialization.format 1
 603                TotalFiles: 1
 604                GatherStats: false
 605                MultiFileSpray: false
 606
 607  Stage: Stage-0
 608    Fetch Operator
 609      limit: -1
 610
 611
 612PREHOOK: query: FROM 
 613  srcpart a
 614 RIGHT OUTER JOIN 
 615  src b 
 616 ON (a.key = b.key AND a.ds = '2008-04-08')
 617 SELECT a.key, a.value, b.key, b.value
 618 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 619PREHOOK: type: QUERY
 620PREHOOK: Input: default@src
 621PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 622PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 623PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-56_851_1955742945505151056/-mr-10000
 624POSTHOOK: query: FROM 
 625  srcpart a
 626 RIGHT OUTER JOIN 
 627  src b 
 628 ON (a.key = b.key AND a.ds = '2008-04-08')
 629 SELECT a.key, a.value, b.key, b.value
 630 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
 631POSTHOOK: type: QUERY
 632POSTHOOK: Input: default@src
 633POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 634POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 635POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-01-56_851_1955742945505151056/-mr-10000
 63617	val_17	17	val_17
 63717	val_17	17	val_17
 63818	val_18	18	val_18
 63918	val_18	18	val_18
 64018	val_18	18	val_18
 64118	val_18	18	val_18
 64218	val_18	18	val_18
 64318	val_18	18	val_18
 64418	val_18	18	val_18
 64518	val_18	18	val_18
 64619	val_19	19	val_19
 64719	val_19	19	val_19
 648PREHOOK: query: EXPLAIN EXTENDED
 649 FROM 
 650  src a
 651 RIGHT OUTER JOIN 
 652  srcpart b 
 653 ON (a.key = b.key)
 654 SELECT a.key, a.value, b.key, b.value
 655 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08'
 656PREHOOK: type: QUERY
 657POSTHOOK: query: EXPLAIN EXTENDED
 658 FROM 
 659  src a
 660 RIGHT OUTER JOIN 
 661  srcpart b 
 662 ON (a.key = b.key)
 663 SELECT a.key, a.value, b.key, b.value
 664 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08'
 665POSTHOOK: type: QUERY
 666ABSTRACT SYNTAX TREE:
 667  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) a) (TOK_TABREF (TOK_TABNAME srcpart) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)) (= (. (TOK_TABLE_OR_COL b) ds) '2008-04-08')))))
 668
 669STAGE DEPENDENCIES:
 670  Stage-1 is a root stage
 671  Stage-0 is a root stage
 672
 673STAGE PLANS:
 674  Stage: Stage-1
 675    Map Reduce
 676      Alias -> Map Operator Tree:
 677        a 
 678          TableScan
 679            alias: a
 680            GatherStats: false
 681            Reduce Output Operator
 682              key expressions:
 683                    expr: key
 684                    type: string
 685              sort order: +
 686              Map-reduce partition columns:
 687                    expr: key
 688                    type: string
 689              tag: 0
 690              value expressions:
 691                    expr: key
 692                    type: string
 693                    expr: value
 694                    type: string
 695        b 
 696          TableScan
 697            alias: b
 698            GatherStats: false
 699            Filter Operator
 700              isSamplingPred: false
 701              predicate:
 702                  expr: ((key > 15) and (key < 25))
 703                  type: boolean
 704              Reduce Output Operator
 705                key expressions:
 706                      expr: key
 707                      type: string
 708                sort order: +
 709                Map-reduce partition columns:
 710                      expr: key
 711                      type: string
 712                tag: 1
 713                value expressions:
 714                      expr: key
 715                      type: string
 716                      expr: value
 717                      type: string
 718                      expr: ds
 719                      type: string
 720      Needs Tagging: true
 721      Path -> Alias:
 722        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [a]
 723        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
 724        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
 725      Path -> Partition:
 726        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src 
 727          Partition
 728            base file name: src
 729            input format: org.apache.hadoop.mapred.TextInputFormat
 730            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 731            properties:
 732              bucket_count -1
 733              columns key,value
 734              columns.types string:string
 735              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 736              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 737              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 738              name default.src
 739              serialization.ddl struct src { string key, string value}
 740              serialization.format 1
 741              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 742              transient_lastDdlTime 1297378968
 743            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 744          
 745              input format: org.apache.hadoop.mapred.TextInputFormat
 746              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 747              properties:
 748                bucket_count -1
 749                columns key,value
 750                columns.types string:string
 751                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 752                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 753                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 754                name default.src
 755                serialization.ddl struct src { string key, string value}
 756                serialization.format 1
 757                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 758                transient_lastDdlTime 1297378968
 759              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 760              name: default.src
 761            name: default.src
 762        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
 763          Partition
 764            base file name: hr=11
 765            input format: org.apache.hadoop.mapred.TextInputFormat
 766            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 767            partition values:
 768              ds 2008-04-08
 769              hr 11
 770            properties:
 771              bucket_count -1
 772              columns key,value
 773              columns.types string:string
 774              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 775              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 776              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
 777              name default.srcpart
 778              partition_columns ds/hr
 779              serialization.ddl struct srcpart { string key, string value}
 780              serialization.format 1
 781              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 782              transient_lastDdlTime 1297378962
 783            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 784          
 785              input format: org.apache.hadoop.mapred.TextInputFormat
 786              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 787              properties:
 788                bucket_count -1
 789                columns key,value
 790                columns.types string:string
 791                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 792                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 793                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 794                name default.srcpart
 795                partition_columns ds/hr
 796                serialization.ddl struct srcpart { string key, string value}
 797                serialization.format 1
 798                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 799                transient_lastDdlTime 1297378962
 800              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 801              name: default.srcpart
 802            name: default.srcpart
 803        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
 804          Partition
 805            base file name: hr=12
 806            input format: org.apache.hadoop.mapred.TextInputFormat
 807            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 808            partition values:
 809              ds 2008-04-08
 810              hr 12
 811            properties:
 812              bucket_count -1
 813              columns key,value
 814              columns.types string:string
 815              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 816              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 817              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
 818              name default.srcpart
 819              partition_columns ds/hr
 820              serialization.ddl struct srcpart { string key, string value}
 821              serialization.format 1
 822              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 823              transient_lastDdlTime 1297378962
 824            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 825          
 826              input format: org.apache.hadoop.mapred.TextInputFormat
 827              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 828              properties:
 829                bucket_count -1
 830                columns key,value
 831                columns.types string:string
 832                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 833                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 834                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
 835                name default.srcpart
 836                partition_columns ds/hr
 837                serialization.ddl struct srcpart { string key, string value}
 838                serialization.format 1
 839                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 840                transient_lastDdlTime 1297378962
 841              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 842              name: default.srcpart
 843            name: default.srcpart
 844      Reduce Operator Tree:
 845        Join Operator
 846          condition map:
 847               Right Outer Join0 to 1
 848          condition expressions:
 849            0 {VALUE._col0} {VALUE._col1}
 850            1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
 851          handleSkewJoin: false
 852          outputColumnNames: _col0, _col1, _col4, _col5, _col6
 853          Filter Operator
 854            isSamplingPred: false
 855            predicate:
 856                expr: ((_col0 > 10) and (_col0 < 20))
 857                type: boolean
 858            Select Operator
 859              expressions:
 860                    expr: _col0
 861                    type: string
 862                    expr: _col1
 863                    type: string
 864                    expr: _col4
 865                    type: string
 866                    expr: _col5
 867                    type: string
 868              outputColumnNames: _col0, _col1, _col2, _col3
 869              File Output Operator
 870                compressed: false
 871                GlobalTableId: 0
 872                directory: file:/tmp/sdong/hive_2011-02-10_17-02-00_948_2573378846116151448/-ext-10001
 873                NumFilesPerFileSink: 1
 874                Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-02-00_948_2573378846116151448/-ext-10001/
 875                table:
 876                    input format: org.apache.hadoop.mapred.TextInputFormat
 877                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 878                    properties:
 879                      columns _col0,_col1,_col2,_col3
 880                      columns.types string:string:string:string
 881                      serialization.format 1
 882                TotalFiles: 1
 883                GatherStats: false
 884                MultiFileSpray: false
 885
 886  Stage: Stage-0
 887    Fetch Operator
 888      limit: -1
 889
 890
 891PREHOOK: query: FROM 
 892  src a
 893 RIGHT OUTER JOIN 
 894  srcpart b 
 895 ON (a.key = b.key)
 896 SELECT a.key, a.value, b.key, b.value
 897 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08'
 898PREHOOK: type: QUERY
 899PREHOOK: Input: default@src
 900PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 901PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 902PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-01_089_7899465838633645287/-mr-10000
 903POSTHOOK: query: FROM 
 904  src a
 905 RIGHT OUTER JOIN 
 906  srcpart b 
 907 ON (a.key = b.key)
 908 SELECT a.key, a.value, b.key, b.value
 909 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08'
 910POSTHOOK: type: QUERY
 911POSTHOOK: Input: default@src
 912POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 913POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 914POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-02-01_089_7899465838633645287/-mr-10000
 91517	val_17	17	val_17
 91617	val_17	17	val_17
 91718	val_18	18	val_18
 91818	val_18	18	val_18
 91918	val_18	18	val_18
 92018	val_18	18	val_18
 92118	val_18	18	val_18
 92218	val_18	18	val_18
 92318	val_18	18	val_18
 92418	val_18	18	val_18
 92519	val_19	19	val_19
 92619	val_19	19	val_19
 927PREHOOK: query: EXPLAIN EXTENDED
 928 FROM 
 929  srcpart a
 930 RIGHT OUTER JOIN 
 931  src b 
 932 ON (a.key = b.key)
 933 SELECT a.key, a.value, b.key, b.value
 934 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08'
 935PREHOOK: type: QUERY
 936POSTHOOK: query: EXPLAIN EXTENDED
 937 FROM 
 938  srcpart a
 939 RIGHT OUTER JOIN 
 940  src b 
 941 ON (a.key = b.key)
 942 SELECT a.key, a.value, b.key, b.value
 943 WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08'
 944POSTHOOK: type: QUERY
 945ABSTRACT SYNTAX TREE:
 946  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME srcpart) a) (TOK_TABREF (TOK_TABNAME src) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL b) value))) (TOK_WHERE (AND (AND (AND (AND (> (. (TOK_TABLE_OR_COL a) key) 10) (< (. (TOK_TABLE_OR_COL a) key) 20)) (> (. (TOK_TABLE_OR_COL b) key) 15)) (< (. (TOK_TABLE_OR_COL b) key) 25)) (= (. (TOK_TABLE_OR_COL a) ds) '2008-04-08')))))
 947
 948STAGE DEPENDENCIES:
 949  Stage-1 is a root stage
 950  Stage-0 is a root stage
 951
 952STAGE PLANS:
 953  Stage: Stage-1
 954    Map Reduce
 955      Alias -> Map Operator Tree:
 956        a 
 957          TableScan
 958            alias: a
 959            GatherStats: false
 960            Reduce Output Operator
 961              key expressions:
 962                    expr: key
 963                    type: string
 964              sort order: +
 965              Map-reduce partition columns:
 966                    expr: key
 967                    type: string
 968              tag: 0
 969              value expressions:
 970                    expr: key
 971                    type: string
 972                    expr: value
 973                    type: string
 974                    expr: ds
 975                    type: string
 976        b 
 977          TableScan
 978            alias: b
 979            GatherStats: false
 980            Filter Operator
 981              isSamplingPred: false
 982              predicate:
 983                  expr: ((key > 15) and (key < 25))
 984                  type: boolean
 985              Reduce Output Operator
 986                key expressions:
 987                      expr: key
 988                      type: string
 989                sort order: +
 990                Map-reduce partition columns:
 991                      expr: key
 992                      type: string
 993                tag: 1
 994                value expressions:
 995                      expr: key
 996                      type: string
 997                      expr: value
 998                      type: string
 999      Needs Tagging: true
1000      Path -> Alias:
1001        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [b]
1002        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
1003        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
1004        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [a]
1005        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [a]
1006      Path -> Partition:
1007        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src 
1008          Partition
1009            base file name: src
1010            input format: org.apache.hadoop.mapred.TextInputFormat
1011            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1012            properties:
1013              bucket_count -1
1014              columns key,value
1015              columns.types string:string
1016              file.inputformat org.apache.hadoop.mapred.TextInputFormat
1017              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1018              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
1019              name default.src
1020              serialization.ddl struct src { string key, string value}
1021              serialization.format 1
1022              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1023              transient_lastDdlTime 1297378968
1024            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1025          
1026              input format: org.apache.hadoop.mapred.TextInputFormat
1027              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1028              properties:
1029                bucket_count -1
1030                columns key,value
1031                columns.types string:string
1032                file.inputformat org.apache.hadoop.mapred.TextInputFormat
1033                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1034                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
1035                name default.src
1036                serialization.ddl struct src { string key, string value}
1037                serialization.format 1
1038                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1039                transient_lastDdlTime 1297378968
1040              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1041              name: default.src
1042            name: default.src
1043        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
1044          Partition
1045            base file name: hr=11
1046            input format: org.apache.hadoop.mapred.TextInputFormat
1047            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1048            partition values:
1049              ds 2008-04-08
1050              hr 11
1051            properties:
1052              bucket_count -1
1053              columns key,value
1054              columns.types string:string
1055              file.inputformat org.apache.hadoop.mapred.TextInputFormat
1056              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1057              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
1058              name default.srcpart
1059              partition_columns ds/hr
1060              serialization.ddl struct srcpart { string key, string value}
1061              serialization.format 1
1062              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1063              transient_lastDdlTime 1297378962
1064            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1065          
1066              input format: org.apache.hadoop.mapred.TextInputFormat
1067              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1068              properties:
1069                bucket_count -1
1070                columns key,value
1071                columns.types string:string
1072                file.inputformat org.apache.hadoop.mapred.TextInputFormat
1073                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1074                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart
1075                name default.srcpart
1076                partition_columns ds/hr
1077                serialization.ddl struct srcpart { string key, string value}
1078                serialization.format 1
1079                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1080                transient_lastDdlTime 1297378962
1081              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1082              name: default.srcpart
1083            name: default.srcpart
1084        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/h…

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