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/12/04 05:39:52 UTC
svn commit: r887057 [4/6] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/ conf/
contrib/src/test/results/clientpositive/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/metadata/ ql/src/java/or...
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -65,6 +65,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -84,9 +85,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -100,7 +101,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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -115,8 +116,8 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1258010556
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -124,6 +125,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -139,7 +141,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10002
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -151,7 +153,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10002
Union
Common Join Operator
condition map:
@@ -194,7 +196,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -208,11 +210,11 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest_j1
- transient_lastDdlTime 1258010557
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/dest_j1
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10004
Union
Common Join Operator
condition map:
@@ -255,7 +257,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -269,8 +271,8 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest_j1
- transient_lastDdlTime 1258010557
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/dest_j1
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Local Work:
@@ -324,7 +326,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -338,16 +340,16 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest_j1
- transient_lastDdlTime 1258010557
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/dest_j1
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10002]
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10004 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10004]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10002 [file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10002]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10004 [file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10004]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -362,7 +364,7 @@
columns _col0,_col1
columns.types string,bigint
escape.delim \
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10004
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -384,11 +386,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003
- destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1012859429/10000
+ source: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1396963281/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -404,9 +406,9 @@
type: int
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003 [file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10003
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -420,8 +422,8 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest_j1
- transient_lastDdlTime 1258010557
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/dest_j1
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -436,8 +438,8 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest_j1
- transient_lastDdlTime 1258010557
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/dest_j1
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
name: dest_j1
@@ -446,7 +448,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1012859429/10000
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1396963281/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -459,9 +461,9 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest_j1
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/dest_j1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- transient_lastDdlTime 1258010557
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
@@ -469,7 +471,7 @@
Move Operator
tables:
replace: true
- source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1012859429/10000
+ source: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1396963281/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -483,11 +485,11 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/dest_j1
- transient_lastDdlTime 1258010557
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/dest_j1
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
- tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1012859429/10001
+ tmp directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1396963281/10001
Stage: Stage-6
Map Reduce
@@ -513,6 +515,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -532,9 +535,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src [null-subquery2:subq1-subquery2:x1]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src [null-subquery2:subq1-subquery2:x1]
Path -> Partition:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -548,7 +551,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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -563,8 +566,8 @@
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/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1258010556
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1258712107
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -572,6 +575,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -587,7 +591,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/763427271/10004
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176069708/10004
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -624,11 +628,11 @@
PREHOOK: query: select * from dest_j1 x order by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/519011596/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1588107383/10000
POSTHOOK: query: select * from dest_j1 x order by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/519011596/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1588107383/10000
128 3
146 val_146 2
150 val_150 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join38.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join38.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join38.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join38.q.out Fri Dec 4 04:39:37 2009
@@ -18,11 +18,11 @@
PREHOOK: query: select * from tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1628655450/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/513842932/10000
POSTHOOK: query: select * from tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1628655450/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/513842932/10000
100 101 102.0 103.0 104.0 105 106.0 107.0 108.0 109.0 110.0 111
100 101 102.0 103.0 104.0 105 106.0 107.0 108.0 109.0 110.0 111
PREHOOK: query: explain
@@ -104,7 +104,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/2083729567/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1670596765/10002
Select Operator
expressions:
expr: _col1
@@ -128,6 +128,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col1
type: string
@@ -155,6 +156,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -190,7 +192,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1273936990/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1925019467/10000
POSTHOOK: query: FROM src a JOIN tmp b ON (a.key = b.col11)
SELECT /*+ MAPJOIN(a) */ a.value, b.col5, count(1) as count
where b.col11 = 111
@@ -198,7 +200,7 @@
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/876/apache-hive/build/ql/tmp/1273936990/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1925019467/10000
val_111 105 2
PREHOOK: query: drop table tmp
PREHOOK: type: DROPTABLE
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/merge1.q.out Fri Dec 4 04:39:37 2009
@@ -38,6 +38,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -59,6 +60,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -93,10 +95,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/585401858/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1162512532/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/846450529/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/548599869/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -143,11 +145,11 @@
PREHOOK: query: select * from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/730713753/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/498103088/10000
POSTHOOK: query: select * from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/730713753/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/498103088/10000
0 3
10 1
100 2
@@ -529,10 +531,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/353161784/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/866633278/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2091577421/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/971651244/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -615,10 +617,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1533278841/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/446507348/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1738586251/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1911673641/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Fri Dec 4 04:39:37 2009
@@ -41,6 +41,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -62,6 +63,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -118,11 +120,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1113537326/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/573546507/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1113537326/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/573546507/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Fri Dec 4 04:39:37 2009
@@ -41,6 +41,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -62,6 +63,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -118,11 +120,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/18460415/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1079706949/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/18460415/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1079706949/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -30,6 +30,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -42,6 +43,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: final
outputColumnNames: _col0
Select Operator
@@ -64,11 +66,11 @@
PREHOOK: query: select count(1) from src x where x.key > 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/306583345/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/833754505/10000
POSTHOOK: query: select count(1) from src x where x.key > 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/306583345/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/833754505/10000
0
PREHOOK: query: explain
select count(1) from src x where x.key > 9999
@@ -102,6 +104,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -114,6 +117,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -136,11 +140,11 @@
PREHOOK: query: select count(1) from src x where x.key > 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/975282783/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1463633983/10000
POSTHOOK: query: select count(1) from src x where x.key > 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/975282783/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1463633983/10000
0
PREHOOK: query: explain
select count(1) from src x where x.key > 9999
@@ -185,6 +189,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: partial1
outputColumnNames: _col0
File Output Operator
@@ -197,7 +202,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/321134863/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1175734472/10002
Reduce Output Operator
sort order:
tag: -1
@@ -208,6 +213,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: final
outputColumnNames: _col0
Select Operator
@@ -230,11 +236,11 @@
PREHOOK: query: select count(1) from src x where x.key > 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1134965962/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1110622860/10000
POSTHOOK: query: select count(1) from src x where x.key > 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1134965962/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1110622860/10000
0
PREHOOK: query: explain
select count(1) from src x where x.key > 9999
@@ -275,6 +281,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: complete
outputColumnNames: _col0
Select Operator
@@ -297,9 +304,9 @@
PREHOOK: query: select count(1) from src x where x.key > 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2046297028/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1442417263/10000
POSTHOOK: query: select count(1) from src x where x.key > 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2046297028/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1442417263/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -35,6 +35,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -56,6 +57,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -71,7 +73,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/189886980/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/891593089/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -88,6 +90,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -115,11 +118,11 @@
PREHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2132690107/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1142408144/10000
POSTHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2132690107/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1142408144/10000
PREHOOK: query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
PREHOOK: type: QUERY
@@ -156,6 +159,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -177,6 +181,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -204,11 +209,11 @@
PREHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/974062609/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/337069177/10000
POSTHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/974062609/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/337069177/10000
PREHOOK: query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
PREHOOK: type: QUERY
@@ -259,6 +264,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -274,7 +280,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/410784102/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1010606542/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -291,6 +297,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -318,11 +325,11 @@
PREHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1309754539/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1970002416/10000
POSTHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1309754539/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1970002416/10000
PREHOOK: query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
PREHOOK: type: QUERY
@@ -372,6 +379,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -399,8 +407,8 @@
PREHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/308930337/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1471005828/10000
POSTHOOK: query: select x.key, count(1) from src x where x.key > 9999 group by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/308930337/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1471005828/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out Fri Dec 4 04:39:37 2009
@@ -41,6 +41,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -53,6 +54,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -76,12 +78,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl@ds=2008-04-08
PREHOOK: Input: default@tstparttbl@ds=2008-04-09
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2074178114/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/429292939/10000
POSTHOOK: query: select count(1) from tstparttbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2074178114/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/429292939/10000
500
PREHOOK: query: DROP TABLE tstparttbl2
PREHOOK: type: DROPTABLE
@@ -126,6 +128,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -138,6 +141,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -161,12 +165,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/743975327/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/675788842/10000
POSTHOOK: query: select count(1) from tstparttbl2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/743975327/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/675788842/10000
0
PREHOOK: query: DROP TABLE tstparttbl
PREHOOK: type: DROPTABLE
@@ -212,6 +216,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -224,6 +229,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -247,12 +253,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl@ds=2008-04-08
PREHOOK: Input: default@tstparttbl@ds=2008-04-09
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1477820236/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1506435272/10000
POSTHOOK: query: select count(1) from tstparttbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1477820236/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1506435272/10000
500
PREHOOK: query: DROP TABLE tstparttbl2
PREHOOK: type: DROPTABLE
@@ -298,6 +304,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -310,6 +317,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -333,12 +341,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/816722653/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1727986109/10000
POSTHOOK: query: select count(1) from tstparttbl2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/816722653/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1727986109/10000
0
PREHOOK: query: DROP TABLE tstparttbl
PREHOOK: type: DROPTABLE
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -36,6 +36,7 @@
aggregations:
expr: count(1)
expr: count(DISTINCT value)
+ bucketGroup: false
keys:
expr: value
type: string
@@ -60,6 +61,7 @@
aggregations:
expr: count(VALUE._col0)
expr: count(DISTINCT KEY._col0)
+ bucketGroup: false
mode: partials
outputColumnNames: _col0, _col1
File Output Operator
@@ -72,7 +74,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1567123524/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1078244463/10002
Reduce Output Operator
sort order:
tag: -1
@@ -86,6 +88,7 @@
aggregations:
expr: count(VALUE._col0)
expr: count(VALUE._col1)
+ bucketGroup: false
mode: final
outputColumnNames: _col0, _col1
Select Operator
@@ -110,11 +113,11 @@
PREHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/223672369/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1320116542/10000
POSTHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/223672369/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1320116542/10000
0 0
PREHOOK: query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -153,6 +156,7 @@
aggregations:
expr: count(1)
expr: count(DISTINCT value)
+ bucketGroup: false
keys:
expr: value
type: string
@@ -174,6 +178,7 @@
aggregations:
expr: count(VALUE._col0)
expr: count(DISTINCT KEY._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0, _col1
Select Operator
@@ -198,11 +203,11 @@
PREHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/302365134/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1581992443/10000
POSTHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/302365134/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1581992443/10000
0 0
PREHOOK: query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -255,6 +260,7 @@
aggregations:
expr: count(VALUE._col0)
expr: count(DISTINCT KEY._col0)
+ bucketGroup: false
mode: partial1
outputColumnNames: _col0, _col1
File Output Operator
@@ -267,7 +273,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1614683110/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2079943303/10002
Reduce Output Operator
sort order:
tag: -1
@@ -281,6 +287,7 @@
aggregations:
expr: count(VALUE._col0)
expr: count(VALUE._col1)
+ bucketGroup: false
mode: final
outputColumnNames: _col0, _col1
Select Operator
@@ -305,11 +312,11 @@
PREHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1454983724/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/467050607/10000
POSTHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1454983724/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/467050607/10000
0 0
PREHOOK: query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -358,6 +365,7 @@
aggregations:
expr: count(VALUE._col0)
expr: count(DISTINCT KEY._col0)
+ bucketGroup: false
mode: complete
outputColumnNames: _col0, _col1
Select Operator
@@ -382,9 +390,9 @@
PREHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1653936568/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/681114349/10000
POSTHOOK: query: select count(1), count(distinct x.value) from src x where x.key = 9999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1653936568/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/681114349/10000
0 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out Fri Dec 4 04:39:37 2009
@@ -42,6 +42,7 @@
Group By Operator
aggregations:
expr: count(key)
+ bucketGroup: false
keys:
expr: value
type: string
@@ -63,6 +64,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -102,14 +104,14 @@
WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400')
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/923831787/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2057520929/10000
POSTHOOK: query: SELECT src1.c1
FROM
(SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/923831787/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2057520929/10000
val_201
val_202
val_203
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -45,6 +45,7 @@
Group By Operator
aggregations:
expr: count(key)
+ bucketGroup: false
keys:
expr: value
type: string
@@ -66,6 +67,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -92,6 +94,7 @@
Group By Operator
aggregations:
expr: max(_col0)
+ bucketGroup: false
keys:
expr: _col1
type: bigint
@@ -107,7 +110,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/2124762740/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1708527216/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -124,6 +127,7 @@
Group By Operator
aggregations:
expr: max(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: bigint
@@ -155,7 +159,7 @@
GROUP BY src1.c2
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2121512622/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1771662729/10000
POSTHOOK: query: SELECT max(src1.c1), src1.c2
FROM
(SELECT src.value AS c1, count(src.key) AS c2 FROM src WHERE src.value > 'val_10' GROUP BY src.value) src1
@@ -163,7 +167,7 @@
GROUP BY src1.c2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/2121512622/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1771662729/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -114,6 +114,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -129,7 +130,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/348623644/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/345561860/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -146,6 +147,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out Fri Dec 4 04:39:37 2009
@@ -24,11 +24,11 @@
PREHOOK: query: select * from t1 sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1950048944/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1860298432/10000
POSTHOOK: query: select * from t1 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1950048944/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1860298432/10000
0 val_0
0 val_0
0 val_0
@@ -50,11 +50,11 @@
PREHOOK: query: select * from t2 sort by key
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/879618352/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/235720982/10000
POSTHOOK: query: select * from t2 sort by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/879618352/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/235720982/10000
0 val_0
0 val_0
0 val_0
@@ -78,11 +78,11 @@
PREHOOK: query: select * from t3 sort by key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1190077391/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1672196650/10000
POSTHOOK: query: select * from t3 sort by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1190077391/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1672196650/10000
0 val_0
0 val_0
0 val_0
@@ -113,11 +113,11 @@
PREHOOK: query: select * from t4
PREHOOK: type: QUERY
PREHOOK: Input: default@t4
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/2091463185/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2113785466/10000
POSTHOOK: query: select * from t4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t4
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/2091463185/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2113785466/10000
PREHOOK: query: explain select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
@@ -143,6 +143,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -199,7 +200,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1584585921/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/721833201/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -231,12 +232,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1402980641/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1834571355/10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key=b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1402980641/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1834571355/10000
0 val_0
0 val_0
0 val_0
@@ -268,6 +269,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -324,7 +326,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/445022614/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1387501870/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -356,12 +358,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1376052169/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/660184449/10000
POSTHOOK: query: select * from t2 a left semi join t1 b on b.key=a.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1376052169/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/660184449/10000
0 val_0
0 val_0
0 val_0
@@ -395,6 +397,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -451,7 +454,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/520117018/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/416754588/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -483,12 +486,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t4
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1998061741/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/138871132/10000
POSTHOOK: query: select * from t1 a left semi join t4 b on b.key=a.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t4
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1998061741/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/138871132/10000
PREHOOK: query: explain select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
@@ -522,6 +525,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -576,7 +580,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1764299178/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/489398161/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -604,12 +608,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t3
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/396801905/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/802843404/10000
POSTHOOK: query: select a.value from t1 a left semi join t3 b on (b.key = a.key and b.key < '15') sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/396801905/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/802843404/10000
val_0
val_0
val_0
@@ -656,6 +660,7 @@
type: string
outputColumnNames: key, value
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -714,7 +719,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/30581150/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1424338560/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -746,12 +751,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1616679133/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/249026043/10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key = b.key and b.value < "val_10" sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1616679133/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/249026043/10000
0 val_0
0 val_0
0 val_0
@@ -808,6 +813,7 @@
type: int
outputColumnNames: _col0
Group By Operator
+ bucketGroup: false
keys:
expr: _col0
type: int
@@ -845,7 +851,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1460410480/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/994124380/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -873,12 +879,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1828138230/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/301375965/10000
POSTHOOK: query: select a.value from t1 a left semi join (select key from t3 where key > 5) b on a.key = b.key sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1828138230/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/301375965/10000
val_10
val_8
val_9
@@ -928,6 +934,7 @@
type: string
outputColumnNames: _col0, _col1
Group By Operator
+ bucketGroup: false
keys:
expr: _col0
type: int
@@ -982,7 +989,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/248757445/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1278601785/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1010,12 +1017,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/731443447/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1307756283/10000
POSTHOOK: query: select a.value from t1 a left semi join (select key , value from t2 where key > 5) b on a.key = b.key and b.value <= 'val_20' sort by a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/731443447/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1307756283/10000
PREHOOK: query: explain select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
@@ -1054,6 +1061,7 @@
type: int
outputColumnNames: _col0
Group By Operator
+ bucketGroup: false
keys:
expr: _col0
type: int
@@ -1110,7 +1118,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/632635454/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/650280148/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1142,12 +1150,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/919131296/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1337909566/10000
POSTHOOK: query: select * from t2 a left semi join (select key , value from t1 where key > 2) b on a.key = b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/919131296/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1337909566/10000
4 val_2
8 val_4
10 val_5
@@ -1205,6 +1213,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -1231,7 +1240,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1372344917/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1502786844/10002
Select Operator
expressions:
expr: _col0
@@ -1269,12 +1278,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1282221395/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/956596787/10000
POSTHOOK: query: select /*+ mapjoin(b) */ a.key from t3 a left semi join t1 b on a.key = b.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1282221395/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/956596787/10000
0
0
0
@@ -1319,6 +1328,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -1375,7 +1385,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1406555470/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1944075529/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1407,12 +1417,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1983028259/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2044127216/10000
POSTHOOK: query: select * from t1 a left semi join t2 b on a.key = 2*b.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1983028259/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2044127216/10000
0 val_0
0 val_0
0 val_0
@@ -1459,6 +1469,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -1521,7 +1532,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1409329788/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/938541959/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1558,13 +1569,13 @@
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/538899761/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/254520600/10000
POSTHOOK: query: select * from t1 a join t2 b on a.key = b.key left semi join t3 c on b.key = c.key sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/538899761/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/254520600/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
@@ -1606,6 +1617,7 @@
type: string
outputColumnNames: key, value
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -1672,7 +1684,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1665175195/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/179874181/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -1704,12 +1716,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1100358804/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1349295913/10000
POSTHOOK: query: select * from t3 a left semi join t1 b on a.key = b.key and a.value=b.value sort by a.key, a.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1100358804/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1349295913/10000
0 val_0
0 val_0
0 val_0
@@ -1782,6 +1794,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -1816,6 +1829,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -1845,7 +1859,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/266768814/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/144703073/10002
Select Operator
expressions:
expr: _col0
@@ -1884,13 +1898,13 @@
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/316234007/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/483454873/10000
POSTHOOK: query: select /*+ mapjoin(b, c) */ a.key from t3 a left semi join t1 b on a.key = b.key left semi join t2 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/316234007/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/483454873/10000
0
0
0
@@ -1942,6 +1956,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -1996,7 +2011,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/703993783/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1776975919/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2025,13 +2040,13 @@
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/2111589900/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1305325861/10000
POSTHOOK: query: select a.key from t3 a left outer join t1 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/2111589900/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1305325861/10000
0
0
0
@@ -2095,6 +2110,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -2149,7 +2165,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/613754490/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1724932302/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2178,13 +2194,13 @@
PREHOOK: Input: default@t3
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1309887313/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2077718744/10000
POSTHOOK: query: select a.key from t1 a right outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1309887313/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2077718744/10000
NULL
NULL
NULL
@@ -2251,6 +2267,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -2305,7 +2322,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1190356409/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1208550141/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2334,13 +2351,13 @@
PREHOOK: Input: default@t3
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/5765647/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1726316291/10000
POSTHOOK: query: select a.key from t1 a full outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/5765647/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1726316291/10000
NULL
NULL
NULL
@@ -2395,6 +2412,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -2461,7 +2479,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/501544582/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1389408048/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2490,13 +2508,13 @@
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1848611381/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/442645926/10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1848611381/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/442645926/10000
0
0
0
@@ -2551,6 +2569,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -2617,7 +2636,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1252335854/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1305395524/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2646,13 +2665,13 @@
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/408133570/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/856536199/10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key right outer join t1 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/408133570/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/856536199/10000
NULL
NULL
NULL
@@ -2709,6 +2728,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -2775,7 +2795,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1627876440/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1553440978/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -2804,13 +2824,13 @@
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/604856063/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2113266921/10000
POSTHOOK: query: select a.key from t3 a left semi join t1 b on a.key = b.key full outer join t2 c on a.key = c.key sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/604856063/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2113266921/10000
NULL
NULL
NULL
@@ -2879,6 +2899,7 @@
type: int
outputColumnNames: key
Group By Operator
+ bucketGroup: false
keys:
expr: key
type: int
@@ -2976,7 +2997,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/509263729/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/125297931/10003
Reduce Output Operator
key expressions:
expr: _col0
@@ -3005,13 +3026,13 @@
PREHOOK: Input: default@t2
PREHOOK: Input: default@t1
PREHOOK: Input: default@t3
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/990086878/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1578918637/10000
POSTHOOK: query: select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.value = c.value sort by a.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t3
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/990086878/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1578918637/10000
0
0
0