PREHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@npe_test
POSTHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@npe_test
PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11')
SELECT src.key, src.value FROM src WHERE key < '200'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@npe_test@ds=2012-12-11
POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11')
SELECT src.key, src.value FROM src WHERE key < '200'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@npe_test@ds=2012-12-11
POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12')
SELECT src.key, src.value FROM src WHERE key > '200'
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@npe_test@ds=2012-12-12
POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12')
SELECT src.key, src.value FROM src WHERE key > '200'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@npe_test@ds=2012-12-12
POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: SELECT count(*) FROM npe_test
PREHOOK: type: QUERY
PREHOOK: Input: default@npe_test
PREHOOK: Input: default@npe_test@ds=2012-12-11
PREHOOK: Input: default@npe_test@ds=2012-12-12
#### A masked pattern was here ####
POSTHOOK: query: SELECT count(*) FROM npe_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@npe_test
POSTHOOK: Input: default@npe_test@ds=2012-12-11
POSTHOOK: Input: default@npe_test@ds=2012-12-12
#### A masked pattern was here ####
498
PREHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15
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: npe_test
            Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: ((UDFToDouble(ds) > 1970.0) or (UDFToDouble(ds) < 1985.0)) (type: boolean)
              Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: key (type: string), value (type: string), ds (type: string)
                outputColumnNames: _col0, _col1, _col2
                Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
                  Statistics: Num rows: 332 Data size: 3526 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 count(*) FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15
PREHOOK: type: QUERY
PREHOOK: Input: default@npe_test
PREHOOK: Input: default@npe_test@ds=2012-12-11
PREHOOK: Input: default@npe_test@ds=2012-12-12
#### A masked pattern was here ####
POSTHOOK: query: SELECT count(*) FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15
POSTHOOK: type: QUERY
POSTHOOK: Input: default@npe_test
POSTHOOK: Input: default@npe_test@ds=2012-12-11
POSTHOOK: Input: default@npe_test@ds=2012-12-12
#### A masked pattern was here ####
0
PREHOOK: query: DROP TABLE npe_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@npe_test
PREHOOK: Output: default@npe_test
POSTHOOK: query: DROP TABLE npe_test
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@npe_test
POSTHOOK: Output: default@npe_test