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/07/15 03:52:45 UTC
svn commit: r794129 [3/8] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/java/org/...
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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -21,9 +21,9 @@
type: string
Group By Operator
aggregations:
- expr: sum(UDFToDouble(substr(value, 5)))
- expr: avg(UDFToDouble(substr(value, 5)))
- expr: avg(DISTINCT UDFToDouble(substr(value, 5)))
+ expr: sum(substr(value, 5))
+ expr: avg(substr(value, 5))
+ expr: avg(DISTINCT substr(value, 5))
expr: max(substr(value, 5))
expr: min(substr(value, 5))
keys:
@@ -43,9 +43,9 @@
expr: _col1
type: double
expr: _col2
- type: string
+ type: struct<count:bigint,sum:double>
expr: _col3
- type: string
+ type: struct<count:bigint,sum:double>
expr: _col4
type: string
expr: _col5
@@ -55,22 +55,21 @@
aggregations:
expr: sum(VALUE._col0)
expr: avg(VALUE._col1)
- expr: avg(DISTINCT UDFToDouble(KEY._col0))
+ expr: avg(DISTINCT KEY._col0)
expr: max(VALUE._col3)
expr: min(VALUE._col4)
- mode: partial2
+ mode: partials
File Output Operator
compressed: false
GlobalTableId: 0
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1228327883/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1038557328/10002
Reduce Output Operator
sort order:
tag: -1
@@ -78,9 +77,9 @@
expr: _col0
type: double
expr: _col1
- type: string
+ type: struct<count:bigint,sum:double>
expr: _col2
- type: string
+ type: struct<count:bigint,sum:double>
expr: _col3
type: string
expr: _col4
@@ -144,5 +143,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/820936142/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/419092325/10000
130091.0 260.182 256.10355987055016 98.0 0.0
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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -27,9 +27,9 @@
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: sum(UDFToDouble(KEY._col0))
- expr: avg(UDFToDouble(KEY._col0))
- expr: avg(DISTINCT UDFToDouble(KEY._col0))
+ expr: sum(KEY._col0)
+ expr: avg(KEY._col0)
+ expr: avg(DISTINCT KEY._col0)
expr: max(KEY._col0)
expr: min(KEY._col0)
mode: complete
@@ -83,5 +83,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/812556087/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1412035042/10000
130091.0 260.182 256.10355987055016 98.0 0.0
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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -40,12 +40,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/109948629/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/238763710/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -91,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1413679175/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/705798724/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -38,7 +38,7 @@
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: sum(UDFToDouble(VALUE._col0))
+ expr: sum(VALUE._col0)
keys:
expr: KEY._col0
type: string
@@ -49,12 +49,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1596834878/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1023721383/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -115,7 +114,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1785134146/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1858809382/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -19,7 +19,7 @@
type: string
Group By Operator
aggregations:
- expr: sum(UDFToDouble(key))
+ expr: sum(key)
mode: hash
Reduce Output Operator
sort order:
@@ -65,5 +65,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1649758304/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/430800667/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -19,7 +19,7 @@
type: string
Group By Operator
aggregations:
- expr: sum(UDFToDouble(key))
+ expr: sum(key)
mode: hash
Reduce Output Operator
sort order:
@@ -65,5 +65,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1898688763/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/535679117/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -37,7 +37,7 @@
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: sum(UDFToDouble(VALUE._col0))
+ expr: sum(VALUE._col0)
keys:
expr: KEY._col0
type: string
@@ -82,7 +82,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/990860736/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1880216237/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -40,12 +40,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1494846209/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2034874876/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -91,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1921611682/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/770471577/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -38,19 +38,18 @@
keys:
expr: KEY._col0
type: string
- mode: partial2
+ mode: partials
File Output Operator
compressed: false
GlobalTableId: 0
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1834003124/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/745628298/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -96,7 +95,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1944209858/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/6016821/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -26,7 +26,7 @@
type: string
Group By Operator
aggregations:
- expr: sum(UDFToDouble(substr(value, 5)))
+ expr: sum(substr(value, 5))
keys:
expr: key
type: string
@@ -51,7 +51,7 @@
type: string
Group By Operator
aggregations:
- expr: sum(UDFToDouble(substr(value, 5)))
+ expr: sum(substr(value, 5))
keys:
expr: key
type: string
@@ -62,7 +62,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -105,7 +104,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1567721211/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/183709519/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -166,7 +165,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/573082325/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1600502847/10000
0 0.0
10 10.0
100 200.0
@@ -478,7 +477,7 @@
98 196.0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/749695907/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1252175276/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -28,7 +28,7 @@
type: string
Group By Operator
aggregations:
- expr: sum(UDFToDouble(substr(value, 5)))
+ expr: sum(substr(value, 5))
keys:
expr: key
type: string
@@ -53,7 +53,7 @@
type: string
Group By Operator
aggregations:
- expr: sum(UDFToDouble(substr(value, 5)))
+ expr: sum(substr(value, 5))
keys:
expr: key
type: string
@@ -64,7 +64,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -72,19 +71,18 @@
keys:
expr: KEY._col0
type: string
- mode: partial2
+ mode: partials
File Output Operator
compressed: true
GlobalTableId: 0
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1954125949/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/107805350/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -139,7 +137,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1954125949/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/107805350/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -159,19 +157,18 @@
keys:
expr: KEY._col0
type: string
- mode: partial2
+ mode: partials
File Output Operator
compressed: true
GlobalTableId: 0
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1954125949/10006
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/107805350/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -232,7 +229,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/454858363/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/735440976/10000
0 0.0
10 10.0
100 200.0
@@ -544,7 +541,7 @@
98 196.0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/207448427/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2032949852/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -48,11 +48,10 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: sum(UDFToDouble(VALUE._col0))
+ expr: sum(VALUE._col0)
keys:
expr: KEY._col0
type: string
@@ -91,7 +90,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/654919673/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1533892009/10004
Reduce Output Operator
key expressions:
expr: key
@@ -107,7 +106,7 @@
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: sum(UDFToDouble(VALUE._col0))
+ expr: sum(VALUE._col0)
keys:
expr: KEY._col0
type: string
@@ -152,7 +151,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/988624770/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1595159754/10000
0 0.0
10 10.0
100 200.0
@@ -464,7 +463,7 @@
98 196.0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/104017678/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/25705563/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -51,7 +51,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -66,12 +65,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/375925648/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/276821233/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -126,7 +124,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/375925648/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/276821233/10005
Reduce Output Operator
key expressions:
expr: key
@@ -154,12 +152,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/375925648/10006
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/276821233/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -220,7 +217,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1760864760/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/437515527/10000
0 1
10 1
100 1
@@ -532,7 +529,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1829308600/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1234696603/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -68,7 +68,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -111,7 +110,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/903311418/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/794989277/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -174,7 +173,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1813648590/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/464738216/10000
0 1
10 1
100 1
@@ -486,7 +485,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1471574546/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/989476641/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -72,7 +72,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -80,19 +79,18 @@
keys:
expr: KEY._col0
type: string
- mode: partial2
+ mode: partials
File Output Operator
compressed: false
GlobalTableId: 0
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/648298710/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1950398352/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -147,7 +145,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/648298710/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1950398352/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -171,19 +169,18 @@
keys:
expr: KEY._col0
type: string
- mode: partial2
+ mode: partials
File Output Operator
compressed: false
GlobalTableId: 0
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/648298710/10006
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1950398352/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -244,7 +241,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/2050045624/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/53142172/10000
0 1
10 1
100 1
@@ -556,7 +553,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1488204579/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1788932250/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -47,7 +47,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -90,7 +89,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1042516895/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/511682888/10004
Reduce Output Operator
key expressions:
expr: key
@@ -150,7 +149,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1777705235/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2002182053/10000
0 1
10 1
100 1
@@ -462,7 +461,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1019154159/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/673356891/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -72,7 +72,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -115,7 +114,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/847202273/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/620467689/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -188,7 +187,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/2085147439/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1918642131/10000
0 1
10 1
100 1
@@ -500,7 +499,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/778831730/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/925610192/10000
0 val_0 1
10 val_10 1
100 val_100 1
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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -54,12 +54,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1708160679/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/105591315/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -124,7 +123,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1754915131/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/790975206/10000
0 val_0
0 val_0
0 val_0
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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -54,7 +54,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Reduce Operator Tree:
Extract
Limit
@@ -86,7 +85,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1060095583/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/190339835/10004
Reduce Output Operator
sort order:
tag: -1
@@ -132,7 +131,7 @@
Output: default/dest2
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1315139116/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1258757679/10000
86 val_86
27 val_27
98 val_98
@@ -145,7 +144,7 @@
57 val_57
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1285938692/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1544848437/10000
86 val_86
27 val_27
98 val_98
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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -59,12 +59,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/717433292/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1576345941/10002
Union
Select Operator
expressions:
@@ -80,7 +79,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/717433292/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1576345941/10003
Union
Select Operator
expressions:
@@ -137,7 +136,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-0
Fetch Operator
@@ -151,5 +149,5 @@
) subq
Input: default/tst/d=2009-01-01
Input: default/tst/d=2009-02-02
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/273314648/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1172948551/10000
query: drop table tst
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out Wed Jul 15 01:52:41 2009
@@ -61,12 +61,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/998416025/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1656753029/10002
Union
Select Operator
expressions:
@@ -84,7 +83,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/998416025/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1656753029/10003
Union
Select Operator
expressions:
@@ -147,7 +146,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-0
Fetch Operator
@@ -160,7 +158,7 @@
select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
)subq
Input: default/srcpart/ds=2008-04-08/hr=11
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/122967309/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1769087452/10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -56,12 +56,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/2087941217/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1327788868/10002
Reduce Output Operator
sort order:
tag: -1
@@ -98,7 +97,7 @@
Output: default/t2
query: SELECT * FROM T2 SORT BY key, value
Input: default/t2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1213849877/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1102190511/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out Wed Jul 15 01:52:41 2009
@@ -39,12 +39,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2049580485/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1567308263/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -73,7 +72,7 @@
query: select * from src sort by key limit 10
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/83498755/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1617449632/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out Wed Jul 15 01:52:41 2009
@@ -86,12 +86,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1881512857/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/760579710/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -134,7 +133,7 @@
(SELECT * FROM src WHERE src.key < 10) src2
SORT BY k1, v1, k2, v2
Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/905222648/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1911587693/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out Wed Jul 15 01:52:41 2009
@@ -79,7 +79,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
@@ -156,7 +155,7 @@
(SELECT src.key as c5, src.value as c6 from src) src3
ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/372904562/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1668670433/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out Wed Jul 15 01:52:41 2009
@@ -65,12 +65,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/324026452/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/737821530/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -108,7 +107,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/394554803/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1955953451/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out Wed Jul 15 01:52:41 2009
@@ -74,7 +74,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
@@ -182,7 +181,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-0
Fetch Operator
@@ -202,8 +200,8 @@
ON (a.key = b.key)
Input: default/src1
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/724709493/10000
-NULL NULL 6
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/838858920/10000
+NULL NULL 7
0 3 NULL NULL
10 1 NULL NULL
100 2 NULL NULL
@@ -221,7 +219,7 @@
120 2 NULL NULL
125 2 NULL NULL
126 1 NULL NULL
-128 3 128 0
+128 3 128 1
129 2 NULL NULL
131 1 NULL NULL
133 1 NULL NULL
@@ -295,7 +293,7 @@
221 2 NULL NULL
222 1 NULL NULL
223 2 NULL NULL
-224 2 224 0
+224 2 224 1
226 1 NULL NULL
228 1 NULL NULL
229 2 NULL NULL
@@ -388,7 +386,7 @@
366 1 NULL NULL
367 2 NULL NULL
368 1 NULL NULL
-369 3 369 0
+369 3 369 1
37 2 NULL NULL
373 1 NULL NULL
374 1 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out Wed Jul 15 01:52:41 2009
@@ -162,7 +162,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-3
Map Reduce
@@ -248,7 +247,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-1
Map Reduce
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out Wed Jul 15 01:52:41 2009
@@ -53,7 +53,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
@@ -129,7 +128,7 @@
Output: default/dest_j2
query: SELECT dest_j2.* FROM dest_j2
Input: default/dest_j2
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/47427829/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1158599181/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out Wed Jul 15 01:52:41 2009
@@ -103,12 +103,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/281582968/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/644565255/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -155,7 +154,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/105019591/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2039570057/10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 11 val_11
NULL NULL NULL NULL 12 val_12
@@ -337,12 +336,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1417429723/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/256148947/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -389,7 +387,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1953761211/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1492340440/10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 11 val_11
NULL NULL NULL NULL 12 val_12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out Wed Jul 15 01:52:41 2009
@@ -110,12 +110,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/14709034/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/348166588/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -161,7 +160,7 @@
query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/808695063/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/63858627/10000
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out Wed Jul 15 01:52:41 2009
@@ -56,7 +56,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out Wed Jul 15 01:52:41 2009
@@ -65,12 +65,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/283776935/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/701301764/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -108,7 +107,7 @@
query: SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/334248421/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1243967728/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join24.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join24.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join24.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join24.q.out Wed Jul 15 01:52:41 2009
@@ -5,6 +5,6 @@
Output: default/tst1
query: SELECT sum(a.cnt) FROM tst1 a JOIN tst1 b ON a.key = b.key
Input: default/tst1
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/148610721/785047285.10000
-500.0
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2016366076/10000
+500
query: drop table tst1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out Wed Jul 15 01:52:41 2009
@@ -66,12 +66,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10002
Common Join Operator
condition map:
Inner Join 0 to 1
@@ -117,11 +116,11 @@
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10004
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10004
Common Join Operator
condition map:
Inner Join 0 to 1
@@ -171,10 +170,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1060447709/10000
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/633726078/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -256,7 +255,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
query: INSERT OVERWRITE TABLE dest_j1
@@ -268,7 +266,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/2107397936/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/275397946/10000
128 1 3
146 1 2
150 1 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out Wed Jul 15 01:52:41 2009
@@ -65,12 +65,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10002
Common Join Operator
condition map:
Inner Join 0 to 1
@@ -90,11 +89,11 @@
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10004
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10004
Common Join Operator
condition map:
Inner Join 0 to 1
@@ -115,7 +114,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10003
Select Operator
expressions:
expr: _col0
@@ -227,7 +226,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
query: INSERT OVERWRITE TABLE dest_j1
@@ -240,7 +238,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1617117942/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/944474467/10000
128 1
146 1
150 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out Wed Jul 15 01:52:41 2009
@@ -31,13 +31,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
columns _col0,_col1,_col3
columns.types string,string,string
+ escape.delim \
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -59,18 +60,19 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
columns _col0,_col1,_col3
columns.types string,string,string
+ escape.delim \
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -85,14 +87,14 @@
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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003
Select Operator
expressions:
expr: _col0
@@ -130,7 +132,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -144,7 +146,7 @@
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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Local Work:
@@ -196,7 +198,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -210,14 +212,14 @@
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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003
Path -> Partition:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -225,6 +227,7 @@
properties:
columns _col0,_col1,_col3
columns.types string,string,string
+ escape.delim \
Stage: Stage-4
Conditional Operator
@@ -232,11 +235,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
- destination: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10000
+ source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -252,9 +255,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
Path -> Partition:
- file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -269,7 +272,7 @@
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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Reduce Operator Tree:
@@ -277,7 +280,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10000
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -291,7 +294,7 @@
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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -299,7 +302,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10000
+ source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -313,10 +316,10 @@
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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10001
+ tmp directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -329,7 +332,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/2032442026/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/149664059/10000
146 val_146 val_146
146 val_146 val_146
146 val_146 val_146
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out Wed Jul 15 01:52:41 2009
@@ -30,13 +30,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
columns _col0,_col1,_col3
columns.types string,string,string
+ escape.delim \
Local Work:
Map Reduce Local Work
Alias -> Map Local Tables:
@@ -58,18 +59,19 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
columns _col0,_col1,_col3
columns.types string,string,string
+ escape.delim \
Needs Tagging: false
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -84,7 +86,7 @@
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:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
@@ -116,7 +118,7 @@
value expressions:
expr: value
type: string
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002
Select Operator
expressions:
expr: _col0
@@ -141,10 +143,10 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -163,10 +165,10 @@
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:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -174,6 +176,7 @@
properties:
columns _col0,_col1,_col3
columns.types string,string,string
+ escape.delim \
Reduce Operator Tree:
Join Operator
condition map:
@@ -192,7 +195,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/775185405/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -206,7 +209,7 @@
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:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -214,7 +217,7 @@
Move Operator
tables:
replace: true
- source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
+ source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/775185405/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -228,10 +231,10 @@
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:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10001
+ tmp directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/775185405/10001
query: INSERT OVERWRITE TABLE dest_j1
@@ -244,7 +247,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1659514145/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/406645989/10000
146 val_146 val_146
146 val_146 val_146
146 val_146 val_146