Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out Thu Aug 4 16:57:17 2011 @@ -82,7 +82,7 @@ STAGE PLANS: Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/tmp/heyongqiang/hive_2011-08-02_16-20-46_897_8857433213666459560/-mr-10002 + file:/tmp/salbiz/hive_2011-08-03_11-42-30_405_5068275561507065717/-mr-10002 Reduce Output Operator key expressions: expr: _col0 @@ -111,11 +111,11 @@ STAGE PLANS: PREHOOK: query: SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 ORDER BY a.key PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-20-47_055_5824956672610237767/-mr-10000 +PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-42-30_508_513747522661258530/-mr-10000 POSTHOOK: query: SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 ORDER BY a.key POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-20-47_055_5824956672610237767/-mr-10000 +POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-42-30_508_513747522661258530/-mr-10000 82 82 83 83 83 83 @@ -133,11 +133,11 @@ PREHOOK: type: CREATEINDEX POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX PREHOOK: query: ALTER INDEX src_index ON src REBUILD -PREHOOK: type: QUERY +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: QUERY +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:), ] @@ -250,7 +250,7 @@ STAGE PLANS: Move Operator files: hdfs directory: true - destination: file:/tmp/heyongqiang/hive_2011-08-02_16-20-57_341_4740837259291256044/-mr-10003 + destination: file:/tmp/salbiz/hive_2011-08-03_11-42-40_557_1279576820158523709/-mr-10003 Stage: Stage-1 Map Reduce @@ -325,7 +325,7 @@ STAGE PLANS: Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: - file:/tmp/heyongqiang/hive_2011-08-02_16-20-57_341_4740837259291256044/-mr-10002 + file:/tmp/salbiz/hive_2011-08-03_11-42-40_557_1279576820158523709/-mr-10002 Reduce Output Operator key expressions: expr: _col0 @@ -431,7 +431,7 @@ STAGE PLANS: Move Operator files: hdfs directory: true - destination: file:/tmp/heyongqiang/hive_2011-08-02_16-20-57_341_4740837259291256044/-mr-10004 + destination: file:/tmp/salbiz/hive_2011-08-03_11-42-40_557_1279576820158523709/-mr-10004 Stage: Stage-0 Fetch Operator @@ -442,12 +442,12 @@ PREHOOK: query: SELECT a.key, b.key FROM PREHOOK: type: QUERY PREHOOK: Input: default@default__src_src_index__ PREHOOK: Input: default@src -PREHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-20-57_700_5860392294353197259/-mr-10000 +PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-42-40_942_8561053341711300653/-mr-10000 POSTHOOK: query: SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 ORDER BY a.key POSTHOOK: type: QUERY POSTHOOK: Input: default@default__src_src_index__ POSTHOOK: Input: default@src -POSTHOOK: Output: file:/tmp/heyongqiang/hive_2011-08-02_16-20-57_700_5860392294353197259/-mr-10000 +POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-03_11-42-40_942_8561053341711300653/-mr-10000 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:), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out?rev=1153926&r1=1153925&r2=1153926&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out Thu Aug 4 16:57:17 2011 @@ -7,11 +7,11 @@ POSTHOOK: query: -- test cases where the CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX PREHOOK: query: ALTER INDEX src_index ON src REBUILD -PREHOOK: type: QUERY +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: QUERY +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:), ] @@ -82,11 +82,11 @@ STAGE PLANS: PREHOOK: query: SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-25_374_4374810764646255651/-mr-10000 +PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-25_598_5647295864312347044/-mr-10000 POSTHOOK: query: SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-25_374_4374810764646255651/-mr-10000 +POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-25_598_5647295864312347044/-mr-10000 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), ] @@ -174,11 +174,11 @@ STAGE PLANS: PREHOOK: query: SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-33_059_3495425540612459913/-mr-10000 +PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-28_723_4839341622204701979/-mr-10000 POSTHOOK: query: SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-33_059_3495425540612459913/-mr-10000 +POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-28_723_4839341622204701979/-mr-10000 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), ] @@ -266,11 +266,11 @@ STAGE PLANS: PREHOOK: query: SELECT * FROM src WHERE key < 10 OR key > 480 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-41_214_8813442842757881648/-mr-10000 +PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-31_904_45216609237645171/-mr-10000 POSTHOOK: query: SELECT * FROM src WHERE key < 10 OR key > 480 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-41_214_8813442842757881648/-mr-10000 +POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-31_904_45216609237645171/-mr-10000 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), ] @@ -323,11 +323,11 @@ POSTHOOK: Lineage: default__src_src_inde 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: ALTER INDEX src_val_index ON src REBUILD -PREHOOK: type: QUERY +PREHOOK: type: ALTERINDEX_REBUILD PREHOOK: Input: default@src PREHOOK: Output: default@default__src_src_val_index__ POSTHOOK: query: ALTER INDEX src_val_index ON src REBUILD -POSTHOOK: type: QUERY +POSTHOOK: type: ALTERINDEX_REBUILD POSTHOOK: Input: default@src POSTHOOK: Output: default@default__src_src_val_index__ POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] @@ -402,11 +402,11 @@ STAGE PLANS: PREHOOK: query: SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-56_659_721280297272334789/-mr-10000 +PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-39_438_6054980592070594322/-mr-10000 POSTHOOK: query: SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-09-56_659_721280297272334789/-mr-10000 +POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-39_438_6054980592070594322/-mr-10000 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), ] @@ -455,11 +455,11 @@ POSTHOOK: Lineage: default__src_src_val_ POSTHOOK: Lineage: default__src_src_val_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] POSTHOOK: Lineage: default__src_src_val_index__.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: ALTER INDEX src_part_index ON srcpart PARTITION (ds='2008-04-08', hr=11) REBUILD -PREHOOK: type: QUERY +PREHOOK: type: ALTERINDEX_REBUILD PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-08/hr=11 POSTHOOK: query: ALTER INDEX src_part_index ON srcpart PARTITION (ds='2008-04-08', hr=11) REBUILD -POSTHOOK: type: QUERY +POSTHOOK: type: ALTERINDEX_REBUILD POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Output: default@default__srcpart_src_part_index__@ds=2008-04-08/hr=11 POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] @@ -548,11 +548,11 @@ STAGE PLANS: PREHOOK: query: SELECT * FROM srcpart WHERE ds='2008-04-09' AND hr=12 AND key < 10 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-10-13_765_2757201616794436574/-mr-10000 +PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-47_244_8856542049125864022/-mr-10000 POSTHOOK: query: SELECT * FROM srcpart WHERE ds='2008-04-09' AND hr=12 AND key < 10 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-06-15_16-10-13_765_2757201616794436574/-mr-10000 +POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-38-47_244_8856542049125864022/-mr-10000 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), ]
