hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j..@apache.org
Subject svn commit: r1153926 [2/14] - in /hive/trunk: cli/src/java/org/apache/hadoop/hive/cli/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
Date Thu, 04 Aug 2011 16:57:21 GMT
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), ]



Mime
View raw message