[04/15] hive git commit: HIVE-18448: Drop Support For Indexes From Apache Hive (Zoltan Haindrich reviewed by Ashutosh Chauhan)

[kgyrtkirk]

http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_bitmap_rc.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_bitmap_rc.q.out 
b/ql/src/test/results/clientpositive/index_bitmap_rc.q.out
deleted file mode 100644
index 046442c..0000000
--- a/ql/src/test/results/clientpositive/index_bitmap_rc.q.out
+++ /dev/null
@@ -1,349 +0,0 @@
-PREHOOK: query: 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: 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: EXPLAIN
-CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 'BITMAP' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-POSTHOOK: query: EXPLAIN
-CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(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_rc_index ON TABLE srcpart_rc(key) as 
'BITMAP' WITH DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@srcpart_rc
-POSTHOOK: query: CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 
'BITMAP' 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-08,hr=11)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,hr=11)._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-08,hr=11)._offset SIMPLE 
[(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-08,hr=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,hr=12)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,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-08,hr=12)._offset SIMPLE 
[(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-08,hr=12).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=11)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=11)._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=11)._offset SIMPLE 
[(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=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=12)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-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)._offset SIMPLE 
[(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 ####
-COLLECT_SET(`_offset`) as `_offsets` FROM 
default__srcpart_rc_srcpart_rc_index__
-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_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 ####
-COLLECT_SET(`_offset`) as `_offsets` FROM 
default__srcpart_rc_srcpart_rc_index__
-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_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 ####
-COLLECT_SET(`_offset`) as `_offsets` FROM 
default__srcpart_rc_srcpart_rc_index__
-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_rc_srcpart_rc_index__
-PREHOOK: Input: 
default@default__srcpart_rc_srcpart_rc_index__@ds=2008-04-08/hr=11
-#### A masked pattern was here ####
-COLLECT_SET(`_offset`) as `_offsets` FROM 
default__srcpart_rc_srcpart_rc_index__
-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_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 'BITMAP' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-POSTHOOK: query: EXPLAIN
-CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(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_rc_index ON TABLE srcpart_rc(key) as 
'BITMAP' WITH DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@srcpart_rc
-POSTHOOK: query: CREATE INDEX srcpart_rc_index ON TABLE srcpart_rc(key) as 
'BITMAP' 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-08,hr=11)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,hr=11)._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-08,hr=11)._offset SIMPLE 
[(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-08,hr=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,hr=12)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,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-08,hr=12)._offset SIMPLE 
[(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-08,hr=12).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=11)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=11)._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=11)._offset SIMPLE 
[(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=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=12)._bitmaps EXPRESSION 
[(srcpart_rc)srcpart_rc.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, 
type:bigint, comment:), ]
-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)._offset SIMPLE 
[(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.key = 100
-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 
WHERE x.key = 100
-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 ####
-COLLECT_SET(`_offset`) as `_offsets` FROM 
default__srcpart_rc_srcpart_rc_index__
-WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND key=100 GROUP BY `_bucketname`
-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 ####
-COLLECT_SET(`_offset`) as `_offsets` FROM 
default__srcpart_rc_srcpart_rc_index__
-WHERE NOT EWAH_BITMAP_EMPTY(`_bitmaps`) AND key=100 GROUP BY `_bucketname`
-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

http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_compact.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_compact.q.out 
b/ql/src/test/results/clientpositive/index_compact.q.out
deleted file mode 100644
index 97d7bac..0000000
--- a/ql/src/test/results/clientpositive/index_compact.q.out
+++ /dev/null
@@ -1,271 +0,0 @@
-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 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-POSTHOOK: query: EXPLAIN
-CREATE INDEX srcpart_index_proj ON TABLE srcpart(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_index_proj ON TABLE srcpart(key) as 
'COMPACT' WITH DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@srcpart
-POSTHOOK: query: CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 
'COMPACT' 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-08,hr=11)._bucketname SIMPLE 
[(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,hr=11)._offsets EXPRESSION 
[(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, 
comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,hr=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,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-08,hr=12)._offsets EXPRESSION 
[(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, 
comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,hr=12).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-09,hr=11)._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=11)._offsets EXPRESSION 
[(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, 
comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-09,hr=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
-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)._offsets EXPRESSION 
[(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 ####
-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 ####
-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 ####
-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: 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 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-POSTHOOK: query: EXPLAIN
-CREATE INDEX srcpart_index_proj ON TABLE srcpart(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_index_proj ON TABLE srcpart(key) as 
'COMPACT' WITH DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@srcpart
-POSTHOOK: query: CREATE INDEX srcpart_index_proj ON TABLE srcpart(key) as 
'COMPACT' 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-08,hr=11)._bucketname SIMPLE 
[(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,hr=11)._offsets EXPRESSION 
[(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, 
comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,hr=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,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-08,hr=12)._offsets EXPRESSION 
[(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, 
comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-08,hr=12).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-09,hr=11)._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=11)._offsets EXPRESSION 
[(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, 
comment:), ]
-POSTHOOK: Lineage: default__srcpart_srcpart_index_proj__ 
PARTITION(ds=2008-04-09,hr=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
-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)._offsets EXPRESSION 
[(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 ####
-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: 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

http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_compact_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_compact_1.q.out 
b/ql/src/test/results/clientpositive/index_compact_1.q.out
deleted file mode 100644
index 7be9ada..0000000
--- a/ql/src/test/results/clientpositive/index_compact_1.q.out
+++ /dev/null
@@ -1,70 +0,0 @@
-PREHOOK: query: EXPLAIN
-CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-POSTHOOK: query: EXPLAIN
-CREATE INDEX src_index ON TABLE src(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 src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-POSTHOOK: type: CREATEINDEX
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@default__src_src_index__
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: ALTERINDEX_REBUILD
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@default__src_src_index__
-POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE 
[(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION 
[(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), 
]
-POSTHOOK: Lineage: default__src_src_index__.key SIMPLE 
[(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT x.* FROM default__src_src_index__ x
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT x.* FROM default__src_src_index__ x
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@default__src_src_index__
-#### A masked pattern was here ####
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-#### A masked pattern was here ####
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@default__src_src_index__
-#### A masked pattern was here ####
-PREHOOK: query: SELECT key, value FROM src WHERE key=100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT key, value FROM src WHERE key=100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-100    val_100
-100    val_100
-PREHOOK: query: SELECT key, value FROM src WHERE key=100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT key, value FROM src WHERE key=100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-100    val_100
-100    val_100
-PREHOOK: query: DROP INDEX src_index on src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src
-POSTHOOK: query: DROP INDEX src_index on src
-POSTHOOK: type: DROPINDEX
-POSTHOOK: Input: default@src

http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_compact_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_compact_2.q.out 
b/ql/src/test/results/clientpositive/index_compact_2.q.out
deleted file mode 100644
index 28ba095..0000000
--- a/ql/src/test/results/clientpositive/index_compact_2.q.out
+++ /dev/null
@@ -1,317 +0,0 @@
-PREHOOK: query: 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: 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-08,hr=11)._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-08,hr=11)._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-08,hr=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,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-08,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-08,hr=12).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=11)._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=11)._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=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-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-08,hr=11)._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-08,hr=11)._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-08,hr=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-08,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-08,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-08,hr=12).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: default__srcpart_rc_srcpart_rc_index__ 
PARTITION(ds=2008-04-09,hr=11)._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=11)._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=11).key SIMPLE 
[(srcpart_rc)srcpart_rc.FieldSchema(name:key, type:int, comment:null), ]
-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

http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_compact_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_compact_3.q.out 
b/ql/src/test/results/clientpositive/index_compact_3.q.out
deleted file mode 100644
index 14a5927..0000000
--- a/ql/src/test/results/clientpositive/index_compact_3.q.out
+++ /dev/null
@@ -1,84 +0,0 @@
-PREHOOK: query: CREATE TABLE src_index_test_rc (key int, value string) STORED 
AS RCFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@src_index_test_rc
-POSTHOOK: query: CREATE TABLE src_index_test_rc (key int, value string) STORED 
AS RCFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@src_index_test_rc
-PREHOOK: query: INSERT OVERWRITE TABLE src_index_test_rc SELECT * FROM src
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@src_index_test_rc
-POSTHOOK: query: INSERT OVERWRITE TABLE src_index_test_rc SELECT * FROM src
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@src_index_test_rc
-POSTHOOK: Lineage: src_index_test_rc.key EXPRESSION 
[(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: src_index_test_rc.value SIMPLE 
[(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: CREATE INDEX src_index ON TABLE src_index_test_rc(key) as 
'COMPACT' WITH DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src_index_test_rc
-POSTHOOK: query: CREATE INDEX src_index ON TABLE src_index_test_rc(key) as 
'COMPACT' WITH DEFERRED REBUILD
-POSTHOOK: type: CREATEINDEX
-POSTHOOK: Input: default@src_index_test_rc
-POSTHOOK: Output: default@default__src_index_test_rc_src_index__
-PREHOOK: query: ALTER INDEX src_index ON src_index_test_rc REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src_index_test_rc
-PREHOOK: Output: default@default__src_index_test_rc_src_index__
-POSTHOOK: query: ALTER INDEX src_index ON src_index_test_rc REBUILD
-POSTHOOK: type: ALTERINDEX_REBUILD
-POSTHOOK: Input: default@src_index_test_rc
-POSTHOOK: Output: default@default__src_index_test_rc_src_index__
-POSTHOOK: Lineage: default__src_index_test_rc_src_index__._bucketname SIMPLE 
[(src_index_test_rc)src_index_test_rc.FieldSchema(name:INPUT__FILE__NAME, 
type:string, comment:), ]
-POSTHOOK: Lineage: default__src_index_test_rc_src_index__._offsets EXPRESSION 
[(src_index_test_rc)src_index_test_rc.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE,
 type:bigint, comment:), ]
-POSTHOOK: Lineage: default__src_index_test_rc_src_index__.key SIMPLE 
[(src_index_test_rc)src_index_test_rc.FieldSchema(name:key, type:int, 
comment:null), ]
-PREHOOK: query: SELECT x.* FROM default__src_index_test_rc_src_index__ x
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_index_test_rc_src_index__
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT x.* FROM default__src_index_test_rc_src_index__ x
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@default__src_index_test_rc_src_index__
-#### A masked pattern was here ####
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_index_test_rc_src_index__
-#### A masked pattern was here ####
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@default__src_index_test_rc_src_index__
-#### A masked pattern was here ####
-PREHOOK: query: SELECT key, value FROM src_index_test_rc WHERE key=100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_index_test_rc
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT key, value FROM src_index_test_rc WHERE key=100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_index_test_rc
-#### A masked pattern was here ####
-100    val_100
-100    val_100
-PREHOOK: query: SELECT key, value FROM src_index_test_rc WHERE key=100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_index_test_rc
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT key, value FROM src_index_test_rc WHERE key=100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_index_test_rc
-#### A masked pattern was here ####
-100    val_100
-100    val_100
-PREHOOK: query: DROP INDEX src_index on src_index_test_rc
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src_index_test_rc
-POSTHOOK: query: DROP INDEX src_index on src_index_test_rc
-POSTHOOK: type: DROPINDEX
-POSTHOOK: Input: default@src_index_test_rc
-PREHOOK: query: DROP TABLE src_index_test_rc
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@src_index_test_rc
-PREHOOK: Output: default@src_index_test_rc
-POSTHOOK: query: DROP TABLE src_index_test_rc
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@src_index_test_rc
-POSTHOOK: Output: default@src_index_test_rc

http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_compact_binary_search.q.out
----------------------------------------------------------------------
diff --git 
a/ql/src/test/results/clientpositive/index_compact_binary_search.q.out 
b/ql/src/test/results/clientpositive/index_compact_binary_search.q.out
deleted file mode 100644
index dbbd9ed..0000000
--- a/ql/src/test/results/clientpositive/index_compact_binary_search.q.out
+++ /dev/null
@@ -1,473 +0,0 @@
-PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-POSTHOOK: type: CREATEINDEX
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@default__src_src_index__
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: ALTERINDEX_REBUILD
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@default__src_src_index__
-POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE 
[(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION 
[(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), 
]
-POSTHOOK: Lineage: default__src_src_index__.key SIMPLE 
[(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: SELECT * FROM src WHERE key = '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key < '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key <= '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key > '8'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-86     val_86
-98     val_98
-82     val_82
-92     val_92
-83     val_83
-84     val_84
-96     val_96
-95     val_95
-98     val_98
-85     val_85
-87     val_87
-90     val_90
-95     val_95
-80     val_80
-90     val_90
-83     val_83
-9      val_9
-97     val_97
-84     val_84
-90     val_90
-97     val_97
-PREHOOK: query: SELECT * FROM src WHERE key >= '9'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-98     val_98
-92     val_92
-96     val_96
-95     val_95
-98     val_98
-90     val_90
-95     val_95
-90     val_90
-9      val_9
-97     val_97
-90     val_90
-97     val_97
-PREHOOK: query: DROP INDEX src_index ON src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-PREHOOK: query: SELECT * FROM src WHERE key = '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key < '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key <= '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key > '8'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-86     val_86
-98     val_98
-82     val_82
-92     val_92
-83     val_83
-84     val_84
-96     val_96
-95     val_95
-98     val_98
-85     val_85
-87     val_87
-90     val_90
-95     val_95
-80     val_80
-90     val_90
-83     val_83
-9      val_9
-97     val_97
-84     val_84
-90     val_90
-97     val_97
-PREHOOK: query: SELECT * FROM src WHERE key >= '9'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-98     val_98
-92     val_92
-96     val_96
-95     val_95
-98     val_98
-90     val_90
-95     val_95
-90     val_90
-9      val_9
-97     val_97
-90     val_90
-97     val_97
-PREHOOK: query: DROP INDEX src_index ON src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-PREHOOK: query: SELECT * FROM src WHERE key = '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key < '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key <= '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key > '8'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-86     val_86
-98     val_98
-82     val_82
-92     val_92
-83     val_83
-84     val_84
-96     val_96
-95     val_95
-98     val_98
-85     val_85
-87     val_87
-90     val_90
-95     val_95
-80     val_80
-90     val_90
-83     val_83
-9      val_9
-97     val_97
-84     val_84
-90     val_90
-97     val_97
-PREHOOK: query: SELECT * FROM src WHERE key >= '9'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-98     val_98
-92     val_92
-96     val_96
-95     val_95
-98     val_98
-90     val_90
-95     val_95
-90     val_90
-9      val_9
-97     val_97
-90     val_90
-97     val_97
-PREHOOK: query: DROP INDEX src_index ON src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-PREHOOK: query: SELECT * FROM src WHERE key = '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key < '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key <= '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key > '8'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-86     val_86
-98     val_98
-82     val_82
-92     val_92
-83     val_83
-84     val_84
-96     val_96
-95     val_95
-98     val_98
-85     val_85
-87     val_87
-90     val_90
-95     val_95
-80     val_80
-90     val_90
-83     val_83
-9      val_9
-97     val_97
-84     val_84
-90     val_90
-97     val_97
-PREHOOK: query: SELECT * FROM src WHERE key >= '9'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-98     val_98
-92     val_92
-96     val_96
-95     val_95
-98     val_98
-90     val_90
-95     val_95
-90     val_90
-9      val_9
-97     val_97
-90     val_90
-97     val_97
-PREHOOK: query: DROP INDEX src_index ON src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-PREHOOK: query: SELECT * FROM src WHERE key = '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key < '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key <= '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key > '8'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-86     val_86
-98     val_98
-82     val_82
-92     val_92
-83     val_83
-84     val_84
-96     val_96
-95     val_95
-98     val_98
-85     val_85
-87     val_87
-90     val_90
-95     val_95
-80     val_80
-90     val_90
-83     val_83
-9      val_9
-97     val_97
-84     val_84
-90     val_90
-97     val_97
-PREHOOK: query: SELECT * FROM src WHERE key >= '9'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-98     val_98
-92     val_92
-96     val_96
-95     val_95
-98     val_98
-90     val_90
-95     val_95
-90     val_90
-9      val_9
-97     val_97
-90     val_90
-97     val_97
-PREHOOK: query: DROP INDEX src_index ON src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-PREHOOK: query: SELECT * FROM src WHERE key = '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key < '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key <= '0'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-0      val_0
-0      val_0
-0      val_0
-PREHOOK: query: SELECT * FROM src WHERE key > '8'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-86     val_86
-98     val_98
-82     val_82
-92     val_92
-83     val_83
-84     val_84
-96     val_96
-95     val_95
-98     val_98
-85     val_85
-87     val_87
-90     val_90
-95     val_95
-80     val_80
-90     val_90
-83     val_83
-9      val_9
-97     val_97
-84     val_84
-90     val_90
-97     val_97
-PREHOOK: query: SELECT * FROM src WHERE key >= '9'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-98     val_98
-92     val_92
-96     val_96
-95     val_95
-98     val_98
-90     val_90
-95     val_95
-90     val_90
-9      val_9
-97     val_97
-90     val_90
-97     val_97
-PREHOOK: query: DROP INDEX src_index ON src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src

http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_compression.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_compression.q.out 
b/ql/src/test/results/clientpositive/index_compression.q.out
deleted file mode 100644
index a2c0d27..0000000
--- a/ql/src/test/results/clientpositive/index_compression.q.out
+++ /dev/null
@@ -1,158 +0,0 @@
-PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@src
-POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH 
DEFERRED REBUILD
-POSTHOOK: type: CREATEINDEX
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@default__src_src_index__
-PREHOOK: query: ALTER INDEX src_index ON src REBUILD
-PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@src
-PREHOOK: Output: default@default__src_src_index__
-POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
-POSTHOOK: type: ALTERINDEX_REBUILD
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@default__src_src_index__
-POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE 
[(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION 
[(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), 
]
-POSTHOOK: Lineage: default__src_src_index__.key SIMPLE 
[(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key > 80 AND key < 100
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key > 80 AND key < 
100
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-3 is a root stage
-  Stage-8 depends on stages: Stage-3 , consists of Stage-5, Stage-4, Stage-6
-  Stage-5
-  Stage-2 depends on stages: Stage-5, Stage-4, Stage-7
-  Stage-1 depends on stages: Stage-2
-  Stage-4
-  Stage-6
-  Stage-7 depends on stages: Stage-6
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-3
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default__src_src_index__
-            filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 
100.0)) (type: boolean)
-            Filter Operator
-              predicate: ((UDFToDouble(key) < 100.0) and (UDFToDouble(key) > 
80.0)) (type: boolean)
-              Select Operator
-                expressions: _bucketname (type: string), _offsets (type: 
array<bigint>)
-                outputColumnNames: _col0, _col1
-                File Output Operator
-                  compressed: false
-                  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-8
-    Conditional Operator
-
-  Stage: Stage-5
-    Move Operator
-      files:
-          hdfs directory: true
-#### A masked pattern was here ####
-
-  Stage: Stage-2
-    Move Operator
-      files:
-          hdfs directory: true
-#### A masked pattern was here ####
-
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: src
-            filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 
100.0)) (type: boolean)
-            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
-            Filter Operator
-              predicate: ((UDFToDouble(key) < 100.0) and (UDFToDouble(key) > 
80.0)) (type: boolean)
-              Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE 
Column stats: NONE
-              Select Operator
-                expressions: key (type: string), value (type: string)
-                outputColumnNames: _col0, _col1
-                Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE 
Column stats: NONE
-                File Output Operator
-                  compressed: true
-                  Statistics: Num rows: 55 Data size: 584 Basic stats: 
COMPLETE Column stats: NONE
-                  table:
-                      input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                      output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-4
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            File Output Operator
-              compressed: false
-              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-6
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            File Output Operator
-              compressed: false
-              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-7
-    Move Operator
-      files:
-          hdfs directory: true
-#### A masked pattern was here ####
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@default__src_src_index__
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@default__src_src_index__
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-82     val_82
-83     val_83
-83     val_83
-84     val_84
-84     val_84
-85     val_85
-86     val_86
-87     val_87
-90     val_90
-90     val_90
-90     val_90
-92     val_92
-95     val_95
-95     val_95
-96     val_96
-97     val_97
-97     val_97
-98     val_98
-98     val_98
-PREHOOK: query: DROP INDEX src_index on src
-PREHOOK: type: DROPINDEX
-PREHOOK: Input: default@src
-POSTHOOK: query: DROP INDEX src_index on src
-POSTHOOK: type: DROPINDEX
-POSTHOOK: Input: default@src