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