You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2009/06/15 07:43:29 UTC
svn commit: r784656 [5/30] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/java/or...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out Mon Jun 15 05:43:22 2009
@@ -14,34 +14,30 @@
Map Reduce
Alias -> Map Operator Tree:
src1
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (null = null)
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (null = null)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: null
+ type: string
+ expr: key
+ type: string
Select Operator
expressions:
- expr: null
- type: string
- expr: 0
- type: string
- Select Operator
- expressions:
- expr: 0
- type: void
- expr: UDFToInteger(1)
- 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
+ expr: _col0
+ type: void
+ expr: UDFToInteger(_col1)
+ 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-0
Move Operator
@@ -60,4 +56,4 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/170480320/543316931.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/116842121/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out Mon Jun 15 05:43:22 2009
@@ -32,35 +32,23 @@
type: int
expr: astring
type: string
- Select Operator
- expressions:
- expr: 0
- type: array<int>
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
expr: 1
+ type: int
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: array<int>
+ expr: _col1
type: array<string>
- expr: 2
+ expr: _col2
type: map<string,string>
- expr: 3
+ expr: _col3
type: int
- expr: 4
+ expr: _col4
type: string
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: 1
- type: int
- tag: -1
- value expressions:
- expr: 0
- type: array<int>
- expr: 1
- type: array<string>
- expr: 2
- type: map<string,string>
- expr: 3
- type: int
- expr: 4
- type: string
Reduce Operator Tree:
Extract
File Output Operator
@@ -89,7 +77,7 @@
Output: default/input_columnarserde
query: SELECT input_columnarserde.* FROM input_columnarserde DISTRIBUTE BY 1
Input: default/input_columnarserde
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/156914955/60209819.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/545096986/10000
[0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0
[1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1
[2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2
@@ -103,7 +91,7 @@
null null {} 0 NULL
query: SELECT input_columnarserde.a[0], input_columnarserde.b[0], input_columnarserde.c['key2'], input_columnarserde.d, input_columnarserde.e FROM input_columnarserde DISTRIBUTE BY 1
Input: default/input_columnarserde
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/92131046/797096690.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/795399832/10000
0 0 NULL 1712634731 record_0
1 10 NULL 465985200 record_1
2 20 NULL -751827638 record_2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out Mon Jun 15 05:43:22 2009
@@ -32,26 +32,14 @@
type: int
expr: astring
type: string
- Select Operator
- expressions:
- expr: 0
- type: array<int>
- expr: 1
- type: array<string>
- expr: 2
- type: map<string,string>
- expr: 3
- type: int
- expr: 4
- 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: dest1
+ 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-0
Move Operator
@@ -70,7 +58,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1346296798/44273868.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1829636332/10000
[0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0
[1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1
[2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2
@@ -84,7 +72,7 @@
null null null 0 NULL
query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/373980247/133405459.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1355346480/10000
0 0 NULL 1712634731 record_0
1 10 NULL 465985200 record_1
2 20 NULL -751827638 record_2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out Mon Jun 15 05:43:22 2009
@@ -32,35 +32,23 @@
type: int
expr: astring
type: string
- Select Operator
- expressions:
- expr: 0
- type: array<int>
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
expr: 1
+ type: int
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: array<int>
+ expr: _col1
type: array<string>
- expr: 2
+ expr: _col2
type: map<string,string>
- expr: 3
+ expr: _col3
type: int
- expr: 4
+ expr: _col4
type: string
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: 1
- type: int
- tag: -1
- value expressions:
- expr: 0
- type: array<int>
- expr: 1
- type: array<string>
- expr: 2
- type: map<string,string>
- expr: 3
- type: int
- expr: 4
- type: string
Reduce Operator Tree:
Extract
File Output Operator
@@ -89,7 +77,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1171779134/134105295.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1749318002/10000
[0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0
[1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1
[2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2
@@ -103,7 +91,7 @@
null null null 0 NULL
query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 DISTRIBUTE BY 1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/89505780/102961275.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1914165641/10000
0 0 NULL 1712634731 record_0
1 10 NULL 465985200 record_1
2 20 NULL -751827638 record_2
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -30,18 +30,18 @@
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/193974541/25724604.10000.insclause-0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2121258752/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -55,14 +55,14 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -81,7 +81,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -89,7 +89,7 @@
Move Operator
tables:
replace: true
- source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/193974541/25724604.10000.insclause-0
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2121258752/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -103,10 +103,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/193974541/25724604.10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2121258752/10001
query: FROM srcpart
@@ -115,7 +115,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/405215409/117459934.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/833555359/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_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Mon Jun 15 05:43:22 2009
@@ -32,18 +32,18 @@
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10000.insclause-0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1525759137/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -57,7 +57,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Filter Operator
@@ -76,18 +76,18 @@
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
GlobalTableId: 2
- directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10002.insclause-1
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1525759137/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -101,15 +101,15 @@
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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest2
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest2
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
Needs Tagging: false
Path -> Alias:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -128,10 +128,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
partition values:
ds 2008-04-09
@@ -150,7 +150,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -158,7 +158,7 @@
Move Operator
tables:
replace: true
- source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10000.insclause-0
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1525759137/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -172,12 +172,12 @@
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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1525759137/10001
replace: true
- source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10002.insclause-1
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1525759137/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -191,10 +191,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest2
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest2
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10003
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1525759137/10003
query: FROM srcpart
@@ -206,7 +206,7 @@
Output: default/dest2
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/70176811/211325652.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/376262491/10000
86 val_86 12 2008-04-08
27 val_27 12 2008-04-08
98 val_98 12 2008-04-08
@@ -293,7 +293,7 @@
97 val_97 12 2008-04-08
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/683955421/596380888.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1553316848/10000
86 val_86 12 2008-04-09
27 val_27 12 2008-04-09
98 val_98 12 2008-04-09
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -34,28 +34,28 @@
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
null-subquery2:a-subquery2:y
Filter Operator
@@ -75,35 +75,35 @@
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ 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
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws8/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=11
Partition
partition values:
ds 2008-04-08
@@ -122,10 +122,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -144,7 +144,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -152,7 +152,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1008455822/140279174.10001.insclause-0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/12007688/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -173,7 +173,7 @@
SORT BY A.key
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/293202813/2015995.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/257008920/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_testsequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testsequencefile.q.out Mon Jun 15 05:43:22 2009
@@ -22,9 +22,9 @@
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -52,7 +52,7 @@
Output: default/dest4_sequencefile
query: SELECT dest4_sequencefile.* FROM dest4_sequencefile
Input: default/dest4_sequencefile
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/225942313/58999367.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1884409333/10000
238 val_238
86 val_86
311 val_311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath.q.out Mon Jun 15 05:43:22 2009
@@ -16,28 +16,20 @@
src_thrift
Select Operator
expressions:
- expr: lint
- type: array<int>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- expr: mstringstring
- type: map<string,string>
- Select Operator
- expressions:
- expr: 0[1]
- type: int
- expr: 1[0].mystring
- type: string
- expr: 2['key_2']
- 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: dest1
+ expr: lint[1]
+ type: int
+ expr: lintstring[0].mystring
+ type: string
+ expr: mstringstring['key_2']
+ 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: dest1
Stage: Stage-0
Move Operator
@@ -56,7 +48,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/zshao/tools/495-trunk-apache-hive/ql/../build/ql/tmp/600192558/110692382.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/668433719/10000
0 0 NULL
2 1 NULL
4 8 value_2
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -14,34 +14,26 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
- Select Operator
- expressions:
- expr: lint
- type: array<int>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- expr: mstringstring
- type: map<string,string>
- Filter Operator
- predicate:
- expr: (0 is not null and not 2 is null)
- type: boolean
- Select Operator
- expressions:
- expr: size(0)
- type: int
- expr: size(1)
- type: int
- expr: size(2)
- 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-0
Move Operator
@@ -60,7 +52,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/zshao/tools/495-trunk-apache-hive/ql/../build/ql/tmp/108328031/145804882.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/333952590/10000
3 1 1
3 1 1
3 1 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath3.q.out Mon Jun 15 05:43:22 2009
@@ -15,22 +15,16 @@
src_thrift
Select Operator
expressions:
- expr: mstringstring
- type: map<string,string>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- Select Operator
- expressions:
- expr: 0['key_9']
- type: string
- expr: 1.myint
- type: array<int>
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ expr: mstringstring['key_9']
+ type: string
+ expr: lintstring.myint
+ type: array<int>
+ 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
@@ -40,7 +34,7 @@
query: FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
Input: default/src_thrift
-Output: /data/users/zshao/tools/495-trunk-apache-hive/ql/../build/ql/tmp/47313672/383253534.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/91336275/10000
NULL [0]
NULL [1]
NULL [4]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_testxpath4.q.out Mon Jun 15 05:43:22 2009
@@ -16,28 +16,22 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
- Select Operator
- expressions:
- expr: mstringstring
- type: map<string,string>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- Filter Operator
- predicate:
- expr: ((0['key_9'] is not null and 1.myint is not null) and 1 is not null)
- type: boolean
- Select Operator
- expressions:
- expr: 0['key_9']
- type: string
- expr: 1.myint
- type: array<int>
- 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: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: mstringstring['key_9']
+ type: string
+ expr: lintstring.myint
+ type: array<int>
+ 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
@@ -50,7 +44,7 @@
OR lintstring.myint IS NOT NULL
OR lintstring IS NOT NULL
Input: default/src_thrift
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/249993417/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/691052389/10000
NULL [0]
NULL [1]
NULL [4]
@@ -83,28 +77,22 @@
predicate:
expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
type: boolean
- Select Operator
- expressions:
- expr: mstringstring
- type: map<string,string>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- Filter Operator
- predicate:
- expr: ((0['key_9'] is not null and 1.myint is not null) and 1 is not null)
- type: boolean
- Select Operator
- expressions:
- expr: 0['key_9']
- type: string
- expr: 1.myint
- type: array<int>
- 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: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: mstringstring['key_9']
+ type: string
+ expr: lintstring.myint
+ type: array<int>
+ 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
@@ -117,7 +105,7 @@
OR lintstring.myint IS NOT NULL
OR lintstring IS NOT NULL
Input: default/src_thrift
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1189169528/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/390073057/10000
NULL [0]
NULL [1]
NULL [4]
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -32,9 +32,9 @@
sort order:
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
src1:src
Filter Operator
@@ -51,26 +51,26 @@
sort order:
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -83,27 +83,27 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/842577492/412431294.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1169065671/10002
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
sort order: ++++
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Reduce Operator Tree:
Extract
@@ -126,7 +126,7 @@
(SELECT * FROM src WHERE src.key < 10) src2
SORT BY k1, v1, k2, v2
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/450108646/356249297.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1831934555/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -29,40 +29,38 @@
expr: value
type: string
src1
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
expr: key
type: string
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 0
- value expressions:
- expr: 0
- type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 2
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -90,7 +88,7 @@
Output: default/dest_j1
query: SELECT dest_j1.* FROM dest_j1
Input: default/dest_j1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/476154546/603289343.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/582423028/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join10.q.out Mon Jun 15 05:43:22 2009
@@ -20,22 +20,18 @@
expressions:
expr: key
type: string
- Select Operator
- expressions:
- expr: 0
+ 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 Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 0
- value expressions:
- expr: 0
- type: string
y:src
Select Operator
expressions:
@@ -45,30 +41,30 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 1
+ expr: _col2
type: string
- expr: 2
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -89,7 +85,7 @@
ON (x.key = Y.key)
SELECT Y.*
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/266202466/458884612.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/397770096/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -25,55 +25,51 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
src1:src
Select Operator
expressions:
expr: key
type: string
- expr: value
- type: string
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
- type: string
- expr: 1
+ expr: _col0
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -94,7 +90,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: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/237431026/1499570597.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/760194900/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -28,67 +28,59 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
src1:src
Select Operator
expressions:
expr: key
type: string
- expr: value
- type: string
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
- type: string
- expr: 1
+ expr: _col0
type: string
src3:src
Select Operator
expressions:
expr: key
type: string
- expr: value
- type: string
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(80))
+ expr: (UDFToDouble(_col0) < UDFToDouble(80))
type: boolean
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 2
value expressions:
- expr: 0
- type: string
- expr: 1
+ expr: _col0
type: string
Reduce Operator Tree:
Join Operator
@@ -96,14 +88,14 @@
Inner Join 0 to 1
Inner Join 0 to 2
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
- 2 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
+ 2 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -116,7 +108,6 @@
Fetch Operator
limit: -1
-
query: SELECT src1.c1, src2.c4
FROM
(SELECT src.key as c1, src.value as c2 from src) src1
@@ -127,7 +118,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: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/414875832/942578918.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/827709570/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -29,50 +29,46 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
src1:src
Select Operator
expressions:
expr: key
type: string
- expr: value
- type: string
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
- type: string
- expr: 1
+ expr: _col0
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
File Output Operator
compressed: false
GlobalTableId: 0
@@ -87,59 +83,55 @@
$INTNAME
Reduce Output Operator
key expressions:
- expr: (UDFToDouble(0) + UDFToDouble(2))
+ expr: (UDFToDouble(_col0) + UDFToDouble(_col2))
type: double
sort order: +
Map-reduce partition columns:
- expr: (UDFToDouble(0) + UDFToDouble(2))
+ expr: (UDFToDouble(_col0) + UDFToDouble(_col2))
type: double
tag: 0
value expressions:
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
src3:src
Select Operator
expressions:
expr: key
type: string
- expr: value
- type: string
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(200))
+ expr: (UDFToDouble(_col0) < UDFToDouble(200))
type: boolean
Reduce Output Operator
key expressions:
- expr: UDFToDouble(0)
+ expr: UDFToDouble(_col0)
type: double
sort order: +
Map-reduce partition columns:
- expr: UDFToDouble(0)
+ expr: UDFToDouble(_col0)
type: double
tag: 1
value expressions:
- expr: 0
- type: string
- expr: 1
+ expr: _col0
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 2
+ expr: _col2
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -163,7 +155,7 @@
(SELECT src.key as c5, src.value as c6 from src) src3
ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1730548937/139213957.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1501948781/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -14,73 +14,65 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- Filter Operator
- predicate:
- expr: (2 = '2008-04-08')
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 1
- value expressions:
- expr: 0
- type: string
- expr: 1
- type: string
- expr: 2
- 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
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(100))
- type: boolean
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 0
- value expressions:
- expr: 0
- 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:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0}
- 1 {VALUE.0} {VALUE.1} {VALUE.2}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 2
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -110,7 +102,7 @@
Output: default/dest1
query: select dest1.* from dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/176918026/1246507933.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1317798740/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -47,17 +47,17 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -70,27 +70,27 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/1133850116/446412663.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/324026452/10002
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
sort order: ++++
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Reduce Operator Tree:
Extract
@@ -108,7 +108,7 @@
query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/160691036/109955348.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/394554803/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/join16.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join16.q.out?rev=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -23,25 +23,25 @@
type: string
Filter Operator
predicate:
- expr: (UDFToDouble(0) > UDFToDouble(20))
+ expr: (UDFToDouble(_col0) > UDFToDouble(20))
type: boolean
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
sort order: ++
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
tab
Reduce Output Operator
@@ -67,17 +67,17 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Filter Operator
predicate:
- expr: (UDFToDouble(3) < UDFToDouble(200))
+ expr: (UDFToDouble(_col3) < UDFToDouble(200))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -45,9 +45,9 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/src
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -62,7 +62,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/src
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -70,32 +70,32 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/451051116/633047855.10000.insclause-0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/828409861/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -109,7 +109,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -117,7 +117,7 @@
Move Operator
tables:
replace: true
- source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/451051116/633047855.10000.insclause-0
+ source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/828409861/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -131,10 +131,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/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
+ location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/451051116/633047855.10001
+ tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/828409861/10001
query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
@@ -143,7 +143,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/13176457/983700628.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1207782474/10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0