PREHOOK: query: explain
SELECT value from (
  select explode(array(key, value)) as (value) from (
    select * FROM src WHERE key > 400
  ) A
) B WHERE value < 450
PREHOOK: type: QUERY
POSTHOOK: query: explain
SELECT value from (
  select explode(array(key, value)) as (value) from (
    select * FROM src WHERE key > 400
  ) A
) B WHERE value < 450
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: src
            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (key > 400) (type: boolean)
              Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: array(key,value) (type: array<string>)
                outputColumnNames: _col0
                Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
                UDTF Operator
                  Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
                  function name: explode
                  Filter Operator
                    predicate: (col < 450) (type: boolean)
                    Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                    Select Operator
                      expressions: col (type: string)
                      outputColumnNames: _col0
                      Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                      File Output Operator
                        compressed: false
                        Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                        table:
                            input format: org.apache.hadoop.mapred.TextInputFormat
                            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink

PREHOOK: query: SELECT value from (
  select explode(array(key, value)) as (value) from (
    select * FROM src WHERE key > 400
  ) A
) B WHERE value < 450
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT value from (
  select explode(array(key, value)) as (value) from (
    select * FROM src WHERE key > 400
  ) A
) B WHERE value < 450
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
409
401
406
429
403
417
430
446
413
417
439
438
427
437
430
404
411
431
418
404
436
409
413
419
435
401
402
430
449
401
438
432
403
406
409
406
401
424
431
431
424
438
414
439
417
444
429
443
406
401
421
407
448
414
403