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 [4/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/join35.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out Wed Jul 15 01:52:41 2009
@@ -60,9 +60,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/rmurthy/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/rmurthy/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
@@ -77,7 +77,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/rmurthy/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
Reduce Operator Tree:
@@ -97,20 +97,19 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10002
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- name binary_table
- serialization.ddl struct binary_table { string _col0, i64 _col1}
- serialization.format org.apache.thrift.protocol.TBinaryProtocol
- name: binary_table
+ columns _col0,_col1
+ columns.types string,bigint
+ escape.delim \
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002
Union
Common Join Operator
condition map:
@@ -149,7 +148,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -163,10 +162,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/rmurthy/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
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004
Union
Common Join Operator
condition map:
@@ -205,7 +204,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -219,7 +218,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/rmurthy/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:
@@ -267,7 +266,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -281,34 +280,32 @@
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/rmurthy/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/rmurthy/hive/build/ql/tmp/1831027677/10002
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004
Path -> Partition:
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- name binary_table
- serialization.ddl struct binary_table { string _col0, i64 _col1}
- serialization.format org.apache.thrift.protocol.TBinaryProtocol
- name: binary_table
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004
+ columns _col0,_col1
+ columns.types string,bigint
+ escape.delim \
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- name binary_table
- serialization.ddl struct binary_table { string _col0, i64 _col1}
- serialization.format org.apache.thrift.protocol.TBinaryProtocol
- name: binary_table
+ columns _col0,_col1
+ columns.types string,bigint
+ escape.delim \
Stage: Stage-5
Conditional Operator
@@ -316,11 +313,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
- destination: file:/data/users/rmurthy/hive/build/ql/tmp/751585738/10000
+ source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -336,9 +333,9 @@
type: int
Needs Tagging: false
Path -> Alias:
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
Path -> Partition:
- file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -353,7 +350,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/rmurthy/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:
@@ -361,7 +358,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/751585738/10000
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -375,7 +372,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/rmurthy/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
@@ -383,7 +380,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/rmurthy/hive/build/ql/tmp/751585738/10000
+ source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -397,10 +394,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/rmurthy/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/rmurthy/hive/build/ql/tmp/751585738/10001
+ tmp directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10001
Stage: Stage-6
Map Reduce
@@ -439,9 +436,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/rmurthy/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/rmurthy/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
@@ -456,7 +453,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/rmurthy/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
Reduce Operator Tree:
@@ -476,15 +473,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- name binary_table
- serialization.ddl struct binary_table { string _col0, i64 _col1}
- serialization.format org.apache.thrift.protocol.TBinaryProtocol
- name: binary_table
+ columns _col0,_col1
+ columns.types string,bigint
+ escape.delim \
query: INSERT OVERWRITE TABLE dest_j1
@@ -500,7 +496,7 @@
Output: default/dest_j1
query: select * from dest_j1 x order by x.key
Input: default/dest_j1
-Output: file:/data/users/rmurthy/hive/build/ql/tmp/388644930/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/140307786/10000
128 3
146 val_146 2
150 val_150 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.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
Stage: Stage-2
Map Reduce
@@ -133,7 +132,7 @@
Input: default/hive_foo
Input: default/hive_count
Input: default/hive_bar
-Output: file:/Users/char/Documents/workspace/Hive-Clean/build/ql/tmp/512847523/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/677923597/10000
foo1 bar10 2
query: drop table hive_foo
query: drop table hive_bar
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Wed Jul 15 01:52:41 2009
@@ -63,12 +63,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/926752707/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/792304338/10002
Reduce Output Operator
key expressions:
expr: _col0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Wed Jul 15 01:52:41 2009
@@ -54,7 +54,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1268175684/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1008591078/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -112,7 +112,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1223713151/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2013896638/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -158,12 +158,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/163149910/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1522558889/10002
Reduce Output Operator
sort order:
tag: -1
@@ -193,7 +192,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1599407772/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1698315525/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -247,5 +246,5 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1652857331/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1010160157/10000
0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Wed Jul 15 01:52:41 2009
@@ -51,19 +51,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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/728386179/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/994469608/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -101,10 +100,9 @@
Fetch Operator
limit: -1
-
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/284238698/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/307851852/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -178,7 +176,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1931999488/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1608573572/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -232,12 +230,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/1264700371/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/360265532/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -278,7 +275,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/192620128/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/208705197/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -345,4 +342,4 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/5517742/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1575645808/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Wed Jul 15 01:52:41 2009
@@ -52,19 +52,18 @@
aggregations:
expr: count(VALUE._col0)
expr: count(DISTINCT KEY._col0)
- 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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/630845842/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1530804093/10002
Reduce Output Operator
sort order:
tag: -1
@@ -99,7 +98,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1938635713/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/429769664/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -172,7 +171,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2019754835/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1474714748/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -225,12 +224,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/1425841757/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1775276557/10002
Reduce Output Operator
sort order:
tag: -1
@@ -265,7 +263,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2042822876/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/559124922/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -328,5 +326,5 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2013029014/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2134992556/10000
0 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Wed Jul 15 01:52:41 2009
@@ -56,7 +56,7 @@
query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/673778413/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1968231476/10000
10 val_10
query: EXPLAIN
SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
@@ -129,12 +129,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/1323731431/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/955520378/10002
Reduce Output Operator
key expressions:
expr: _col1
@@ -167,5 +166,5 @@
query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1056466885/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1619244792/10000
20 val_20 20
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out Wed Jul 15 01:52:41 2009
@@ -87,12 +87,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/1551152352/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1611172064/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -137,7 +136,7 @@
WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
GROUP BY src1.c2
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/455848953/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/283923095/10000
val_4 1
val_399 2
val_396 3
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Wed Jul 15 01:52:41 2009
@@ -105,12 +105,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/1497686794/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/322267744/10002
Reduce Output Operator
key expressions:
expr: _col0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Wed Jul 15 01:52:41 2009
@@ -96,7 +96,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
@@ -187,7 +186,7 @@
ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/976262349/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1593170677/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1627716724/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1412459815/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -173,7 +172,7 @@
ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/12175819/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2131288754/10000
27 val_27 2008-04-08 11 27 val_27 2008-04-08 11
27 val_27 2008-04-08 11 27 val_27 2008-04-08 12
27 val_27 2008-04-08 12 27 val_27 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out Wed Jul 15 01:52:41 2009
@@ -241,12 +241,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/1521077193/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/54303527/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -281,7 +280,7 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1366398818/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1566516401/10000
2008-04-08 11
2008-04-08 11
2008-04-08 11
@@ -445,7 +444,7 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/544471444/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/332258618/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out Wed Jul 15 01:52:41 2009
@@ -58,12 +58,12 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
- file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
- file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ 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/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Path -> Partition:
- file:/data/users/rmurthy/hive/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
@@ -82,10 +82,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/rmurthy/hive/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:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -104,10 +104,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/rmurthy/hive/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:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
partition values:
ds 2008-04-09
@@ -126,10 +126,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/rmurthy/hive/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:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
partition values:
ds 2008-04-09
@@ -148,7 +148,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/rmurthy/hive/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
Reduce Operator Tree:
@@ -175,20 +175,19 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- name binary_table
- serialization.ddl struct binary_table { string _col0, string _col1, string _col2, string _col3}
- serialization.format org.apache.thrift.protocol.TBinaryProtocol
- name: binary_table
+ columns _col0,_col1,_col2,_col3
+ columns.types string,string,string,string
+ escape.delim \
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -213,24 +212,23 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002
Path -> Partition:
- file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- name binary_table
- serialization.ddl struct binary_table { string _col0, string _col1, string _col2, string _col3}
- serialization.format org.apache.thrift.protocol.TBinaryProtocol
- name: binary_table
+ columns _col0,_col1,_col2,_col3
+ columns.types string,string,string,string
+ escape.delim \
Reduce Operator Tree:
Extract
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10001
+ directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -254,7 +252,7 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/data/users/rmurthy/hive/build/ql/tmp/673725995/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/320178544/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out Wed Jul 15 01:52:41 2009
@@ -18,8 +18,8 @@
Group By Operator
aggregations:
expr: count(UDFToInteger(''))
- expr: sum(UDFToDouble(UDFToInteger('')))
- expr: avg(UDFToDouble(UDFToInteger('')))
+ expr: sum(UDFToInteger(''))
+ expr: avg(UDFToInteger(''))
expr: min(UDFToInteger(''))
expr: max(UDFToInteger(''))
mode: hash
@@ -30,9 +30,9 @@
expr: _col0
type: bigint
expr: _col1
- type: double
+ type: bigint
expr: _col2
- type: string
+ type: struct<count:bigint,sum:double>
expr: _col3
type: int
expr: _col4
@@ -51,7 +51,7 @@
expr: _col0
type: bigint
expr: _col1
- type: double
+ type: bigint
expr: _col2
type: double
expr: _col3
@@ -84,5 +84,5 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1577421576/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/973262666/10000
0 NULL NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out Wed Jul 15 01:52:41 2009
@@ -25,8 +25,8 @@
type: string
Group By Operator
aggregations:
- expr: avg(UDFToDouble(c1))
- expr: sum(UDFToDouble(c1))
+ expr: avg(c1)
+ expr: sum(c1)
expr: count(c1)
mode: hash
Reduce Output Operator
@@ -34,7 +34,7 @@
tag: -1
value expressions:
expr: _col0
- type: string
+ type: struct<count:bigint,sum:double>
expr: _col1
type: double
expr: _col2
@@ -68,5 +68,5 @@
query: SELECT avg(c1), sum(c1), count(c1) FROM dest1
Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1344361217/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/148949332/10000
1.0 1.0 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1330132213/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/881693184/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -98,7 +97,7 @@
ON a.key = b.key
ORDER BY key LIMIT 10
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/303679320/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1098336610/10000
5
5
5
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.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/njain/hive4/hive4/build/ql/tmp/1047259223/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10002
Union
Select Operator
expressions:
@@ -86,7 +85,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1047259223/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10004
Union
Select Operator
expressions:
@@ -108,7 +107,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1047259223/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10005
Union
Select Operator
expressions:
@@ -137,10 +136,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/899550883/10000
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1900390672/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1047259223/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -205,7 +204,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-7
Map Reduce
@@ -239,7 +237,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 tmptable
@@ -252,7 +249,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1029379727/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1983301805/10000
tst1 500
tst2 500
tst3 500
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out Wed Jul 15 01:52:41 2009
@@ -51,12 +51,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/1039026532/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/615733629/10002
Union
Select Operator
expressions:
@@ -81,7 +80,7 @@
value expressions:
expr: _col1
type: bigint
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/615733629/10003
Union
Select Operator
expressions:
@@ -106,7 +105,7 @@
value expressions:
expr: _col1
type: bigint
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/615733629/10004
Union
Select Operator
expressions:
@@ -184,7 +183,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-4
Map Reduce
@@ -218,7 +216,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
@@ -231,7 +228,7 @@
UNION ALL
select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1124432682/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/498602862/10000
tst1 1
tst2 1
tst3 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.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/njain/hive4/hive4/build/ql/tmp/1811518672/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10002
Union
Select Operator
expressions:
@@ -86,7 +85,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1811518672/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10004
Union
Select Operator
expressions:
@@ -108,7 +107,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1811518672/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10005
Union
Select Operator
expressions:
@@ -137,10 +136,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1301288760/10000
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/981352387/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1811518672/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -205,7 +204,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-7
Map Reduce
@@ -239,7 +237,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 tmptable
@@ -254,7 +251,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/65502755/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/251427651/10000
tst1 500
tst2 25
tst3 1000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out Wed Jul 15 01:52:41 2009
@@ -32,12 +32,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/427160604/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1103651888/10002
Union
Select Operator
expressions:
@@ -62,7 +61,7 @@
value expressions:
expr: _col1
type: bigint
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/427160604/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1103651888/10003
Union
Select Operator
expressions:
@@ -140,7 +139,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
@@ -153,7 +151,7 @@
unionsrc group by unionsrc.key
Input: default/src1
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/332041097/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/452775957/10000
10
128 1
146 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out Wed Jul 15 01:52:41 2009
@@ -51,12 +51,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/500235306/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/44626625/10002
Union
Select Operator
expressions:
@@ -81,7 +80,7 @@
value expressions:
expr: _col1
type: bigint
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/44626625/10003
Union
Select Operator
expressions:
@@ -106,7 +105,7 @@
value expressions:
expr: _col1
type: bigint
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/44626625/10004
Union
Select Operator
expressions:
@@ -168,7 +167,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-4
Map Reduce
@@ -186,7 +184,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
@@ -200,7 +197,7 @@
select s3.key as key, s3.value as value from src1 s3) unionsrc group by unionsrc.key
Input: default/src
Input: default/src1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/439174720/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1736666761/10000
20
128 2
146 2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out Wed Jul 15 01:52:41 2009
@@ -58,12 +58,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/1604156998/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2115299971/10004
Union
Select Operator
expressions:
@@ -117,8 +116,7 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1604156998/10006
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2115299971/10006
Union
Select Operator
expressions:
@@ -172,7 +170,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:
@@ -209,7 +206,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1604156998/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2115299971/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -281,7 +278,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
@@ -294,7 +290,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/631945377/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1781230787/10000
0 1
10 1
100 1
@@ -604,10 +600,10 @@
96 1
97 1
98 1
-tst1 0
+tst1 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1564293168/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/891535145/10000
0 val_0 1
10 val_10 1
100 val_100 1
@@ -917,6 +913,6 @@
96 val_96 1
97 val_97 1
98 val_98 1
-tst1 500 0
+tst1 500 1
query: drop table DEST1
query: drop table DEST2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out Wed Jul 15 01:52:41 2009
@@ -60,12 +60,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/350775461/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10004
Union
Select Operator
expressions:
@@ -97,7 +96,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/njain/hive4/hive4/build/ql/tmp/350775461/10007
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10007
Union
Select Operator
expressions:
@@ -136,10 +135,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1724840448/10000
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1791034081/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/350775461/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -178,10 +177,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1724840448/10002
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1791034081/10002
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/350775461/10006
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10006
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -232,7 +231,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
@@ -245,7 +243,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/579835717/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/481629855/10000
0 val_0
0 val_0
0 val_0
@@ -749,7 +747,7 @@
tst1 500
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1139474399/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1239038760/10000
0 val_0 val_0
0 val_0 val_0
0 val_0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.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-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/850471669/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1000894455/10004
Union
Select Operator
expressions:
@@ -104,7 +103,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/njain/hive4/hive4/build/ql/tmp/850471669/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1000894455/10005
Union
Select Operator
expressions:
@@ -206,7 +205,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
@@ -219,7 +217,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/584098642/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1842108854/10000
0 3
10 1
100 2
@@ -532,7 +530,7 @@
tst1 1
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/106612674/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1264340998/10000
0 val_0 val_0
0 val_0 val_0
0 val_0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.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/579163613/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10002
Union
Reduce Output Operator
key expressions:
@@ -80,7 +79,7 @@
type: string
expr: _col1
type: string
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/579163613/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10003
Union
Reduce Output Operator
key expressions:
@@ -159,7 +158,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-4
Map Reduce
@@ -185,12 +183,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/pchakka/workspace/oshive/build/ql/tmp/579163613/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10004
Union
File Output Operator
compressed: false
@@ -198,8 +195,7 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
- file:/data/users/pchakka/workspace/oshive/build/ql/tmp/579163613/10006
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10006
Union
File Output Operator
compressed: false
@@ -207,7 +203,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-6
Map Reduce
@@ -241,7 +236,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
@@ -258,7 +252,7 @@
select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2
ON (unionsrc1.key = unionsrc2.key)
Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1483573814/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2027041799/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/union3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out Wed Jul 15 01:52:41 2009
@@ -64,12 +64,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/312943406/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10002
Union
Select Operator
expressions:
@@ -81,7 +80,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10003
Union
Select Operator
expressions:
@@ -93,7 +92,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10005
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10005
Union
Select Operator
expressions:
@@ -105,7 +104,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10007
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10007
Union
Select Operator
expressions:
@@ -150,7 +149,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-4
Map Reduce
@@ -184,12 +182,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/312943406/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -210,7 +207,6 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-6
Map Reduce
@@ -244,12 +240,11 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10006
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -270,7 +265,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
@@ -300,7 +294,7 @@
Output: default/union_out
query: select * from union_out cluster by id
Input: default/union_out
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1024406189/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1772585743/10000
1
2
3
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out Wed Jul 15 01:52:41 2009
@@ -53,12 +53,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/617946957/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/800954913/10002
Union
Select Operator
expressions:
@@ -80,7 +79,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive4/hive4/build/ql/tmp/617946957/10004
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/800954913/10004
Union
Select Operator
expressions:
@@ -109,10 +108,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/22706365/10000
+ destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/97307442/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/617946957/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/800954913/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -177,7 +176,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 tmptable
@@ -188,7 +186,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1336849489/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1062910028/10000
tst1 500
tst2 500
query: drop table tmptable
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out Wed Jul 15 01:52:41 2009
@@ -47,12 +47,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/788110677/10002
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/991394606/10002
Union
Select Operator
expressions:
@@ -77,7 +76,7 @@
value expressions:
expr: _col1
type: bigint
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/788110677/10003
+ file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/991394606/10003
Union
Select Operator
expressions:
@@ -155,7 +154,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
@@ -166,6 +164,6 @@
UNION ALL
select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/428835180/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/625257949/10000
tst1 1
tst2 1