You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2010/07/23 01:57:42 UTC
svn commit: r966909 [15/27] - in /hadoop/hive/trunk: ./ contrib/
data/warehouse/src/ hbase-handler/ hwi/ jdbc/ odbc/ ql/
ql/src/test/org/apache/hadoop/hive/ql/ ql/src/test/queries/clientnegative/
ql/src/test/queries/clientpositive/ ql/src/test/results/...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out Thu Jul 22 23:57:29 2010
@@ -1,15 +1,3 @@
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table dest2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest2
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table INPUT
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table INPUT
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE dest1(key INT, val1 INT, val2 INT)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(key INT, val1 INT, val2 INT)
@@ -107,7 +95,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-33_732_8719088178849924632/10004
+ file:/tmp/jssarma/hive_2010-07-21_11-22-31_118_2529581520401612430/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -173,7 +161,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-33_732_8719088178849924632/10005
+ file:/tmp/jssarma/hive_2010-07-21_11-22-31_118_2529581520401612430/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -260,11 +248,11 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
PREHOOK: query: SELECT * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-49_016_4991831970418138430/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-39_144_1975011296044036004/10000
POSTHOOK: query: SELECT * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-49_016_4991831970418138430/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-39_144_1975011296044036004/10000
POSTHOOK: Lineage: dest1.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: dest1.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: dest1.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
@@ -294,11 +282,11 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
PREHOOK: query: SELECT * from dest2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-49_066_3993931016056082294/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-39_198_7481470784996277044/10000
POSTHOOK: query: SELECT * from dest2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-49_066_3993931016056082294/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-39_198_7481470784996277044/10000
POSTHOOK: Lineage: dest1.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: dest1.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: dest1.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
@@ -325,36 +313,3 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
401 401 401
409 409 409
484 484 484
-PREHOOK: query: drop table INPUT
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table INPUT
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@input
-POSTHOOK: Lineage: dest1.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: dest1.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest1.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest2.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: dest2.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest2.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: dest1.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest1.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest2.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: dest2.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest2.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-PREHOOK: query: drop table dest2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest2
-POSTHOOK: Lineage: dest1.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: dest1.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest1.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest2.key SIMPLE [(input)input.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: dest2.val1 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
-POSTHOOK: Lineage: dest2.val2 EXPRESSION [(input)input.FieldSchema(name:value, type:string, comment:null), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby11.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table dest2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest2
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE dest1(key STRING, val1 INT, val2 INT) partitioned by (ds string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(key STRING, val1 INT, val2 INT) partitioned by (ds string)
@@ -99,7 +91,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-08-54_528_3582940419290173877/10004
+ file:/tmp/jssarma/hive_2010-07-21_11-22-39_568_3957054152816650703/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -167,7 +159,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-08-54_528_3582940419290173877/10005
+ file:/tmp/jssarma/hive_2010-07-21_11-22-39_568_3957054152816650703/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -260,11 +252,11 @@ POSTHOOK: Lineage: dest2 PARTITION(ds=11
PREHOOK: query: SELECT * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1@ds=111
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-09-07_685_5264951064800815110/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-47_442_688004092056696440/10000
POSTHOOK: query: SELECT * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1@ds=111
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-09-07_685_5264951064800815110/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-47_442_688004092056696440/10000
POSTHOOK: Lineage: dest1 PARTITION(ds=111).key SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1 PARTITION(ds=111).val1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1 PARTITION(ds=111).val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -583,11 +575,11 @@ val_98 2 1 111
PREHOOK: query: SELECT * from dest2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2@ds=111
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-09-07_785_8160854463566208453/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-47_517_4221724803022357819/10000
POSTHOOK: query: SELECT * from dest2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2@ds=111
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-09-07_785_8160854463566208453/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-47_517_4221724803022357819/10000
POSTHOOK: Lineage: dest1 PARTITION(ds=111).key SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1 PARTITION(ds=111).val1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1 PARTITION(ds=111).val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -903,25 +895,3 @@ POSTHOOK: Lineage: dest2 PARTITION(ds=11
96 1 1 111
97 2 1 111
98 2 1 111
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1 PARTITION(ds=111).key SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1 PARTITION(ds=111).val1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1 PARTITION(ds=111).val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2 PARTITION(ds=111).key EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2 PARTITION(ds=111).val1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2 PARTITION(ds=111).val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: drop table dest2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest2
-POSTHOOK: Lineage: dest1 PARTITION(ds=111).key SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1 PARTITION(ds=111).val1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1 PARTITION(ds=111).val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2 PARTITION(ds=111).key EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2 PARTITION(ds=111).val1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2 PARTITION(ds=111).val2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out Thu Jul 22 23:57:29 2010
@@ -83,7 +83,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-08-30_974_5290708260154041100/10002
+ file:/tmp/jssarma/hive_2010-07-21_11-23-30_013_9206830132841854931/10002
Reduce Output Operator
sort order:
tag: -1
@@ -223,11 +223,11 @@ POSTHOOK: Lineage: dest1.c9 EXPRESSION [
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-08-40_661_8875038042592803685/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-35_334_4005630322306317272/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-08-40_661_8875038042592803685/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-35_334_4005630322306317272/10000
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -238,17 +238,3 @@ POSTHOOK: Lineage: dest1.c7 EXPRESSION [
POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
130091.0 260.182 256.10355987055016 98.0 0.0 142.92680950752379 143.06995106518903 20428.07287599999 20469.010897795582
-PREHOOK: query: DROP TABLE dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out Thu Jul 22 23:57:29 2010
@@ -207,11 +207,11 @@ POSTHOOK: Lineage: dest1.c9 EXPRESSION [
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-08-49_083_7812532907486997795/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-38_629_5098069129422470787/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-08-49_083_7812532907486997795/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-38_629_5098069129422470787/10000
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -222,17 +222,3 @@ POSTHOOK: Lineage: dest1.c7 EXPRESSION [
POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
130091.0 260.182 256.10355987055016 98.0 0.0 142.9268095075238 143.06995106518906 20428.072876 20469.01089779559
-PREHOOK: query: DROP TABLE dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out Thu Jul 22 23:57:29 2010
@@ -119,7 +119,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-11-19_485_6759193827936294497/10002
+ file:/tmp/jssarma/hive_2010-07-21_11-23-38_951_8559728103103624706/10002
Reduce Output Operator
sort order:
tag: -1
@@ -259,11 +259,11 @@ POSTHOOK: Lineage: dest1.c9 EXPRESSION [
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-11-30_179_7629474680624414038/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-44_381_5135448855404252228/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-11-30_179_7629474680624414038/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-44_381_5135448855404252228/10000
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -274,17 +274,3 @@ POSTHOOK: Lineage: dest1.c7 EXPRESSION [
POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
130091.0 260.182 256.10355987055016 98.0 0.0 142.9268095075238 143.06995106518906 20428.072876 20469.01089779559
-PREHOOK: query: DROP TABLE dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out Thu Jul 22 23:57:29 2010
@@ -171,11 +171,11 @@ POSTHOOK: Lineage: dest1.c9 EXPRESSION [
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-09-38_039_6030452822453768062/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-47_426_1452039016187035932/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-09-38_039_6030452822453768062/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-23-47_426_1452039016187035932/10000
POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -186,17 +186,3 @@ POSTHOOK: Lineage: dest1.c7 EXPRESSION [
POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
130091.0 260.182 256.10355987055016 98.0 0.0 142.92680950752379 143.06995106518903 20428.07287599999 20469.010897795582
-PREHOOK: query: DROP TABLE dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.c1 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c3 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c5 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c6 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c7 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c8 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.c9 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table DEST1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table DEST1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table DEST2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table DEST2
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
@@ -95,7 +87,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-09-55_073_4811751815642872862/10004
+ file:/tmp/jssarma/hive_2010-07-21_11-25-41_473_5912399545173757449/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -154,7 +146,7 @@ STAGE PLANS:
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-09-55_073_4811751815642872862/10005
+ file:/tmp/jssarma/hive_2010-07-21_11-25-41_473_5912399545173757449/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -243,11 +235,11 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-10-08_620_486578954348947231/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-25-49_248_6786053973649103964/10000
POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-10-08_620_486578954348947231/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-25-49_248_6786053973649103964/10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -565,11 +557,11 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
PREHOOK: query: SELECT DEST2.* FROM DEST2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-10-08_680_6077462527451103689/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-25-49_307_6015579282653689221/10000
POSTHOOK: query: SELECT DEST2.* FROM DEST2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-10-08_680_6077462527451103689/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-25-49_307_6015579282653689221/10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -884,23 +876,3 @@ POSTHOOK: Lineage: dest2.val2 EXPRESSION
96 val_96 1
97 val_97 1
98 val_98 1
-PREHOOK: query: drop table DEST1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table DEST1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.val1 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: drop table DEST2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table DEST2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest2
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.val1 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out Thu Jul 22 23:57:29 2010
@@ -59,15 +59,10 @@ FROM implicit_test1
WHERE implicit_test1.a <> 0
PREHOOK: type: QUERY
PREHOOK: Input: default@implicit_test1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/439003851/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-26-24_976_2073073634228618169/10000
POSTHOOK: query: SELECT implicit_test1.*
FROM implicit_test1
WHERE implicit_test1.a <> 0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@implicit_test1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/439003851/10000
-PREHOOK: query: DROP TABLE implicit_test1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE implicit_test1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@implicit_test1
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-26-24_976_2073073634228618169/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/init_file.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/init_file.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/init_file.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/init_file.q.out Thu Jul 22 23:57:29 2010
@@ -9,16 +9,11 @@ PREHOOK: query: -- tbl_created_by_init i
select * from tbl_created_by_init
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl_created_by_init
-PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2010-06-18_15-26-08_648_7822849778594453961/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-26-27_744_1100043554292552055/10000
POSTHOOK: query: -- tbl_created_by_init is supposed to have been created for us
-- automatically by test_init_file.sql
select * from tbl_created_by_init
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl_created_by_init
-POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2010-06-18_15-26-08_648_7822849778594453961/10000
-PREHOOK: query: drop table tbl_created_by_init
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tbl_created_by_init
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tbl_created_by_init
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-26-27_744_1100043554292552055/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out Thu Jul 22 23:57:29 2010
@@ -33,8 +33,3 @@ POSTHOOK: query: DESCRIBE TEST1
POSTHOOK: type: DESCTABLE
a int
b double
-PREHOOK: query: DROP TABLE TEST1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@test1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out Thu Jul 22 23:57:29 2010
@@ -35,8 +35,3 @@ key int
value string
ds string
hr string
-PREHOOK: query: DROP TABLE TEST10
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST10
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@test10
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out Thu Jul 22 23:57:29 2010
@@ -35,8 +35,3 @@ POSTHOOK: query: DESCRIBE TEST15
POSTHOOK: type: DESCTABLE
key int
value string
-PREHOOK: query: DROP TABLE TEST15
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST15
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@test15
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out Thu Jul 22 23:57:29 2010
@@ -17,11 +17,11 @@ POSTHOOK: Output: default@input16
PREHOOK: query: SELECT INPUT16.VALUE, INPUT16.KEY FROM INPUT16
PREHOOK: type: QUERY
PREHOOK: Input: default@input16
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1455551235/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_14-10-01_833_5335657696200375421/10000
POSTHOOK: query: SELECT INPUT16.VALUE, INPUT16.KEY FROM INPUT16
POSTHOOK: type: QUERY
POSTHOOK: Input: default@input16
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1455551235/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_14-10-01_833_5335657696200375421/10000
val_238 238
val_86 86
val_311 311
@@ -522,8 +522,3 @@ val_403 403
val_400 400
val_200 200
val_97 97
-PREHOOK: query: DROP TABLE INPUT16
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE INPUT16
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@input16
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out Thu Jul 22 23:57:29 2010
@@ -19,11 +19,11 @@ POSTHOOK: Output: default@input16_cc
PREHOOK: query: SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC
PREHOOK: type: QUERY
PREHOOK: Input: default@input16_cc
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1052706043/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_14-18-05_263_4460949840611638279/10000
POSTHOOK: query: SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@input16_cc
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1052706043/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_14-18-05_263_4460949840611638279/10000
val_238 238
val_86 86
val_311 311
@@ -524,8 +524,3 @@ val_403 403
val_400 400
val_200 200
val_97 97
-PREHOOK: query: DROP TABLE INPUT16_CC
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE INPUT16_CC
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@input16_cc
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table apachelog
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table apachelog
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table apachelog(ipaddress STRING,identd STRING,user STRING,finishtime STRING,requestline string,returncode INT,size INT) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES ( 'serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol', 'quote.delim'= '("|\\[|\\])', 'field.delim'=' ', 'serialization.null.format'='-' ) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table apachelog(ipaddress STRING,identd STRING,user STRING,finishtime STRING,requestline string,returncode INT,size INT) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES ( 'serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol', 'quote.delim'= '("|\\[|\\])', 'field.delim'=' ', 'serialization.null.format'='-' ) STORED AS TEXTFILE
@@ -15,14 +11,9 @@ POSTHOOK: Output: default@apachelog
PREHOOK: query: SELECT a.* FROM apachelog a
PREHOOK: type: QUERY
PREHOOK: Input: default@apachelog
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/.ptest_3/build/ql/tmp/1231763776/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-26-57_493_8424717254986801325/10000
POSTHOOK: query: SELECT a.* FROM apachelog a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@apachelog
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/.ptest_3/build/ql/tmp/1231763776/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-26-57_493_8424717254986801325/10000
127.0.0.1 NULL frank 10/Oct/2000:13:55:36 -0700 GET /apache_pb.gif HTTP/1.0 200 2326
-PREHOOK: query: drop table apachelog
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table apachelog
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@apachelog
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out Thu Jul 22 23:57:29 2010
@@ -104,7 +104,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-14-04_330_2459663668263401934/10004
+ file:/tmp/jssarma/hive_2010-07-21_11-26-57_854_4999061439601735218/10004
Reduce Output Operator
sort order:
tag: -1
@@ -164,11 +164,11 @@ POSTHOOK: Lineage: dest2.value SIMPLE [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-14-12_951_2870105461951020454/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-03_051_2929820140133939709/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-14-12_951_2870105461951020454/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-03_051_2929820140133939709/10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -186,11 +186,11 @@ POSTHOOK: Lineage: dest2.value SIMPLE [(
PREHOOK: query: SELECT dest2.* FROM dest2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-14-13_000_4947993081086639811/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-03_103_6672174195466398495/10000
POSTHOOK: query: SELECT dest2.* FROM dest2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-14-13_000_4947993081086639811/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-03_103_6672174195466398495/10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -200,21 +200,3 @@ POSTHOOK: Lineage: dest2.value SIMPLE [(
98 val_98
66 val_66
37 val_37
-PREHOOK: query: DROP TABLE dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: DROP TABLE dest2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest2
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: DROP TABLE TEST2a
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST2a
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE TEST2b
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST2b
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE TEST2a(A INT, B DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE TEST2a(A INT, B DOUBLE) STORED AS TEXTFILE
@@ -95,11 +87,3 @@ STAGE PLANS:
limit: -1
-PREHOOK: query: DROP TABLE TEST2a
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST2a
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE TEST2b
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST2b
-POSTHOOK: type: DROPTABLE
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: DROP TABLE src_null
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE src_null
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE src_null(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE src_null(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
@@ -76,11 +72,11 @@ STAGE PLANS:
PREHOOK: query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
PREHOOK: type: QUERY
PREHOOK: Input: default@src_null
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/944884170/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-09_926_7521845290777085588/10000
POSTHOOK: query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_null
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/944884170/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-09_926_7521845290777085588/10000
1.0 1 same 0
1.0 1 same 1
1.0 1 same 2
@@ -91,8 +87,3 @@ NULL NULL same 6
1.0 NULL same 7
1.0 1 same 8
1.0 1 same 9
-PREHOOK: query: DROP TABLE src_null
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE src_null
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@src_null
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out Thu Jul 22 23:57:29 2010
@@ -74,14 +74,14 @@ FROM (SELECT INPUT4.*, INPUT4.KEY as KEY
ORDER BY KEY2 LIMIT 10
PREHOOK: type: QUERY
PREHOOK: Input: default@input4
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/569155063/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-12_928_5119963589127065058/10000
POSTHOOK: query: SELECT a.KEY2
FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
FROM INPUT4) a
ORDER BY KEY2 LIMIT 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@input4
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/569155063/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-12_928_5119963589127065058/10000
0
0
0
@@ -92,8 +92,3 @@ POSTHOOK: Output: file:/data/users/njain
103
104
104
-PREHOOK: query: DROP TABLE INPUT4
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE INPUT4
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@input4
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table tst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tst(a int, b int) partitioned by (d string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table tst(a int, b int) partitioned by (d string)
@@ -80,14 +76,9 @@ STAGE PLANS:
PREHOOK: query: select count(1) from tst x where x.d='2009-01-01'
PREHOOK: type: QUERY
PREHOOK: Input: default@tst@d=2009-01-01
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1844534662/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-18_997_2954899292364767462/10000
POSTHOOK: query: select count(1) from tst x where x.d='2009-01-01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tst@d=2009-01-01
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1844534662/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-18_997_2954899292364767462/10000
0
-PREHOOK: query: drop table tst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tst
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table tst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tst(a int, b int) partitioned by (d string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table tst(a int, b int) partitioned by (d string)
@@ -88,7 +84,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1330722084/10002
+ file:/tmp/jssarma/hive_2010-07-21_11-27-21_972_4570921732718376646/10002
Union
Select Operator
expressions:
@@ -105,7 +101,7 @@ STAGE PLANS:
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1330722084/10003
+ file:/tmp/jssarma/hive_2010-07-21_11-27-21_972_4570921732718376646/10003
Union
Select Operator
expressions:
@@ -180,7 +176,7 @@ PREHOOK: query: select * from (
PREHOOK: type: QUERY
PREHOOK: Input: default@tst@d=2009-01-01
PREHOOK: Input: default@tst@d=2009-02-02
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/2012659727/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-22_116_2207462845190114193/10000
POSTHOOK: query: select * from (
select * from tst x where x.d='2009-01-01' limit 10
union all
@@ -189,9 +185,4 @@ POSTHOOK: query: select * from (
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tst@d=2009-01-01
POSTHOOK: Input: default@tst@d=2009-02-02
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/2012659727/10000
-PREHOOK: query: drop table tst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tst
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-22_116_2207462845190114193/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input28.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input28.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input28.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input28.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table tst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tst(a string, b string) partitioned by (d string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table tst(a string, b string) partitioned by (d string)
@@ -29,17 +25,10 @@ POSTHOOK: Lineage: tst PARTITION(d=2009-
PREHOOK: query: select * from tst where tst.d='2009-01-01'
PREHOOK: type: QUERY
PREHOOK: Input: default@tst@d=2009-01-01
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-11-18_835_8722090511424029889/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-41_262_4407769166268455742/10000
POSTHOOK: query: select * from tst where tst.d='2009-01-01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tst@d=2009-01-01
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-11-18_835_8722090511424029889/10000
-POSTHOOK: Lineage: tst PARTITION(d=2009-01-01).a SIMPLE [(tst)tst.FieldSchema(name:d, type:string, comment:null), ]
-POSTHOOK: Lineage: tst PARTITION(d=2009-01-01).b SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: drop table tst
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tst
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-41_262_4407769166268455742/10000
POSTHOOK: Lineage: tst PARTITION(d=2009-01-01).a SIMPLE [(tst)tst.FieldSchema(name:d, type:string, comment:null), ]
POSTHOOK: Lineage: tst PARTITION(d=2009-01-01).b SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out Thu Jul 22 23:57:29 2010
@@ -1,15 +1,3 @@
-PREHOOK: query: DROP TABLE TEST3a
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST3a
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE TEST3b
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST3b
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE TEST3c
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST3c
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE TEST3a(A INT, B DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE TEST3a(A INT, B DOUBLE) STORED AS TEXTFILE
@@ -165,18 +153,4 @@ POSTHOOK: type: DESCTABLE
r1 int
r2 double
-Detailed Table Information Table(tableName:test3c, dbName:default, owner:njain, createTime:1269906076, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:r1, type:int, comment:null), FieldSchema(name:r2, type:double, comment:null)], location:file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/test3c, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=njain,last_modified_time=1269906077,transient_lastDdlTime=1269906077}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
-PREHOOK: query: DROP TABLE TEST3a
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST3a
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@test3a
-PREHOOK: query: DROP TABLE TEST3b
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST3b
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE TEST3c
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE TEST3c
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@test3c
+Detailed Table Information Table(tableName:test3c, dbName:default, owner:jssarma, createTime:1279736864, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:r1, type:int, comment:null), FieldSchema(name:r2, type:double, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/test3c, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{last_modified_by=jssarma, last_modified_time=1279736865, transient_lastDdlTime=1279736865}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table tst_dest30
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst_dest30
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table dest30
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest30
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table dest30(a int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table dest30(a int)
@@ -106,22 +98,10 @@ POSTHOOK: Lineage: tst_dest30.a EXPRESSI
PREHOOK: query: select * from tst_dest30
PREHOOK: type: QUERY
PREHOOK: Input: default@tst_dest30
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-11-25_544_4956721364351044321/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-48_308_1489139289605344338/10000
POSTHOOK: query: select * from tst_dest30
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tst_dest30
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-11-25_544_4956721364351044321/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-48_308_1489139289605344338/10000
POSTHOOK: Lineage: tst_dest30.a EXPRESSION [(src)src.null, ]
18
-PREHOOK: query: drop table tst_dest30
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst_dest30
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tst_dest30
-POSTHOOK: Lineage: tst_dest30.a EXPRESSION [(src)src.null, ]
-PREHOOK: query: drop table dest30
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest30
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest30
-POSTHOOK: Lineage: tst_dest30.a EXPRESSION [(src)src.null, ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table tst_dest31
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst_dest31
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table dest31
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest31
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tst_dest31(a int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table tst_dest31(a int)
@@ -110,22 +102,10 @@ POSTHOOK: Lineage: tst_dest31.a EXPRESSI
PREHOOK: query: select * from tst_dest31
PREHOOK: type: QUERY
PREHOOK: Input: default@tst_dest31
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-14-47_969_5252355882529594546/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-51_528_6418079216640080758/10000
POSTHOOK: query: select * from tst_dest31
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tst_dest31
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-14-47_969_5252355882529594546/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-51_528_6418079216640080758/10000
POSTHOOK: Lineage: tst_dest31.a EXPRESSION [(srcbucket)srcbucket.null, ]
493
-PREHOOK: query: drop table tst_dest31
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst_dest31
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tst_dest31
-POSTHOOK: Lineage: tst_dest31.a EXPRESSION [(srcbucket)srcbucket.null, ]
-PREHOOK: query: drop table dest31
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest31
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest31
-POSTHOOK: Lineage: tst_dest31.a EXPRESSION [(srcbucket)srcbucket.null, ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table tst_dest32
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst_dest32
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table dest32
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest32
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table dest32(a int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table dest32(a int)
@@ -102,22 +94,10 @@ POSTHOOK: Lineage: tst_dest32.a EXPRESSI
PREHOOK: query: select * from tst_dest32
PREHOOK: type: QUERY
PREHOOK: Input: default@tst_dest32
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-12-44_362_8153903898810014347/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-54_520_2654638815572437304/10000
POSTHOOK: query: select * from tst_dest32
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tst_dest32
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-12-44_362_8153903898810014347/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-27-54_520_2654638815572437304/10000
POSTHOOK: Lineage: tst_dest32.a EXPRESSION [(srcbucket)srcbucket.null, ]
1000
-PREHOOK: query: drop table tst_dest32
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tst_dest32
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tst_dest32
-POSTHOOK: Lineage: tst_dest32.a EXPRESSION [(srcbucket)srcbucket.null, ]
-PREHOOK: query: drop table dest32
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest32
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest32
-POSTHOOK: Lineage: tst_dest32.a EXPRESSION [(srcbucket)srcbucket.null, ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input37.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input37.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input37.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input37.q.out Thu Jul 22 23:57:29 2010
@@ -18,7 +18,7 @@ FROM
group by url
PREHOOK: type: QUERY
PREHOOK: Input: default@documents
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/282167247/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-09_514_9061274612297235392/10000
POSTHOOK: query: select url, count(1)
FROM
(
@@ -29,11 +29,6 @@ FROM
group by url
POSTHOOK: type: QUERY
POSTHOOK: Input: default@documents
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/282167247/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-09_514_9061274612297235392/10000
1uauniajqtunlsvadmxhlxvngxpqjuzbpzvdiwmzphmbaicduzkgxgtdeiunduosu.html 4
4uzsbtwvdypfitqfqdjosynqp.html 4
-PREHOOK: query: DROP TABLE documents
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE documents
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@documents
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input38.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input38.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input38.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input38.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
@@ -79,7 +75,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-12-53_095_8197621741613421666/10000
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-28-12_445_5695557680495519967/10000
Stage: Stage-0
Move Operator
@@ -94,7 +90,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-12-53_095_8197621741613421666/10002
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-28-12_445_5695557680495519967/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -141,11 +137,11 @@ POSTHOOK: Lineage: dest1.value SCRIPT [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-12-57_512_6617436684028270134/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-15_024_5142138661614792399/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-12-57_512_6617436684028270134/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-15_024_5142138661614792399/10000
POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
238 val_238 3 7
@@ -648,10 +644,3 @@ POSTHOOK: Lineage: dest1.value SCRIPT [(
400 val_400 3 7
200 val_200 3 7
97 val_97 3 7
-PREHOOK: query: drop table dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input39.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input39.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input39.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input39.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table t1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table t1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table t2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table t2
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table t1(key string, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table t1(key string, value string) partitioned by (ds string)
@@ -158,7 +150,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-11-59_547_6173111859756543137/10002
+ file:/tmp/jssarma/hive_2010-07-21_11-28-22_923_4771955741892029143/10002
Reduce Output Operator
sort order:
tag: -1
@@ -193,12 +185,12 @@ PREHOOK: query: select count(1) from t1
PREHOOK: type: QUERY
PREHOOK: Input: default@t2@ds=1
PREHOOK: Input: default@t1@ds=1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-12-00_052_7056729807398553638/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-23_078_4826392180572466990/10000
POSTHOOK: query: select count(1) from t1 join t2 on t1.key=t2.key where t1.ds='1' and t2.ds='1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2@ds=1
POSTHOOK: Input: default@t1@ds=1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-12-00_052_7056729807398553638/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-23_078_4826392180572466990/10000
POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -206,25 +198,3 @@ POSTHOOK: Lineage: t1 PARTITION(ds=2).va
POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
18
-PREHOOK: query: drop table t1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table t1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t1
-POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: drop table t2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table t2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t2
-POSTHOOK: Lineage: t1 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t1 PARTITION(ds=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: DROP TABLE T1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE T1
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE T1(key STRING, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE T1(key STRING, value STRING) STORED AS TEXTFILE
@@ -17,10 +13,6 @@ PREHOOK: type: LOAD
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv2.txt' INTO TABLE T1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@t1
-PREHOOK: query: DROP TABLE T2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE T2
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE T2(key STRING, value STRING)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE T2(key STRING, value STRING)
@@ -90,7 +82,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-15-07_068_6853046437347700201/10002
+ file:/tmp/jssarma/hive_2010-07-21_11-28-28_770_5844411471048586267/10002
Reduce Output Operator
sort order:
tag: -1
@@ -135,11 +127,11 @@ POSTHOOK: Lineage: t2.value SIMPLE [(t1)
PREHOOK: query: SELECT * FROM T2 SORT BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-15-16_045_761099202785601542/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-33_846_8194327293225084148/10000
POSTHOOK: query: SELECT * FROM T2 SORT BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-15-16_045_761099202785601542/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-33_846_8194327293225084148/10000
POSTHOOK: Lineage: t2.key SIMPLE [(t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t2.value SIMPLE [(t1)t1.FieldSchema(name:value, type:string, comment:null), ]
0 val_0
@@ -162,17 +154,3 @@ POSTHOOK: Lineage: t2.value SIMPLE [(t1)
104 val_104
104 val_105
104 val_105
-PREHOOK: query: DROP TABLE T1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE T1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t1
-POSTHOOK: Lineage: t2.key SIMPLE [(t1)t1.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: t2.value SIMPLE [(t1)t1.FieldSchema(name:value, type:string, comment:null), ]
-PREHOOK: query: DROP TABLE T2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE T2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t2
-POSTHOOK: Lineage: t2.key SIMPLE [(t1)t1.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: t2.value SIMPLE [(t1)t1.FieldSchema(name:value, type:string, comment:null), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out Thu Jul 22 23:57:29 2010
@@ -19,8 +19,8 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-0
Copy
- source: file:/data/users/njain/hive5/hive5/data/files/kv1.txt
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/1092488123/10000
+ source: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/data/files/kv1.txt
+ destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-28-36_668_8539148391422299238/10000
Stage: Stage-1
Move Operator
@@ -41,11 +41,11 @@ POSTHOOK: Output: default@input4
PREHOOK: query: SELECT INPUT4.VALUE, INPUT4.KEY FROM INPUT4
PREHOOK: type: QUERY
PREHOOK: Input: default@input4
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/78834933/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-36_825_182661124432042155/10000
POSTHOOK: query: SELECT INPUT4.VALUE, INPUT4.KEY FROM INPUT4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@input4
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/78834933/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-36_825_182661124432042155/10000
val_238 238
val_86 86
val_311 311
@@ -546,8 +546,3 @@ val_403 403
val_400 400
val_200 200
val_97 97
-PREHOOK: query: DROP TABLE INPUT4
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE INPUT4
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@input4
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input40.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input40.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input40.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input40.q.out Thu Jul 22 23:57:29 2010
@@ -1,11 +1,3 @@
-PREHOOK: query: drop table tmp_insert_test
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tmp_insert_test
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table tmp_insert_test_p
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tmp_insert_test_p
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tmp_insert_test (key string, value string) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table tmp_insert_test (key string, value string) stored as textfile
@@ -19,11 +11,11 @@ POSTHOOK: Output: default@tmp_insert_tes
PREHOOK: query: select * from tmp_insert_test
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_insert_test
-PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1950785675/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-39_638_2152892791432727451/10000
POSTHOOK: query: select * from tmp_insert_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_insert_test
-POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1950785675/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-39_638_2152892791432727451/10000
238 val_238
86 val_86
311 val_311
@@ -538,12 +530,12 @@ PREHOOK: query: select * from tmp_insert
order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
-PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/237111013/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-39_834_15988274396181587/10000
POSTHOOK: query: select * from tmp_insert_test_p where ds= '2009-08-01'
order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
-POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/237111013/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-39_834_15988274396181587/10000
0 val_0 2009-08-01
0 val_0 2009-08-01
0 val_0 2009-08-01
@@ -1053,12 +1045,12 @@ PREHOOK: query: select * from tmp_insert
order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
-PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1350476431/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-42_667_8118898466258302182/10000
POSTHOOK: query: select * from tmp_insert_test_p where ds= '2009-08-01'
order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
-POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1350476431/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-42_667_8118898466258302182/10000
0 val_1 2009-08-01
0 val_1 2009-08-01
0 val_0 2009-08-01
@@ -2059,13 +2051,3 @@ POSTHOOK: Output: file:/data/users/jsich
98 val_98 2009-08-01
98 val_98 2009-08-01
99 val_100 2009-08-01
-PREHOOK: query: drop table tmp_insert_test
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tmp_insert_test
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tmp_insert_test
-PREHOOK: query: drop table tmp_insert_test_p
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tmp_insert_test_p
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@tmp_insert_test_p
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input41.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input41.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input41.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input41.q.out Thu Jul 22 23:57:29 2010
@@ -25,17 +25,11 @@ POSTHOOK: Lineage: dest_sp.cnt EXPRESSIO
PREHOOK: query: select * from dest_sp x order by x.cnt limit 2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_sp
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-15-40_207_9006053612393059372/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000
POSTHOOK: query: select * from dest_sp x order by x.cnt limit 2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_sp
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-15-40_207_9006053612393059372/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000
POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
0
500
-PREHOOK: query: drop table dest_sp
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table dest_sp
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest_sp
-POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out Thu Jul 22 23:57:29 2010
@@ -11,11 +11,11 @@ POSTHOOK: Output: default@input4_cb
PREHOOK: query: SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB
PREHOOK: type: QUERY
PREHOOK: Input: default@input4_cb
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/767747881/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-08_139_1251320511804274707/10000
POSTHOOK: query: SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB
POSTHOOK: type: QUERY
POSTHOOK: Input: default@input4_cb
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/767747881/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-29-08_139_1251320511804274707/10000
val_238 238
val_86 86
val_311 311
@@ -516,8 +516,3 @@ val_403 403
val_400 400
val_200 200
val_97 97
-PREHOOK: query: DROP TABLE INPUT4_CB
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE INPUT4_CB
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@input4_cb