PREHOOK: query: -- SORT_QUERY_RESULTS
-- test automatic use of index on table with partitions
CREATE INDEX src_part_index ON TABLE srcpart(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: Input: default@srcpart
POSTHOOK: query: -- SORT_QUERY_RESULTS
-- test automatic use of index on table with partitions
CREATE INDEX src_part_index ON TABLE srcpart(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
POSTHOOK: Input: default@srcpart
POSTHOOK: Output: default@default__srcpart_src_part_index__
PREHOOK: query: ALTER INDEX src_part_index ON srcpart REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
PREHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-08/hr=11
PREHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-08/hr=12
PREHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=11
PREHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=12
POSTHOOK: query: ALTER INDEX src_part_index ON srcpart REBUILD
POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
POSTHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-08/hr=11
POSTHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-08/hr=12
POSTHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=11
POSTHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=12
POSTHOOK: Lineage: default__srcpart_src_part_index__ PARTITION(ds=2008-04-09,hr=12)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__srcpart_src_part_index__ PARTITION(ds=2008-04-09,hr=12)._offsets EXPRESSION [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__srcpart_src_part_index__ PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: EXPLAIN SELECT key, value FROM srcpart WHERE key=86 AND ds='2008-04-09'
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key, value FROM srcpart WHERE key=86 AND ds='2008-04-09'
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-3 is a root stage
  Stage-8 depends on stages: Stage-3 , consists of Stage-5, Stage-4, Stage-6
  Stage-5
  Stage-2 depends on stages: Stage-5, Stage-4, Stage-7
  Stage-1 depends on stages: Stage-2
  Stage-4
  Stage-6
  Stage-7 depends on stages: Stage-6
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-3
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: default.default__srcpart_src_part_index__
            filterExpr: ((UDFToDouble(key) = 86.0) and (ds = '2008-04-09')) (type: boolean)
            Filter Operator
              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
              Select Operator
                expressions: _bucketname (type: string), _offsets (type: array<bigint>)
                outputColumnNames: _col0, _col1
                File Output Operator
                  compressed: false
                  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-8
    Conditional Operator

  Stage: Stage-5
    Move Operator
      files:
          hdfs directory: true
#### A masked pattern was here ####

  Stage: Stage-2
    Move Operator
      files:
          hdfs directory: true
#### A masked pattern was here ####

  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: srcpart
            filterExpr: ((UDFToDouble(key) = 86.0) and (ds = '2008-04-09')) (type: boolean)
            Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (UDFToDouble(key) = 86.0) (type: boolean)
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: '86' (type: string), value (type: string)
                outputColumnNames: _col0, _col1
                Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
                  Statistics: Num rows: 500 Data size: 5312 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-4
    Map Reduce
      Map Operator Tree:
          TableScan
            File Output Operator
              compressed: false
              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-6
    Map Reduce
      Map Operator Tree:
          TableScan
            File Output Operator
              compressed: false
              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-7
    Move Operator
      files:
          hdfs directory: true
#### A masked pattern was here ####

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

PREHOOK: query: SELECT key, value FROM srcpart WHERE key=86 AND ds='2008-04-09'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__srcpart_src_part_index__
PREHOOK: Input: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=11
PREHOOK: Input: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=12
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, value FROM srcpart WHERE key=86 AND ds='2008-04-09'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__srcpart_src_part_index__
POSTHOOK: Input: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=11
POSTHOOK: Input: default@default__srcpart_src_part_index__@ds=2008-04-09/hr=12
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
#### A masked pattern was here ####
86	val_86
86	val_86
PREHOOK: query: DROP INDEX src_part_index ON srcpart
PREHOOK: type: DROPINDEX
PREHOOK: Input: default@srcpart
POSTHOOK: query: DROP INDEX src_part_index ON srcpart
POSTHOOK: type: DROPINDEX
POSTHOOK: Input: default@srcpart