You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2010/02/14 03:31:44 UTC
svn commit: r909965 [3/15] - in /hadoop/hive/trunk: ./
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Sun Feb 14 02:31:40 2010
@@ -129,10 +129,10 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [null-subquery1:a-subquery1:x, null-subquery2:a-subquery2:y]
Path -> Partition:
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -141,39 +141,39 @@
ds 2008-04-08
hr 11
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136303
+ transient_lastDdlTime 1266042226
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136303
+ transient_lastDdlTime 1266042226
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -182,35 +182,35 @@
ds 2008-04-08
hr 12
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136303
+ transient_lastDdlTime 1266042226
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136303
+ transient_lastDdlTime 1266042226
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -219,14 +219,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/203670455/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-23-47_452_4084577658557420368/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1,_col2,_col3
- serialization.format 1
columns.types string:string:string:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -242,7 +242,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/15075603/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-23-47_642_435591487763370334/10000
POSTHOOK: query: SELECT * FROM (
SELECT X.* FROM SRCPART X WHERE X.ds = '2008-04-08' and X.key < 100
UNION ALL
@@ -252,7 +252,7 @@
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/15075603/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-23-47_642_435591487763370334/10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out Sun Feb 14 02:31:40 2010
@@ -58,10 +58,10 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [x]
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [x]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [x]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [x]
Path -> Partition:
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
base file name: hr=11
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -70,39 +70,39 @@
ds 2008-04-08
hr 11
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136311
+ transient_lastDdlTime 1266042561
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136311
+ transient_lastDdlTime 1266042561
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
base file name: hr=12
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -111,35 +111,35 @@
ds 2008-04-08
hr 12
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136311
+ transient_lastDdlTime 1266042561
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name srcpart
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/test/data/warehouse/srcpart
+ name srcpart
+ partition_columns ds/hr
serialization.ddl struct srcpart { string key, string value}
serialization.format 1
- columns key,value
- partition_columns ds/hr
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
- transient_lastDdlTime 1262136311
+ transient_lastDdlTime 1266042561
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
name: srcpart
@@ -148,14 +148,14 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1850835970/10001
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-29-22_816_350956197159514250/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
columns _col0,_col1,_col2,_col3
- serialization.format 1
columns.types string:string:string:string
+ serialization.format 1
Stage: Stage-0
Fetch Operator
@@ -166,12 +166,12 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/830534543/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-29-22_924_7820685479167429194/10000
POSTHOOK: query: SELECT x.* FROM SRCPART x WHERE key IS NOT NULL AND ds = '2008-04-08' order by x.key, x.hr
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/830534543/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-29-22_924_7820685479167429194/10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out Sun Feb 14 02:31:40 2010
@@ -26,7 +26,7 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2:src
+ src1:src
TableScan
alias: src
Filter Operator
@@ -46,13 +46,13 @@
outputColumnNames: _col0, _col1
Reduce Output Operator
sort order:
- tag: 1
+ tag: 0
value expressions:
expr: _col0
type: string
expr: _col1
type: string
- src1:src
+ src2:src
TableScan
alias: src
Filter Operator
@@ -72,7 +72,7 @@
outputColumnNames: _col0, _col1
Reduce Output Operator
sort order:
- tag: 0
+ tag: 1
value expressions:
expr: _col0
type: string
@@ -108,7 +108,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1360687261/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-01_987_378847351452813940/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -152,7 +152,7 @@
SORT BY k1, v1, k2, v2
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/750163014/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-02_064_6413795495820436196/10000
POSTHOOK: query: SELECT src1.key as k1, src1.value as v1,
src2.key as k2, src2.value as v2 FROM
(SELECT * FROM src WHERE src.key < 10) src1
@@ -161,7 +161,7 @@
SORT BY k1, v1, k2, v2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/750163014/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-02_064_6413795495820436196/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/join1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join1.q.out Sun Feb 14 02:31:40 2010
@@ -22,9 +22,9 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2
+ src1
TableScan
- alias: src2
+ alias: src1
Reduce Output Operator
key expressions:
expr: key
@@ -33,13 +33,13 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
- expr: value
+ expr: key
type: string
- src1
+ src2
TableScan
- alias: src1
+ alias: src2
Reduce Output Operator
key expressions:
expr: key
@@ -48,9 +48,9 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
+ tag: 1
value expressions:
- expr: key
+ expr: value
type: string
Reduce Operator Tree:
Join Operator
@@ -108,11 +108,11 @@
PREHOOK: query: SELECT dest_j1.* FROM dest_j1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_3/build/ql/tmp/1811838516/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_3/build/ql/scratchdir/hive_2010-02-12_22-17-40_804_3249986716900995170/10000
POSTHOOK: query: SELECT dest_j1.* FROM dest_j1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j1
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_3/build/ql/tmp/1811838516/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_3/build/ql/scratchdir/hive_2010-02-12_22-17-40_804_3249986716900995170/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out Sun Feb 14 02:31:40 2010
@@ -25,28 +25,6 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2:src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col1
- type: string
src1:src
TableScan
alias: src
@@ -75,6 +53,28 @@
value expressions:
expr: _col0
type: string
+ src2:src
+ TableScan
+ alias: src
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -111,7 +111,7 @@
ON src1.c1 = src2.c3 AND src1.c1 < 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/260035292/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-24-36_568_3358492834632483667/10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
@@ -120,7 +120,7 @@
ON src1.c1 = src2.c3 AND src1.c1 < 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/260035292/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-24-36_568_3358492834632483667/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join12.q.out Sun Feb 14 02:31:40 2010
@@ -31,28 +31,6 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2:src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col1
- type: string
src1:src
TableScan
alias: src
@@ -81,6 +59,28 @@
value expressions:
expr: _col0
type: string
+ src2:src
+ TableScan
+ alias: src
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col1
+ type: string
src3:src
TableScan
alias: src
@@ -147,7 +147,7 @@
ON src1.c1 = src3.c5 AND src3.c5 < 80
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1310440418/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-14_483_6279763267526568065/10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
@@ -159,7 +159,7 @@
ON src1.c1 = src3.c5 AND src3.c5 < 80
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1310440418/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-14_483_6279763267526568065/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out Sun Feb 14 02:31:40 2010
@@ -32,30 +32,6 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2:src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
src1:src
TableScan
alias: src
@@ -84,6 +60,30 @@
value expressions:
expr: _col0
type: string
+ src2:src
+ TableScan
+ alias: src
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -182,7 +182,7 @@
ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1529824154/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-24-22_511_6362399474373258851/10000
POSTHOOK: query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
@@ -194,7 +194,7 @@
ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1529824154/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_1/build/ql/scratchdir/hive_2010-02-12_22-24-22_511_6362399474373258851/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join14.q.out Sun Feb 14 02:31:40 2010
@@ -22,16 +22,16 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- srcpart
+ src
TableScan
- alias: srcpart
+ alias: src
Filter Operator
predicate:
- expr: (ds = '2008-04-08')
+ expr: (key > 100)
type: boolean
Filter Operator
predicate:
- expr: (ds = '2008-04-08')
+ expr: (key > 100)
type: boolean
Reduce Output Operator
key expressions:
@@ -41,20 +41,20 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
- expr: value
+ expr: key
type: string
- src
+ srcpart
TableScan
- alias: src
+ alias: srcpart
Filter Operator
predicate:
- expr: (key > 100)
+ expr: (ds = '2008-04-08')
type: boolean
Filter Operator
predicate:
- expr: (key > 100)
+ expr: (ds = '2008-04-08')
type: boolean
Reduce Output Operator
key expressions:
@@ -64,9 +64,9 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
+ tag: 1
value expressions:
- expr: key
+ expr: value
type: string
Reduce Operator Tree:
Join Operator
@@ -128,11 +128,11 @@
PREHOOK: query: select dest1.* from dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1542443503/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-24-57_029_61831322772510839/10000
POSTHOOK: query: select dest1.* from dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1542443503/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-24-57_029_61831322772510839/10000
103 val_103
103 val_103
103 val_103
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out Sun Feb 14 02:31:40 2010
@@ -16,9 +16,9 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2
+ src1
TableScan
- alias: src2
+ alias: src1
Reduce Output Operator
key expressions:
expr: key
@@ -27,15 +27,15 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- src1
+ src2
TableScan
- alias: src1
+ alias: src2
Reduce Output Operator
key expressions:
expr: key
@@ -44,7 +44,7 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
+ tag: 1
value expressions:
expr: key
type: string
@@ -80,7 +80,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/212163259/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-21_183_948882797719366544/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -119,11 +119,11 @@
PREHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/2059374846/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-21_248_3435930164448606808/10000
POSTHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/2059374846/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-21_248_3435930164448606808/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/join17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join17.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join17.q.out Sun Feb 14 02:31:40 2010
@@ -22,9 +22,9 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2
+ src1
TableScan
- alias: src2
+ alias: src1
Reduce Output Operator
key expressions:
expr: key
@@ -33,15 +33,15 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- src1
+ src2
TableScan
- alias: src1
+ alias: src2
Reduce Output Operator
key expressions:
expr: key
@@ -50,7 +50,7 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
+ tag: 1
value expressions:
expr: key
type: string
@@ -58,41 +58,41 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/src [src2, src1]
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/src [src2, src1]
Path -> Partition:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name src
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/src
+ name src
serialization.ddl struct src { string key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1263595094
+ transient_lastDdlTime 1266042298
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name src
+ bucket_count -1
+ columns key,value
columns.types string:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/src
+ name src
serialization.ddl struct src { string key, string value}
serialization.format 1
- columns key,value
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1263595094
+ transient_lastDdlTime 1266042298
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -130,22 +130,22 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2068626019/10000
+ directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-24-58_888_2283102940218435935/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key1,value1,key2,value2
columns.types int:string:int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key1, string value1, i32 key2, string value2}
serialization.format 1
- columns key1,value1,key2,value2
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595094
+ transient_lastDdlTime 1266042298
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -153,25 +153,25 @@
Move Operator
tables:
replace: true
- source: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2068626019/10000
+ source: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-24-58_888_2283102940218435935/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- name dest1
+ bucket_count -1
+ columns key1,value1,key2,value2
columns.types int:string:int:string
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/test/data/warehouse/dest1
+ name dest1
serialization.ddl struct dest1 { i32 key1, string value1, i32 key2, string value2}
serialization.format 1
- columns key1,value1,key2,value2
- bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dest1
- transient_lastDdlTime 1263595094
+ transient_lastDdlTime 1266042298
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2068626019/10001
+ tmp directory: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-24-58_888_2283102940218435935/10001
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
@@ -187,11 +187,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/239373431/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-07_300_5780434119628581188/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/239373431/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-07_300_5780434119628581188/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/join19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out Sun Feb 14 02:31:40 2010
@@ -132,24 +132,22 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- t22:t2
+ t11:t1
TableScan
- alias: t2
+ alias: t1
Filter Operator
predicate:
- expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
+ expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
type: boolean
Filter Operator
predicate:
- expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
+ expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
type: boolean
Select Operator
expressions:
expr: subject
type: string
- expr: object
- type: string
- outputColumnNames: _col0, _col1
+ outputColumnNames: _col0
Reduce Output Operator
key expressions:
expr: _col0
@@ -158,20 +156,20 @@
Map-reduce partition columns:
expr: _col0
type: string
- tag: 1
+ tag: 0
value expressions:
- expr: _col1
+ expr: _col0
type: string
- t33:t3
+ t22:t2
TableScan
- alias: t3
+ alias: t2
Filter Operator
predicate:
- expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
+ expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
type: boolean
Filter Operator
predicate:
- expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
+ expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
type: boolean
Select Operator
expressions:
@@ -182,41 +180,43 @@
outputColumnNames: _col0, _col1
Reduce Output Operator
key expressions:
- expr: _col1
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: _col1
+ expr: _col0
type: string
- tag: 2
+ tag: 1
value expressions:
- expr: _col0
+ expr: _col1
type: string
- t11:t1
+ t33:t3
TableScan
- alias: t1
+ alias: t3
Filter Operator
predicate:
- expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
type: boolean
Filter Operator
predicate:
- expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Citation'))
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
type: boolean
Select Operator
expressions:
expr: subject
type: string
- outputColumnNames: _col0
+ expr: object
+ type: string
+ outputColumnNames: _col0, _col1
Reduce Output Operator
key expressions:
- expr: _col0
+ expr: _col1
type: string
sort order: +
Map-reduce partition columns:
- expr: _col0
+ expr: _col1
type: string
- tag: 0
+ tag: 2
value expressions:
expr: _col0
type: string
@@ -258,24 +258,22 @@
type: string
expr: _col2
type: string
- t55:t5
+ t44:t4
TableScan
- alias: t5
+ alias: t4
Filter Operator
predicate:
- expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
+ expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
type: boolean
Filter Operator
predicate:
- expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
+ expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
type: boolean
Select Operator
expressions:
expr: subject
type: string
- expr: object
- type: string
- outputColumnNames: _col0, _col1
+ outputColumnNames: _col0
Reduce Output Operator
key expressions:
expr: _col0
@@ -284,26 +282,25 @@
Map-reduce partition columns:
expr: _col0
type: string
- tag: 2
- value expressions:
- expr: _col1
- type: string
- t44:t4
+ tag: 1
+ t55:t5
TableScan
- alias: t4
+ alias: t5
Filter Operator
predicate:
- expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
type: boolean
Filter Operator
predicate:
- expr: ((predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__INSTANCEOF_REL') and (object = 'http://ontos/OntosMiner/Common.English/ontology#Author'))
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
type: boolean
Select Operator
expressions:
expr: subject
type: string
- outputColumnNames: _col0
+ expr: object
+ type: string
+ outputColumnNames: _col0, _col1
Reduce Output Operator
key expressions:
expr: _col0
@@ -312,7 +309,10 @@
Map-reduce partition columns:
expr: _col0
type: string
- tag: 1
+ tag: 2
+ value expressions:
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -334,6 +334,25 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
+ $INTNAME
+ Reduce Output Operator
+ key expressions:
+ expr: _col7
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col7
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col2
+ type: string
+ expr: _col4
+ type: string
+ expr: _col7
+ type: string
t66:t6
TableScan
alias: t6
@@ -364,25 +383,6 @@
value expressions:
expr: _col1
type: string
- $INTNAME
- Reduce Output Operator
- key expressions:
- expr: _col7
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col7
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
- expr: _col2
- type: string
- expr: _col4
- type: string
- expr: _col7
- type: string
Reduce Operator Tree:
Join Operator
condition map:
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out Sun Feb 14 02:31:40 2010
@@ -23,9 +23,9 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2
+ src1
TableScan
- alias: src2
+ alias: src1
Reduce Output Operator
key expressions:
expr: key
@@ -34,13 +34,13 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
expr: key
type: string
- src1
+ src2
TableScan
- alias: src1
+ alias: src2
Reduce Output Operator
key expressions:
expr: key
@@ -49,7 +49,7 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
+ tag: 1
value expressions:
expr: key
type: string
@@ -156,11 +156,11 @@
PREHOOK: query: SELECT dest_j2.* FROM dest_j2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_j2
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_3/build/ql/tmp/1881195843/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_3/build/ql/scratchdir/hive_2010-02-12_22-17-58_450_8546758638899574985/10000
POSTHOOK: query: SELECT dest_j2.* FROM dest_j2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_j2
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_3/build/ql/tmp/1881195843/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_3/build/ql/scratchdir/hive_2010-02-12_22-17-58_450_8546758638899574985/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out Sun Feb 14 02:31:40 2010
@@ -18,6 +18,31 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Filter Operator
+ predicate:
+ expr: (key < 10)
+ type: boolean
+ Filter Operator
+ predicate:
+ expr: (key < 10)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src2
TableScan
alias: src2
@@ -60,31 +85,6 @@
type: string
expr: value
type: string
- src1
- TableScan
- alias: src1
- Filter Operator
- predicate:
- expr: (key < 10)
- type: boolean
- Filter Operator
- predicate:
- expr: (key < 10)
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -121,7 +121,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/594913173/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-09_103_5553608276311636631/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -169,12 +169,12 @@
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1700561117/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-09_304_7244044251030204334/10000
POSTHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1700561117/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-09_304_7244044251030204334/10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 11 val_11
NULL NULL NULL NULL 12 val_12
@@ -263,16 +263,16 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2
+ src1
TableScan
- alias: src2
+ alias: src1
Filter Operator
predicate:
- expr: (key < 15)
+ expr: (key < 10)
type: boolean
Filter Operator
predicate:
- expr: (key < 15)
+ expr: (key < 10)
type: boolean
Reduce Output Operator
key expressions:
@@ -282,22 +282,22 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- src3
+ src2
TableScan
- alias: src3
+ alias: src2
Filter Operator
predicate:
- expr: (key < 20)
+ expr: (key < 15)
type: boolean
Filter Operator
predicate:
- expr: (key < 20)
+ expr: (key < 15)
type: boolean
Reduce Output Operator
key expressions:
@@ -307,22 +307,22 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 2
+ tag: 1
value expressions:
expr: key
type: string
expr: value
type: string
- src1
+ src3
TableScan
- alias: src1
+ alias: src3
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 20)
type: boolean
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key < 20)
type: boolean
Reduce Output Operator
key expressions:
@@ -332,7 +332,7 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
+ tag: 2
value expressions:
expr: key
type: string
@@ -374,7 +374,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/242851899/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-22_555_4999429669680122202/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -422,12 +422,12 @@
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/199285759/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-23_062_6871589272542309559/10000
POSTHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/199285759/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-23_062_6871589272542309559/10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 11 val_11
NULL NULL NULL NULL 12 val_12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out Sun Feb 14 02:31:40 2010
@@ -16,16 +16,16 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2
+ src1
TableScan
- alias: src2
+ alias: src1
Filter Operator
predicate:
- expr: (key > 10)
+ expr: (key < 10)
type: boolean
Filter Operator
predicate:
- expr: (key > 10)
+ expr: (key < 10)
type: boolean
Reduce Output Operator
key expressions:
@@ -35,22 +35,22 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- src3
+ src2
TableScan
- alias: src3
+ alias: src2
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key > 10)
type: boolean
Filter Operator
predicate:
- expr: (key < 10)
+ expr: (key > 10)
type: boolean
Reduce Output Operator
key expressions:
@@ -60,15 +60,15 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 2
+ tag: 1
value expressions:
expr: key
type: string
expr: value
type: string
- src1
+ src3
TableScan
- alias: src1
+ alias: src3
Filter Operator
predicate:
expr: (key < 10)
@@ -85,7 +85,7 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
+ tag: 2
value expressions:
expr: key
type: string
@@ -127,7 +127,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/620739292/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-50_757_6674241851636354509/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -174,11 +174,11 @@
PREHOOK: query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1999188733/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-50_859_8353481196273925065/10000
POSTHOOK: query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1999188733/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_0/build/ql/scratchdir/hive_2010-02-12_22-30-50_859_8353481196273925065/10000
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
NULL NULL NULL NULL 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out Sun Feb 14 02:31:40 2010
@@ -16,9 +16,9 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src5:src3:src2
+ src5:src3:src1
TableScan
- alias: src2
+ alias: src1
Reduce Output Operator
key expressions:
expr: key
@@ -27,10 +27,15 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 1
- src5:src3:src1
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ src5:src3:src2
TableScan
- alias: src1
+ alias: src2
Reduce Output Operator
key expressions:
expr: key
@@ -39,12 +44,7 @@
Map-reduce partition columns:
expr: key
type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ tag: 1
Reduce Operator Tree:
Join Operator
condition map:
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=909965&r1=909964&r2=909965&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out Sun Feb 14 02:31:40 2010
@@ -16,31 +16,31 @@
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src2
+ src1
TableScan
- alias: src2
+ alias: src1
Filter Operator
predicate:
expr: (key < 10)
type: boolean
Reduce Output Operator
sort order:
- tag: 1
+ tag: 0
value expressions:
expr: key
type: string
expr: value
type: string
- src1
+ src2
TableScan
- alias: src1
+ alias: src2
Filter Operator
predicate:
expr: (key < 10)
type: boolean
Reduce Output Operator
sort order:
- tag: 0
+ tag: 1
value expressions:
expr: key
type: string
@@ -80,7 +80,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/940616134/10002
+ file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-36_446_1826455278011043613/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -119,11 +119,11 @@
PREHOOK: query: SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1998501029/10000
+PREHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-36_531_8232686612566853333/10000
POSTHOOK: query: SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1998501029/10000
+POSTHOOK: Output: file:/data/users/zshao/hadoop_hive_trunk2/.ptest_2/build/ql/scratchdir/hive_2010-02-12_22-25-36_531_8232686612566853333/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0