You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by zs...@apache.org on 2009/06/24 06:05:05 UTC
svn commit: r787898 [2/19] - in /hadoop/hive/trunk: ./ conf/
ql/src/java/org/apache/hadoop/hive/ql/ppd/
ql/src/test/results/clientpositive/ ql/src/test/results/compiler/plan/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Wed Jun 24 04:05:02 2009
@@ -19,51 +19,55 @@
predicate:
expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12'))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: hr
- type: string
- expr: ds
- type: string
+ Filter Operator
+ predicate:
+ expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12'))
+ type: boolean
Select Operator
expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
+ expr: key
type: string
- expr: _col2
+ expr: value
type: string
- expr: _col3
+ expr: hr
type: string
- File Output Operator
- compressed: false
- GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1937457623/10002
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name dest1
- columns.types int:string:string:string
- serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
- serialization.format 1
- columns key,value,hr,ds
- 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/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
+ expr: ds
+ type: string
+ Select Operator
+ expressions:
+ expr: UDFToInteger(_col0)
+ type: int
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/700297246/10002
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string:string:string
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ columns key,value,hr,ds
+ 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/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -82,7 +86,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -92,11 +96,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1937457623/10002
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1763689625/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/700297246/10002
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1780771114/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1937457623/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/700297246/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -114,9 +118,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1937457623/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/700297246/10002
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1937457623/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/700297246/10002
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -131,7 +135,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Reduce Operator Tree:
@@ -139,7 +143,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1763689625/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1780771114/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -153,7 +157,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -161,7 +165,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1763689625/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1780771114/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -175,10 +179,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1763689625/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1780771114/10001
query: FROM srcpart
@@ -187,7 +191,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1448496184/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/708383510/10000
86 val_86 12 2008-04-08
27 val_27 12 2008-04-08
98 val_98 12 2008-04-08
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out Wed Jun 24 04:05:02 2009
@@ -20,24 +20,28 @@
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmptable
+ Filter Operator
+ predicate:
+ expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
Stage: Stage-4
Conditional Operator
@@ -45,10 +49,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1707984985/10000
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1706524431/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1200944144/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/183636127/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -93,7 +97,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
Input: default/tmptable
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1468524643/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/936899817/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_part6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out Wed Jun 24 04:05:02 2009
@@ -16,23 +16,27 @@
predicate:
expr: (UDFToDouble(ds) = UDFToDouble(((2008 - 4) - 8)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(ds) = UDFToDouble(((2008 - 4) - 8)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
@@ -44,4 +48,4 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/179055439/17842475.10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/495001163/10000
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=787898&r1=787897&r2=787898&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 Wed Jun 24 04:05:02 2009
@@ -21,34 +21,23 @@
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- Union
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- tag: -1
- value expressions:
+ Filter Operator
+ predicate:
+ expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ Union
+ Select Operator
+ expressions:
expr: _col0
type: string
expr: _col1
@@ -57,39 +46,43 @@
type: string
expr: _col3
type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
null-subquery2:a-subquery2:y
Filter Operator
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
- Union
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- tag: -1
- value expressions:
+ Filter Operator
+ predicate:
+ expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
+ Union
+ Select Operator
+ expressions:
expr: _col0
type: string
expr: _col1
@@ -98,12 +91,27 @@
type: string
expr: _col3
type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ expr: _col3
+ type: string
Needs Tagging: false
Path -> Alias:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -122,10 +130,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -144,7 +152,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -152,7 +160,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/12007688/10001
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1425223263/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -173,7 +181,7 @@
SORT BY A.key
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/257008920/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1631529589/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_testxpath2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath2.q.out Wed Jun 24 04:05:02 2009
@@ -19,22 +19,26 @@
predicate:
expr: (lint is not null and not mstringstring is null)
type: boolean
- Select Operator
- expressions:
- expr: size(lint)
- type: int
- expr: size(lintstring)
- type: int
- expr: size(mstringstring)
- type: int
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
+ Filter Operator
+ predicate:
+ expr: (lint is not null and not mstringstring is null)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: size(lint)
+ type: int
+ expr: size(lintstring)
+ type: int
+ expr: size(mstringstring)
+ type: int
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
Stage: Stage-4
Conditional Operator
@@ -42,10 +46,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1510428322/10000
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1796327141/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/179419280/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1492277620/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -87,7 +91,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1999543379/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1273440758/10000
3 1 1
3 1 1
3 1 1
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=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out Wed Jun 24 04:05:02 2009
@@ -22,39 +22,47 @@
predicate:
expr: (UDFToDouble(key) < UDFToDouble(10))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- sort order:
- tag: 1
- value expressions:
- expr: _col0
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
type: string
- expr: _col1
+ expr: value
type: string
+ Reduce Output Operator
+ sort order:
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
src1:src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(10))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- sort order:
- tag: 0
- value expressions:
- expr: _col0
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
type: string
- expr: _col1
+ expr: value
type: string
+ Reduce Output Operator
+ sort order:
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -83,7 +91,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1169065671/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1881512857/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -126,7 +134,7 @@
(SELECT * FROM src WHERE src.key < 10) src2
SORT BY k1, v1, k2, v2
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1831934555/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/905222648/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/join11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join11.q.out?rev=787898&r1=787897&r2=787898&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 Wed Jun 24 04:05:02 2009
@@ -38,26 +38,30 @@
expr: _col1
type: string
src1:src
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(100))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -90,7 +94,7 @@
(SELECT src.key as c3, src.value as c4 from src) src2
ON src1.c1 = src2.c3 AND src1.c1 < 100
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/760194900/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1092092252/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=787898&r1=787897&r2=787898&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 Wed Jun 24 04:05:02 2009
@@ -41,47 +41,55 @@
expr: _col1
type: string
src1:src
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(100))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
src3:src
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(80))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 2
- value expressions:
- expr: _col0
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(80))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(_col0) < UDFToDouble(80))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 2
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -108,6 +116,7 @@
Fetch Operator
limit: -1
+
query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
@@ -118,7 +127,7 @@
(SELECT src.key as c5, src.value as c6 from src) src3
ON src1.c1 = src3.c5 AND src3.c5 < 80
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/827709570/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2007793008/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=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out Wed Jun 24 04:05:02 2009
@@ -42,26 +42,30 @@
expr: _col1
type: string
src1:src
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(100))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -100,26 +104,30 @@
expr: _col1
type: string
src3:src
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(200))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: UDFToDouble(_col0)
- type: double
- sort order: +
- Map-reduce partition columns:
- expr: UDFToDouble(_col0)
- type: double
- tag: 1
- value expressions:
- expr: _col0
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(200))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(_col0) < UDFToDouble(200))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: UDFToDouble(_col0)
+ type: double
+ sort order: +
+ Map-reduce partition columns:
+ expr: UDFToDouble(_col0)
+ type: double
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -155,7 +163,7 @@
(SELECT src.key as c5, src.value as c6 from src) src3
ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1501948781/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1162005483/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=787898&r1=787897&r2=787898&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 Wed Jun 24 04:05:02 2009
@@ -18,43 +18,51 @@
predicate:
expr: (ds = '2008-04-08')
type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
+ Filter Operator
+ predicate:
+ expr: (ds = '2008-04-08')
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
src
Filter Operator
predicate:
expr: (UDFToDouble(key) > UDFToDouble(100))
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
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(100))
+ 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:
@@ -102,7 +110,7 @@
Output: default/dest1
query: select dest1.* from dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/714212122/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/285954832/10000
103 val_103
103 val_103
103 val_103
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out Wed Jun 24 04:05:02 2009
@@ -13,55 +13,63 @@
subq:a
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(10))
+ expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) > UDFToDouble(20)))
type: boolean
- Select Operator
- expressions:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(10))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(_col0) > UDFToDouble(20))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ tab
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(value) < UDFToDouble(200))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ tag: 1
+ value expressions:
expr: key
type: string
expr: value
type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(_col0) > UDFToDouble(20))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- sort order: ++
- Map-reduce partition columns:
- expr: _col0
- type: string
- expr: _col1
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- tab
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- expr: value
- type: string
- sort order: ++
- Map-reduce partition columns:
- expr: key
- type: string
- expr: value
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
Reduce Operator Tree:
Join Operator
condition map:
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=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out Wed Jun 24 04:05:02 2009
@@ -73,72 +73,84 @@
predicate:
expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- 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
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ 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
t33:t3
Filter Operator
predicate:
expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col1
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col1
- type: string
- tag: 2
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_from')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col1
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col1
+ type: string
+ tag: 2
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
t11:t1
Filter Operator
predicate:
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
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
+ Filter Operator
+ predicate:
+ 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
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -185,47 +197,55 @@
predicate:
expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 2
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://www.ontosearch.com/2007/12/ontosofa-ns#_to')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 2
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
t44:t4
Filter Operator
predicate:
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
- 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
+ Filter Operator
+ predicate:
+ 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
+ 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
Reduce Operator Tree:
Join Operator
condition map:
@@ -251,26 +271,30 @@
predicate:
expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
type: boolean
- Select Operator
- expressions:
- expr: subject
- type: string
- expr: object
- type: string
- 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
+ Filter Operator
+ predicate:
+ expr: (predicate = 'http://sofa.semanticweb.org/sofa/v1.0/system#__LABEL_REL')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: subject
+ type: string
+ expr: object
+ type: string
+ 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
$INTNAME
Reduce Output Operator
key expressions:
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=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out Wed Jun 24 04:05:02 2009
@@ -33,39 +33,47 @@
predicate:
expr: (UDFToDouble(key) < UDFToDouble(20))
type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 2
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(20))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 2
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src1
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(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
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(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:
@@ -100,7 +108,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/692540423/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/281582968/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -147,7 +155,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/354547535/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/105019591/10000
NULL NULL NULL NULL 10 val_10
NULL NULL NULL NULL 11 val_11
NULL NULL NULL NULL 12 val_12
@@ -236,58 +244,70 @@
predicate:
expr: (UDFToDouble(key) < UDFToDouble(15))
type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(15))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src3
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(20))
type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 2
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(20))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 2
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src1
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(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
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(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:
@@ -322,7 +342,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1426415485/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1417429723/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -369,7 +389,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/996575325/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1953761211/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=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out Wed Jun 24 04:05:02 2009
@@ -17,58 +17,70 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(10))
type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(10))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src3
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(10))
type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 2
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 2
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src1
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(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
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(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:
@@ -103,7 +115,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1871738284/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/14709034/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -149,7 +161,7 @@
query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1337202380/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/808695063/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/join23.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out Wed Jun 24 04:05:02 2009
@@ -13,23 +13,31 @@
Map Reduce
Alias -> Map Operator Tree:
src2
- Reduce Output Operator
- sort order:
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Reduce Output Operator
+ sort order:
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src1
- Reduce Output Operator
- sort order:
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Reduce Output Operator
+ sort order:
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -62,7 +70,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/30533864/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/283776935/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -100,7 +108,7 @@
query: SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/872178280/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/334248421/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0