You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2009/08/11 04:06:32 UTC
svn commit: r802976 [3/17] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/lib/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/...
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -24,6 +24,8 @@
Map Reduce
Alias -> Map Operator Tree:
input
+ TableScan
+ alias: input
Reduce Output Operator
key expressions:
expr: substr(value, 5)
@@ -72,7 +74,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1833926934/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/458423382/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -137,7 +139,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1833926934/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/458423382/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -208,7 +210,7 @@
Output: default/dest2
query: SELECT * from dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1082380771/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1557071213/10000
27 1 1
66 1 1
86 1 1
@@ -231,7 +233,7 @@
484 1 1
query: SELECT * from dest2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1659136589/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1527114002/10000
27 27 27
66 66 66
86 86 86
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Reduce Output Operator
key expressions:
expr: key
@@ -73,7 +75,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2088834380/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/353987509/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -140,7 +142,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2088834380/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/353987509/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -215,7 +217,7 @@
Output: default/dest2/ds=111
query: SELECT * from dest1
Input: default/dest1/ds=111
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1942173858/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1308166623/10000
val_0 3 1 111
val_10 1 1 111
val_100 2 1 111
@@ -527,7 +529,7 @@
val_98 2 1 111
query: SELECT * from dest2
Input: default/dest2/ds=111
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2116311815/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/208593605/10000
0 3 1 111
10 1 1 111
100 2 1 111
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_limit.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -68,7 +70,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1076473475/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1173614638/10002
Reduce Output Operator
sort order:
tag: -1
@@ -112,7 +114,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1546240918/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/197588214/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -88,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/650056033/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1144777415/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_nomap.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -88,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1003792766/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/200206031/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_map_skew.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -60,7 +62,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/288360441/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1847926486/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -121,7 +123,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1461563425/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1826125083/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby1_noskew.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -80,7 +82,7 @@
Output: default/dest_g1
query: SELECT dest_g1.* FROM dest_g1
Input: default/dest_g1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1408602511/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1062669499/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -55,7 +57,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/98786317/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1035591703/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -124,7 +126,7 @@
Output: default/dest_g2
query: SELECT dest_g2.* FROM dest_g2
Input: default/dest_g2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/376809666/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/33506140/10000
0 1 00.0
1 71 116414.0
2 69 225571.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_limit.q.out Tue Aug 11 02:06:23 2009
@@ -12,6 +12,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -70,7 +72,7 @@
query: SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 5
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/209868765/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1181116822/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -102,7 +104,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/367010437/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/907085747/10000
0 1 00.0
1 71 116414.0
2 69 225571.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -71,7 +73,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/340084845/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1895770841/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -140,7 +142,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1380797269/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/668586222/10000
0 1 00.0
1 71 116414.0
2 69 225571.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -86,7 +88,7 @@
Output: default/dest_g2
query: SELECT dest_g2.* FROM dest_g2
Input: default/dest_g2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1336300297/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2078044703/10000
0 1 00.0
1 71 116414.0
2 69 225571.0
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -24,6 +24,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -62,7 +64,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/emil/hive1/hive1/build/ql/tmp/1684499238/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/313900141/10002
Reduce Output Operator
sort order:
tag: -1
@@ -176,6 +178,6 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1807842455/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1347361975/10000
130091.0 260.182 256.10355987055016 98.0 0.0 142.92680950752379 143.06995106518903 20428.072875999995 20469.010897795586
query: DROP TABLE dest1
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -160,6 +162,6 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/1984222937/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1726617358/10000
130091.0 260.182 256.10355987055016 98.0 0.0 142.9268095075238 143.06995106518906 20428.072876 20469.01089779559
query: DROP TABLE dest1
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -24,6 +24,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -97,7 +99,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/emil/hive1/hive1/build/ql/tmp/738212968/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/979355284/10002
Reduce Output Operator
sort order:
tag: -1
@@ -211,6 +213,6 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/528887072/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/293386936/10000
130091.0 260.182 256.10355987055016 98.0 0.0 142.9268095075238 143.06995106518906 20428.072876 20469.01089779559
query: DROP TABLE dest1
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -109,7 +111,6 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
-
query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT
sum(substr(src.value,5)),
@@ -125,6 +126,6 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/emil/hive1/hive1/build/ql/tmp/537230860/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2134252669/10000
130091.0 260.182 256.10355987055016 98.0 0.0 142.92680950752379 143.06995106518903 20428.072875999995 20469.010897795586
query: DROP TABLE dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -46,7 +48,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/959139456/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1357905866/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -94,7 +96,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1076286767/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1402842530/10000
0
1
2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
Group By Operator
aggregations:
@@ -66,5 +68,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/225285836/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/660625663/10000
500
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
Group By Operator
aggregations:
@@ -66,5 +68,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1894553109/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1299647680/10000
500
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -66,7 +68,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1738488269/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/153160326/10000
0
1
2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -55,7 +57,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1116257578/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1836517958/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -119,7 +121,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1251278214/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/472765000/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -70,5 +72,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/777816939/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/136910930/10000
130091
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -70,5 +72,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/949792340/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2100680851/10000
130091
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -86,7 +88,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1980389911/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1708211250/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -46,7 +48,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/814045297/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/593503240/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -94,7 +96,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/473228216/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/855864385/10000
0
1
2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -72,7 +74,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/773047983/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1366391771/10000
0
1
2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -52,7 +54,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/338642133/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1400626799/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -100,7 +102,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1181271396/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1699461209/10000
0
1
2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: value
@@ -66,7 +68,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/537807797/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1334215067/10000
0
1
2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -111,7 +113,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/279658140/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/694830610/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -175,7 +177,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/191972107/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/278066492/10000
0 0.0
10 10.0
100 200.0
@@ -487,7 +489,7 @@
98 196.0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1027947003/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1908409762/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -87,7 +89,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/319307034/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1750763372/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -145,7 +147,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/319307034/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1750763372/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -177,7 +179,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/319307034/10006
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1750763372/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -241,7 +243,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/362951911/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/682338522/10000
0 0.0
10 10.0
100 200.0
@@ -553,7 +555,7 @@
98 196.0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1043792398/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/495752431/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -95,7 +97,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1433385453/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/168306151/10004
Reduce Output Operator
key expressions:
expr: key
@@ -159,7 +161,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/341712473/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/27584412/10000
0 0.0
10 10.0
100 200.0
@@ -471,7 +473,7 @@
98 196.0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/814627744/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/104857768/10000
0 0.0
10 10.0
100 200.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Reduce Output Operator
key expressions:
expr: substr(value, 5)
@@ -65,7 +67,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1989034170/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/419849241/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -123,7 +125,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1989034170/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/419849241/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -187,7 +189,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1596722289/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/371059848/10000
0 1
10 1
100 1
@@ -499,7 +501,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/721876966/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/907975599/10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Reduce Output Operator
key expressions:
expr: substr(value, 5)
@@ -65,7 +67,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1155746745/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/206377783/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -123,7 +125,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1155746745/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/206377783/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -187,7 +189,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1384333034/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/317456248/10000
0 1
10 1
100 1
@@ -499,7 +501,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2072775887/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/982390628/10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Reduce Output Operator
key expressions:
expr: substr(value, 5)
@@ -65,7 +67,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/405462104/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1626240365/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -123,7 +125,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/405462104/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1626240365/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -187,7 +189,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1228344007/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/195494600/10000
0 1
10 1
100 1
@@ -499,7 +501,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1951309908/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1605077446/10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Reduce Output Operator
key expressions:
expr: substr(value, 5)
@@ -65,7 +67,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/121204644/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1854610071/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -123,7 +125,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/121204644/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1854610071/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -187,7 +189,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2074527502/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/208463828/10000
0 1
10 1
100 1
@@ -499,7 +501,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/572299908/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/621035645/10000
0 1
10 1
100 1
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -21,6 +21,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Reduce Output Operator
key expressions:
expr: substr(value, 5)
@@ -71,7 +73,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/576845986/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2056299757/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -129,7 +131,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/576845986/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2056299757/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -203,7 +205,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/618560359/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1454113650/10000
0 1
10 1
100 1
@@ -515,7 +517,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/665362650/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1099145371/10000
0 val_0 1
10 val_10 1
100 val_100 1
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=802976&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Tue Aug 11 02:06:23 2009
@@ -0,0 +1,208 @@
+query: CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
+query: EXPLAIN EXTENDED
+FROM srcpart src
+INSERT OVERWRITE TABLE dest1
+SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5)))
+WHERE src.ds = '2008-04-08'
+GROUP BY substr(src.key,1,1)
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION concat (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1) (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL src) ds) '2008-04-08')) (TOK_GROUPBY (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: key, value
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(value, 5))
+ expr: sum(substr(value, 5))
+ keys:
+ expr: substr(key, 1, 1)
+ type: string
+ expr: substr(value, 5)
+ type: string
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ expr: _col3
+ type: double
+ Needs Tagging: false
+ Path -> Alias:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Path -> Partition:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 11
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT KEY._col1)
+ expr: sum(VALUE._col1)
+ keys:
+ expr: KEY._col0
+ type: string
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: bigint
+ expr: concat(_col0, UDFToString(_col2))
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: UDFToInteger(_col1)
+ type: int
+ expr: _col2
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/972766884/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types string:int:string
+ serialization.ddl struct dest1 { string key, i32 c1, string c2}
+ serialization.format 1
+ columns key,c1,c2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/972766884/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types string:int:string
+ serialization.ddl struct dest1 { string key, i32 c1, string c2}
+ serialization.format 1
+ columns key,c1,c2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/972766884/10001
+
+
+query: FROM srcpart src
+INSERT OVERWRITE TABLE dest1
+SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5)))
+WHERE src.ds = '2008-04-08'
+GROUP BY substr(src.key,1,1)
+Input: default/srcpart/ds=2008-04-08/hr=11
+Input: default/srcpart/ds=2008-04-08/hr=12
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/161443012/10000
+0 1 00.0
+1 71 132828.0
+2 69 251142.0
+3 62 364008.0
+4 74 4105526.0
+5 6 5794.0
+6 5 6796.0
+7 6 71470.0
+8 8 81524.0
+9 7 92094.0
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out?rev=802976&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_ppr.q.out Tue Aug 11 02:06:23 2009
@@ -0,0 +1,192 @@
+query: CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
+query: EXPLAIN EXTENDED
+FROM srcpart src
+INSERT OVERWRITE TABLE dest1
+SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5)))
+WHERE src.ds = '2008-04-08'
+GROUP BY substr(src.key,1,1)
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF srcpart src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))) (TOK_SELEXPR (TOK_FUNCTION concat (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1) (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5))))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL src) ds) '2008-04-08')) (TOK_GROUPBY (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) key) 1 1))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ TableScan
+ alias: src
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Filter Operator
+ isSamplingPred: false
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: key, value
+ Reduce Output Operator
+ key expressions:
+ expr: substr(key, 1, 1)
+ type: string
+ expr: substr(value, 5)
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: substr(key, 1, 1)
+ type: string
+ tag: -1
+ Needs Tagging: false
+ Path -> Alias:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Path -> Partition:
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 11
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ Partition
+ partition values:
+ ds 2008-04-08
+ hr 12
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name srcpart
+ columns.types string:string
+ serialization.ddl struct srcpart { string key, string value}
+ serialization.format 1
+ columns key,value
+ partition_columns ds/hr
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: srcpart
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT KEY._col1)
+ expr: sum(KEY._col1)
+ keys:
+ expr: KEY._col0
+ type: string
+ mode: complete
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: bigint
+ expr: concat(_col0, UDFToString(_col2))
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: UDFToInteger(_col1)
+ type: int
+ expr: _col2
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/633188587/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types string:int:string
+ serialization.ddl struct dest1 { string key, i32 c1, string c2}
+ serialization.format 1
+ columns key,c1,c2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ replace: true
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/633188587/10000
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types string:int:string
+ serialization.ddl struct dest1 { string key, i32 c1, string c2}
+ serialization.format 1
+ columns key,c1,c2
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/633188587/10001
+
+
+query: FROM srcpart src
+INSERT OVERWRITE TABLE dest1
+SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5)))
+WHERE src.ds = '2008-04-08'
+GROUP BY substr(src.key,1,1)
+Input: default/srcpart/ds=2008-04-08/hr=11
+Input: default/srcpart/ds=2008-04-08/hr=12
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/561326404/10000
+0 1 00.0
+1 71 132828.0
+2 69 251142.0
+3 62 364008.0
+4 74 4105526.0
+5 6 5794.0
+6 5 6796.0
+7 6 71470.0
+8 8 81524.0
+9 7 92094.0
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
implicit_test1
+ TableScan
+ alias: implicit_test1
Filter Operator
predicate:
expr: (UDFToDouble(a) <> UDFToDouble(0))
@@ -46,5 +48,5 @@
FROM implicit_test1
WHERE implicit_test1.a <> 0
Input: default/implicit_test1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2080135303/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/915534198/10000
query: DROP TABLE implicit_test1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -52,10 +54,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/947366585/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1030796464/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/232837920/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1121239779/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -95,7 +97,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/68605859/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2019052885/10000
86 val_86
27 val_27
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -74,7 +76,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/469291801/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1979379952/10000
86 val_86
27 val_27
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -104,10 +106,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/170032054/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1924563025/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/151034280/10006
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/467218372/10006
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -146,10 +148,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/170032054/10002
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1924563025/10002
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/151034280/10007
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/467218372/10007
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -188,10 +190,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/170032054/10004
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1924563025/10004
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/151034280/10008
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/467218372/10008
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -236,7 +238,7 @@
Output: default/dest3/ds=2008-04-08/hr=12
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1444798074/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1597762873/10000
86 val_86
27 val_27
98 val_98
@@ -323,7 +325,7 @@
97 val_97
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1209928310/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/106250860/10000
165 val_165
193 val_193
150 val_150
@@ -431,7 +433,7 @@
169 val_169
query: SELECT dest3.* FROM dest3
Input: default/dest3/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1215159045/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/852643259/10000
238 2008-04-08 12
311 2008-04-08 12
409 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out Tue Aug 11 02:06:23 2009
@@ -26,6 +26,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -122,10 +124,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/2103139823/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/670802827/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/210340643/10007
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1557476151/10007
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -164,10 +166,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/2103139823/10002
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/670802827/10002
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/210340643/10008
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1557476151/10008
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -206,10 +208,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/2103139823/10004
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/670802827/10004
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/210340643/10009
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1557476151/10009
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -249,10 +251,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/2103139823/10006
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/670802827/10006
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/210340643/10010
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1557476151/10010
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -290,7 +292,7 @@
Output: ../build/ql/test/data/warehouse/dest4.out
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1733324289/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/881401051/10000
86 val_86
27 val_27
98 val_98
@@ -377,7 +379,7 @@
97 val_97
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1779971956/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2139886551/10000
165 val_165
193 val_193
150 val_150
@@ -485,7 +487,7 @@
169 val_169
query: SELECT dest3.* FROM dest3
Input: default/dest3/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1888647376/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1615208828/10000
238 2008-04-08 12
255 2008-04-08 12
278 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -96,7 +98,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/254878200/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1767626690/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -59,7 +61,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1622333901/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/34766397/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -126,7 +128,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/646323888/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/452755876/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: (aint + lint[0])
@@ -92,7 +94,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/367319018/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2071608019/10000
NULL null
-1461153966 {"myint":49,"mystring":"343","underscore_int":7}
-1952710705 {"myint":25,"mystring":"125","underscore_int":5}
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -100,7 +102,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1602054663/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1817619374/10000
0 val_0+3+7
0 val_0+3+7
0 val_0+3+7
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -88,7 +90,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1245617876/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1614539331/10004
Reduce Output Operator
sort order:
tag: -1
@@ -135,7 +137,7 @@
Output: default/dest2
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/62325349/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1722063757/10000
86 val_86
27 val_27
98 val_98
@@ -148,7 +150,7 @@
57 val_57
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1944665734/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1675468164/10000
86 val_86
27 val_27
98 val_98