PREHOOK: query: -- SORT_QUERY_RESULTS

CREATE TABLE srcpart_rc (key int, value string) PARTITIONED BY (ds string, hr int) STORED AS RCFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@srcpart_rc
POSTHOOK: query: -- SORT_QUERY_RESULTS

CREATE TABLE srcpart_rc (key int, value string) PARTITIONED BY (ds string, hr int) STORED AS RCFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@srcpart_rc
PREHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-08', hr=11) SELECT key, value FROM srcpart WHERE ds = '2008-04-08' AND hr = 11
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Output: default@srcpart_rc@ds=2008-04-08/hr=11
POSTHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-08', hr=11) SELECT key, value FROM srcpart WHERE ds = '2008-04-08' AND hr = 11
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Output: default@srcpart_rc@ds=2008-04-08/hr=11
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-08,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-08', hr=12) SELECT key, value FROM srcpart WHERE ds = '2008-04-08' AND hr = 12
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Output: default@srcpart_rc@ds=2008-04-08/hr=12
POSTHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-08', hr=12) SELECT key, value FROM srcpart WHERE ds = '2008-04-08' AND hr = 12
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Output: default@srcpart_rc@ds=2008-04-08/hr=12
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-09', hr=11) SELECT key, value FROM srcpart WHERE ds = '2008-04-09' AND hr = 11
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Output: default@srcpart_rc@ds=2008-04-09/hr=11
POSTHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-09', hr=11) SELECT key, value FROM srcpart WHERE ds = '2008-04-09' AND hr = 11
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Output: default@srcpart_rc@ds=2008-04-09/hr=11
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-09,hr=11).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-09', hr=12) SELECT key, value FROM srcpart WHERE ds = '2008-04-09' AND hr = 12
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
PREHOOK: Output: default@srcpart_rc@ds=2008-04-09/hr=12
POSTHOOK: query: INSERT OVERWRITE TABLE srcpart_rc PARTITION (ds='2008-04-09', hr=12) SELECT key, value FROM srcpart WHERE ds = '2008-04-09' AND hr = 12
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
POSTHOOK: Output: default@srcpart_rc@ds=2008-04-09/hr=12
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-09,hr=12).key EXPRESSION [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: srcpart_rc PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: Input: default@srcpart_rc
POSTHOOK: query: CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__
PREHOOK: query: ALTER INDEX srcpart_rc_index ON srcpart_rc REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@srcpart_rc
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
POSTHOOK: query: ALTER INDEX srcpart_rc_index ON srcpart_rc REBUILD
POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ PARTITION(ds=2008-04-09,hr=12)._bucketname SIMPLE [(srcpart_rc)srcpart_rc.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ PARTITION(ds=2008-04-09,hr=12)._offsets EXPRESSION [(srcpart_rc)srcpart_rc.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
PREHOOK: query: SELECT x.* FROM default__srcpart_rc_srcpart_rc_index__ x WHERE x.ds = '2008-04-08' and x.hr = 11
PREHOOK: type: QUERY
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: query: SELECT x.* FROM default__srcpart_rc_srcpart_rc_index__ x WHERE x.ds = '2008-04-08' and x.hr = 11
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
#### A masked pattern was here ####
PREHOOK: type: QUERY
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
#### A masked pattern was here ####
PREHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100 AND ds = '2008-04-08'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart_rc
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100 AND ds = '2008-04-08'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
#### A masked pattern was here ####
100	val_100
100	val_100
100	val_100
100	val_100
#### A masked pattern was here ####
PREHOOK: type: QUERY
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
#### A masked pattern was here ####
PREHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100 AND ds = '2008-04-08' and hr = 11
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart_rc
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100 AND ds = '2008-04-08' and hr = 11
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
#### A masked pattern was here ####
100	val_100
100	val_100
PREHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100 AND ds = '2008-04-08' and hr = 11
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart_rc
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100 AND ds = '2008-04-08' and hr = 11
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
#### A masked pattern was here ####
100	val_100
100	val_100
PREHOOK: query: DROP INDEX srcpart_rc_index on srcpart_rc
PREHOOK: type: DROPINDEX
PREHOOK: Input: default@srcpart_rc
POSTHOOK: query: DROP INDEX srcpart_rc_index on srcpart_rc
POSTHOOK: type: DROPINDEX
POSTHOOK: Input: default@srcpart_rc
PREHOOK: query: EXPLAIN
CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
POSTHOOK: query: EXPLAIN
CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0

PREHOOK: query: CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: Input: default@srcpart_rc
POSTHOOK: query: CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__
PREHOOK: query: ALTER  INDEX srcpart_rc_index ON srcpart_rc REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@srcpart_rc
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
PREHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
POSTHOOK: query: ALTER  INDEX srcpart_rc_index ON srcpart_rc REBUILD
POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
POSTHOOK: Output: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ PARTITION(ds=2008-04-09,hr=12)._bucketname SIMPLE [(srcpart_rc)srcpart_rc.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ PARTITION(ds=2008-04-09,hr=12)._offsets EXPRESSION [(srcpart_rc)srcpart_rc.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
PREHOOK: query: SELECT x.* FROM default__srcpart_rc_srcpart_rc_index__ x
PREHOOK: type: QUERY
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT x.* FROM default__srcpart_rc_srcpart_rc_index__ x
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
#### A masked pattern was here ####
PREHOOK: type: QUERY
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
PREHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
#### A masked pattern was here ####
POSTHOOK: type: QUERY
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=12
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=11
POSTHOOK: Input: default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-09/hr=12
#### A masked pattern was here ####
PREHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart_rc
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
#### A masked pattern was here ####
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
PREHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart_rc
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, value FROM srcpart_rc WHERE key=100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart_rc@ds=2008-04-09/hr=12
#### A masked pattern was here ####
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
100	val_100
PREHOOK: query: DROP INDEX srcpart_rc_index on srcpart_rc
PREHOOK: type: DROPINDEX
PREHOOK: Input: default@srcpart_rc
POSTHOOK: query: DROP INDEX srcpart_rc_index on srcpart_rc
POSTHOOK: type: DROPINDEX
POSTHOOK: Input: default@srcpart_rc
PREHOOK: query: DROP TABLE srcpart_rc
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@srcpart_rc
PREHOOK: Output: default@srcpart_rc
POSTHOOK: query: DROP TABLE srcpart_rc
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@srcpart_rc
POSTHOOK: Output: default@srcpart_rc