http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_bitmap.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_bitmap.q.out b/ql/src/test/results/clientpositive/index_bitmap.q.out deleted file mode 100644 index 5017027..0000000 --- a/ql/src/test/results/clientpositive/index_bitmap.q.out +++ /dev/null @@ -1,291 +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 '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-08,hr=11)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -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)._offset SIMPLE [(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)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -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)._offset SIMPLE [(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)._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=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)._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=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)._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-08,hr=11)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -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)._offset SIMPLE [(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)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -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)._offset SIMPLE [(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)._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=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)._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=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)._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
http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_bitmap1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_bitmap1.q.out b/ql/src/test/results/clientpositive/index_bitmap1.q.out deleted file mode 100644 index 8f3af66..0000000 --- a/ql/src/test/results/clientpositive/index_bitmap1.q.out +++ /dev/null @@ -1,75 +0,0 @@ -PREHOOK: query: EXPLAIN -CREATE INDEX src_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -POSTHOOK: query: EXPLAIN -CREATE INDEX src_index ON TABLE src(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 src_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@src -POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'BITMAP' 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__._bitmaps EXPRESSION [(src)src.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__src_src_index__._offset SIMPLE [(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 #### -COLLECT_SET(`_offset`) as `_offsets` FROM default__src_src_index__ WHERE NOT -EWAH_BITMAP_EMPTY(`_bitmaps`) AND key=100 GROUP BY `_bucketname` -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src_index__ -#### A masked pattern was here #### -COLLECT_SET(`_offset`) as `_offsets` FROM default__src_src_index__ WHERE NOT -EWAH_BITMAP_EMPTY(`_bitmaps`) AND key=100 GROUP BY `_bucketname` -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_bitmap2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_bitmap2.q.out b/ql/src/test/results/clientpositive/index_bitmap2.q.out deleted file mode 100644 index 716e3c8..0000000 --- a/ql/src/test/results/clientpositive/index_bitmap2.q.out +++ /dev/null @@ -1,138 +0,0 @@ -PREHOOK: query: EXPLAIN -CREATE INDEX src1_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -POSTHOOK: query: EXPLAIN -CREATE INDEX src1_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - -PREHOOK: query: EXPLAIN -CREATE INDEX src2_index ON TABLE src(value) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -POSTHOOK: query: EXPLAIN -CREATE INDEX src2_index ON TABLE src(value) 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 src1_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@src -POSTHOOK: query: CREATE INDEX src1_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src1_index__ -PREHOOK: query: CREATE INDEX src2_index ON TABLE src(value) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@src -POSTHOOK: query: CREATE INDEX src2_index ON TABLE src(value) as 'BITMAP' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src2_index__ -PREHOOK: query: ALTER INDEX src1_index ON src REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@src -PREHOOK: Output: default@default__src_src1_index__ -POSTHOOK: query: ALTER INDEX src1_index ON src REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src1_index__ -POSTHOOK: Lineage: default__src_src1_index__._bitmaps EXPRESSION [(src)src.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src1_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__src_src1_index__._offset SIMPLE [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src1_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -PREHOOK: query: ALTER INDEX src2_index ON src REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@src -PREHOOK: Output: default@default__src_src2_index__ -POSTHOOK: query: ALTER INDEX src2_index ON src REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src2_index__ -POSTHOOK: Lineage: default__src_src2_index__._bitmaps EXPRESSION [(src)src.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src2_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__src_src2_index__._offset SIMPLE [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src2_index__.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT * FROM default__src_src1_index__ -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src1_index__ -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM default__src_src1_index__ -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src1_index__ -#### A masked pattern was here #### -PREHOOK: query: SELECT * FROM default__src_src2_index__ -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src2_index__ -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM default__src_src2_index__ -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src2_index__ -#### A masked pattern was here #### -SELECT t.bucketname as `_bucketname`, COLLECT_SET(t.offset) AS `_offsets` FROM - (SELECT `_bucketname` AS bucketname, `_offset` AS offset - FROM default__src_src1_index__ - WHERE key = 0 AND NOT EWAH_BITMAP_EMPTY(`_bitmaps`) UNION ALL - SELECT `_bucketname` AS bucketname, `_offset` AS offset - FROM default__src_src2_index__ - WHERE value = "val2" AND NOT EWAH_BITMAP_EMPTY(`_bitmaps`)) t -GROUP BY t.bucketname -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src1_index__ -PREHOOK: Input: default@default__src_src2_index__ -#### A masked pattern was here #### -SELECT t.bucketname as `_bucketname`, COLLECT_SET(t.offset) AS `_offsets` FROM - (SELECT `_bucketname` AS bucketname, `_offset` AS offset - FROM default__src_src1_index__ - WHERE key = 0 AND NOT EWAH_BITMAP_EMPTY(`_bitmaps`) UNION ALL - SELECT `_bucketname` AS bucketname, `_offset` AS offset - FROM default__src_src2_index__ - WHERE value = "val2" AND NOT EWAH_BITMAP_EMPTY(`_bitmaps`)) t -GROUP BY t.bucketname -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src1_index__ -POSTHOOK: Input: default@default__src_src2_index__ -#### A masked pattern was here #### -PREHOOK: query: SELECT key, value FROM src WHERE key=0 OR value = "val_2" -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, value FROM src WHERE key=0 OR value = "val_2" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -0 val_0 -0 val_0 -0 val_0 -2 val_2 -PREHOOK: query: SELECT key, value FROM src WHERE key=0 OR value = "val_2" -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, value FROM src WHERE key=0 OR value = "val_2" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -0 val_0 -0 val_0 -0 val_0 -2 val_2 -PREHOOK: query: DROP INDEX src1_index ON src -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@src -POSTHOOK: query: DROP INDEX src1_index ON src -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@src -PREHOOK: query: DROP INDEX src2_index ON src -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@src -POSTHOOK: query: DROP INDEX src2_index ON src -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@src