PREHOOK: query: -- SORT_QUERY_RESULTS DROP INDEX srcpart_index_proj on srcpart PREHOOK: type: DROPINDEX PREHOOK: Input: default@srcpart POSTHOOK: query: -- SORT_QUERY_RESULTS DROP INDEX srcpart_index_proj on srcpart POSTHOOK: type: DROPINDEX POSTHOOK: Input: default@srcpart PREHOOK: query: EXPLAIN CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX POSTHOOK: query: EXPLAIN CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 PREHOOK: query: CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX PREHOOK: Input: default@srcpart POSTHOOK: query: CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX POSTHOOK: Input: default@srcpart POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__ PREHOOK: query: ALTER INDEX srcpart_index_proj 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_srcpart_index_proj__@ds=2008-04-08/hr=11 PREHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 PREHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 PREHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 POSTHOOK: query: ALTER INDEX srcpart_index_proj 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_srcpart_index_proj__@ds=2008-04-08/hr=11 POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12)._offset SIMPLE [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] PREHOOK: query: SELECT x.* FROM default__srcpart_srcpart_index_proj__ x WHERE x.ds = '2008-04-08' and x.hr = 11 PREHOOK: type: QUERY PREHOOK: Input: default@default__srcpart_srcpart_index_proj__ PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 #### A masked pattern was here #### POSTHOOK: query: SELECT x.* FROM default__srcpart_srcpart_index_proj__ x WHERE x.ds = '2008-04-08' and x.hr = 11 POSTHOOK: type: QUERY POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__ POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 #### A masked pattern was here #### COLLECT_SET(`_offset`) as `_offsets` FROM default__srcpart_srcpart_index_proj__ x WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND x.key=100 AND x.ds = '2008-04-08' GROUP BY `_bucketname` PREHOOK: type: QUERY PREHOOK: Input: default@default__srcpart_srcpart_index_proj__ PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 #### A masked pattern was here #### COLLECT_SET(`_offset`) as `_offsets` FROM default__srcpart_srcpart_index_proj__ x WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND x.key=100 AND x.ds = '2008-04-08' GROUP BY `_bucketname` POSTHOOK: type: QUERY POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__ POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 #### A masked pattern was here #### PREHOOK: query: SELECT key, value FROM srcpart WHERE key=100 AND ds = '2008-04-08' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### POSTHOOK: query: SELECT key, value FROM srcpart WHERE key=100 AND ds = '2008-04-08' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Input: default@srcpart@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 #### COLLECT_SET(`_offset`) as `_offsets` FROM default__srcpart_srcpart_index_proj__ x WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND x.key=100 AND x.ds = '2008-04-08' and x.hr = 11 GROUP BY `_bucketname` PREHOOK: type: QUERY PREHOOK: Input: default@default__srcpart_srcpart_index_proj__ PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 #### A masked pattern was here #### COLLECT_SET(`_offset`) as `_offsets` FROM default__srcpart_srcpart_index_proj__ x WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND x.key=100 AND x.ds = '2008-04-08' and x.hr = 11 GROUP BY `_bucketname` POSTHOOK: type: QUERY POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__ POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 #### A masked pattern was here #### PREHOOK: query: SELECT key, value FROM srcpart WHERE key=100 AND ds = '2008-04-08' and hr = 11 PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 #### A masked pattern was here #### POSTHOOK: query: SELECT key, value FROM srcpart WHERE key=100 AND ds = '2008-04-08' and hr = 11 POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 #### A masked pattern was here #### 100 val_100 100 val_100 PREHOOK: query: SELECT key, value FROM srcpart WHERE key=100 AND ds = '2008-04-08' and hr = 11 PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 #### A masked pattern was here #### POSTHOOK: query: SELECT key, value FROM srcpart WHERE key=100 AND ds = '2008-04-08' and hr = 11 POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 #### A masked pattern was here #### 100 val_100 100 val_100 PREHOOK: query: DROP INDEX srcpart_index_proj on srcpart PREHOOK: type: DROPINDEX PREHOOK: Input: default@srcpart POSTHOOK: query: DROP INDEX srcpart_index_proj on srcpart POSTHOOK: type: DROPINDEX POSTHOOK: Input: default@srcpart PREHOOK: query: EXPLAIN CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX POSTHOOK: query: EXPLAIN CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 PREHOOK: query: CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX PREHOOK: Input: default@srcpart POSTHOOK: query: CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX POSTHOOK: Input: default@srcpart POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__ PREHOOK: query: ALTER INDEX srcpart_index_proj 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_srcpart_index_proj__@ds=2008-04-08/hr=11 PREHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 PREHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 PREHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 POSTHOOK: query: ALTER INDEX srcpart_index_proj 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_srcpart_index_proj__@ds=2008-04-08/hr=11 POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 POSTHOOK: Output: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12)._offset SIMPLE [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] PREHOOK: query: SELECT x.* FROM default__srcpart_srcpart_index_proj__ x PREHOOK: type: QUERY PREHOOK: Input: default@default__srcpart_srcpart_index_proj__ PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 #### A masked pattern was here #### POSTHOOK: query: SELECT x.* FROM default__srcpart_srcpart_index_proj__ x POSTHOOK: type: QUERY POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__ POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 #### A masked pattern was here #### COLLECT_SET(`_offset`) as `_offsets` FROM default__srcpart_srcpart_index_proj__ WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND key=100 GROUP BY `_bucketname` PREHOOK: type: QUERY PREHOOK: Input: default@default__srcpart_srcpart_index_proj__ PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 PREHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 #### A masked pattern was here #### COLLECT_SET(`_offset`) as `_offsets` FROM default__srcpart_srcpart_index_proj__ WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND key=100 GROUP BY `_bucketname` POSTHOOK: type: QUERY POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__ POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=11 POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-08/hr=12 POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=11 POSTHOOK: Input: default@default__srcpart_srcpart_index_proj__@ds=2008-04-09/hr=12 #### A masked pattern was here #### PREHOOK: query: SELECT key, value FROM srcpart WHERE key=100 PREHOOK: type: QUERY 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 #### A masked pattern was here #### POSTHOOK: query: SELECT key, value FROM srcpart WHERE key=100 POSTHOOK: type: QUERY 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 #### 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 WHERE key=100 PREHOOK: type: QUERY 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 #### A masked pattern was here #### POSTHOOK: query: SELECT key, value FROM srcpart WHERE key=100 POSTHOOK: type: QUERY 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 #### 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_index_proj on srcpart PREHOOK: type: DROPINDEX PREHOOK: Input: default@srcpart POSTHOOK: query: DROP INDEX srcpart_index_proj on srcpart POSTHOOK: type: DROPINDEX POSTHOOK: Input: default@srcpart