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 NOT ds < 2012-11-31 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE NOT ds < 2012-11-31 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: (not (UDFToDouble(ds) < 1970.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 NOT ds < 2012-11-31 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 NOT ds < 2012-11-31 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