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 [4/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/groupby8_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out Mon Jun 15 05:43:22 2009
@@ -18,64 +18,76 @@
Map Reduce
Alias -> Map Operator Tree:
src
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(value, 5))
- keys:
+ Select Operator
+ expressions:
expr: key
type: string
- expr: substr(value, 5)
+ expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- expr: 1
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(value, 5))
+ keys:
+ expr: key
type: string
- sort order: ++
- Map-reduce partition columns:
- expr: 0
+ expr: substr(value, 5)
type: string
- tag: -1
- value expressions:
- expr: 2
- type: bigint
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(value, 5))
- keys:
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ Select Operator
+ expressions:
expr: key
type: string
- expr: substr(value, 5)
+ expr: value
type: string
- mode: hash
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(value, 5))
+ keys:
+ expr: key
+ type: string
+ expr: substr(value, 5)
+ type: string
+ mode: hash
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -105,40 +117,40 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/492007815/594155621.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/696709416/10004
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
tag: -1
value expressions:
- expr: 2
+ expr: _col2
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -158,7 +170,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1292699155/23668440.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1772033859/10000
0 1
10 1
100 1
@@ -470,7 +482,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1153711442/698935476.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1926577682/10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out Mon Jun 15 05:43:22 2009
@@ -20,53 +20,65 @@
Map Reduce
Alias -> Map Operator Tree:
src
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(value, 5))
- keys:
+ Select Operator
+ expressions:
expr: key
type: string
- expr: substr(value, 5)
+ expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- expr: 1
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(value, 5))
+ keys:
+ expr: key
type: string
- sort order: ++
- Map-reduce partition columns:
- expr: 0
+ expr: substr(value, 5)
type: string
- expr: 1
- type: string
- tag: -1
- value expressions:
- expr: 2
- type: bigint
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(value, 5))
- keys:
+ mode: hash
+ 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: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ Select Operator
+ expressions:
expr: key
type: string
- expr: substr(value, 5)
+ expr: value
type: string
- mode: hash
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(value, 5))
+ keys:
+ expr: key
+ type: string
+ expr: substr(value, 5)
+ type: string
+ mode: hash
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: partial2
File Output Operator
@@ -80,38 +92,38 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/409785616/966909649.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/535579836/10004
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: 1
+ expr: _col1
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: final
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -141,29 +153,29 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/409785616/966909649.10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/535579836/10005
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: -1
value expressions:
- expr: 2
+ expr: _col2
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: partial2
File Output Operator
@@ -177,38 +189,38 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/409785616/966909649.10006
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/535579836/10006
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: 1
+ expr: _col1
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: final
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -228,7 +240,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/76628135/665663173.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/876229635/10000
0 1
10 1
100 1
@@ -540,7 +552,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/694888471/362559158.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1119745229/10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out Mon Jun 15 05:43:22 2009
@@ -18,43 +18,55 @@
Map Reduce
Alias -> Map Operator Tree:
src
- Reduce Output Operator
- key expressions:
+ Select Operator
+ expressions:
expr: key
type: string
- expr: substr(value, 5)
+ expr: value
type: string
- sort order: ++
- Map-reduce partition columns:
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: substr(value, 5)
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: -1
+ Select Operator
+ expressions:
expr: key
type: string
- tag: -1
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
+ expr: value
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: complete
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -84,7 +96,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/8527497/734265590.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1930410886/10004
Reduce Output Operator
key expressions:
expr: key
@@ -99,22 +111,22 @@
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: complete
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -134,7 +146,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/66885571/152113333.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1635221718/10000
0 1
10 1
100 1
@@ -446,7 +458,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/10910469/133549655.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/378955770/10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out Mon Jun 15 05:43:22 2009
@@ -20,66 +20,78 @@
Map Reduce
Alias -> Map Operator Tree:
src
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(value, 5))
- keys:
+ Select Operator
+ expressions:
expr: key
type: string
- expr: substr(value, 5)
+ expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- expr: 1
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(value, 5))
+ keys:
+ expr: key
type: string
- sort order: ++
- Map-reduce partition columns:
- expr: 0
+ expr: substr(value, 5)
type: string
- tag: -1
- value expressions:
- expr: 2
- type: bigint
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(value, 5))
- keys:
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ Select Operator
+ expressions:
expr: key
type: string
expr: value
type: string
- expr: substr(value, 5)
- type: string
- mode: hash
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- name: binary_table
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(value, 5))
+ keys:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: substr(value, 5)
+ type: string
+ mode: hash
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ name: binary_table
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.1)
+ expr: count(DISTINCT KEY._col1)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -109,50 +121,50 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/244148358/29883298.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/676678496/10004
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
sort order: +++
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
tag: -1
value expressions:
- expr: 3
+ expr: _col3
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.2)
+ expr: count(DISTINCT KEY._col2)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
- expr: KEY.1
+ expr: KEY._col1
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: bigint
File Output Operator
compressed: false
@@ -172,7 +184,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/177100375/256795261.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1435826183/10000
0 1
10 1
100 1
@@ -484,7 +496,7 @@
98 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1144493189/1946891094.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/590286601/10000
0 val_0 1
10 val_10 1
100 val_100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out Mon Jun 15 05:43:22 2009
@@ -26,9 +26,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
@@ -56,7 +56,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/204335901/94270263.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1526182455/10000
86 val_86
27 val_27
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out Mon Jun 15 05:43:22 2009
@@ -29,18 +29,18 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
Limit
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -68,7 +68,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/76746890/763200943.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2144033711/10000
86 val_86
27 val_27
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out Mon Jun 15 05:43:22 2009
@@ -30,9 +30,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
@@ -54,9 +54,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
@@ -76,7 +76,7 @@
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
File Output Operator
compressed: false
@@ -123,7 +123,7 @@
Output: default/dest3/ds=2008-04-08/hr=12
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1596690660/1217911700.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/547160441/10000
86 val_86
27 val_27
98 val_98
@@ -210,7 +210,7 @@
97 val_97
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/28573739/190647993.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/707368017/10000
165 val_165
193 val_193
150 val_150
@@ -318,7 +318,7 @@
169 val_169
query: SELECT dest3.* FROM dest3
Input: default/dest3/ds=2008-04-08/hr=12
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/135776438/188412986.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2065346156/10000
238 2008-04-08 12
311 2008-04-08 12
409 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out Mon Jun 15 05:43:22 2009
@@ -31,9 +31,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
@@ -55,9 +55,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
@@ -77,7 +77,7 @@
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
File Output Operator
compressed: false
@@ -143,7 +143,7 @@
Output: ../build/ql/test/data/warehouse/dest4.out
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/101162710/400931609.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1373367649/10000
86 val_86
27 val_27
98 val_98
@@ -230,7 +230,7 @@
97 val_97
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/276246666/1730128617.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1557787220/10000
165 val_165
193 val_193
150 val_150
@@ -338,7 +338,7 @@
169 val_169
query: SELECT dest3.* FROM dest3
Input: default/dest3/ds=2008-04-08/hr=12
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/267290504/751561735.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2137331699/10000
238 2008-04-08 12
255 2008-04-08 12
278 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out Mon Jun 15 05:43:22 2009
@@ -48,19 +48,19 @@
Extract
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -93,7 +93,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/815600455/1462527055.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/147687944/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out Mon Jun 15 05:43:22 2009
@@ -59,39 +59,39 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/474887158/731090197.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/197100111/10002
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:
Extract
Limit
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -124,7 +124,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/53947653/410789026.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/762680010/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out Mon Jun 15 05:43:22 2009
@@ -21,50 +21,42 @@
tmap:src_thrift
Select Operator
expressions:
- expr: aint
+ expr: (aint + lint[0])
type: int
- expr: lint
- type: array<int>
- expr: lintstring
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- Select Operator
- expressions:
- expr: (0 + 1[0])
- type: int
- expr: 2[0]
- type: struct<myint:int,mystring:string,underscore_int:int>
- Transform Operator
- command: /bin/cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Reduce Output Operator
- key expressions:
- expr: tkey
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: tkey
- type: string
- tag: -1
- value expressions:
- expr: tkey
- type: string
- expr: tvalue
- type: string
+ expr: lintstring[0]
+ type: struct<myint:int,mystring:string,underscore_int:int>
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ key expressions:
+ expr: tkey
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: tkey
+ type: string
+ tag: -1
+ value expressions:
+ expr: tkey
+ type: string
+ expr: tvalue
+ type: string
Reduce Operator Tree:
Extract
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -97,7 +89,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/899544746/1236316343.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1007756792/10000
NULL {"myint":null,"mystring":null,"underscore_int":null}
-1461153966 {"myint":49,"mystring":"343","underscore_int":7}
-1952710705 {"myint":25,"mystring":"125","underscore_int":5}
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out Mon Jun 15 05:43:22 2009
@@ -52,19 +52,19 @@
Extract
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
+ expr: (UDFToDouble(_col0) < UDFToDouble(100))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: regexp_replace(1, ' ', '+')
+ expr: regexp_replace(_col1, ' ', '+')
type: string
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -97,7 +97,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/543730859/7367833.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1089981684/10000
0 val_0+3+7
0 val_0+3+7
0 val_0+3+7
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out Mon Jun 15 05:43:22 2009
@@ -33,9 +33,9 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Filter Operator
predicate:
@@ -60,9 +60,9 @@
Limit
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -92,23 +92,23 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/695306607/98961335.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1617651183/10004
Reduce Output Operator
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
Limit
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -128,7 +128,7 @@
Output: default/dest2
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/897368906/5413858.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1306289056/10000
86 val_86
27 val_27
98 val_98
@@ -141,7 +141,7 @@
57 val_57
query: SELECT dest2.* FROM dest2
Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/532706806/260883385.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1013942873/10000
86 val_86
27 val_27
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out Mon Jun 15 05:43:22 2009
@@ -27,40 +27,36 @@
expressions:
expr: key
type: string
- Select Operator
- expressions:
- expr: 0
- type: string
- expr: 0
- type: string
- Transform Operator
- command: cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- expr: value
- 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: key
+ type: string
+ Transform Operator
+ command: cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Extract
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Transform Operator
command: ../data/scripts/input20_script
@@ -69,9 +65,9 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(key)
type: int
- expr: 1
+ expr: value
type: string
File Output Operator
compressed: false
@@ -108,7 +104,7 @@
Output: default/dest1
query: SELECT * FROM dest1 SORT BY key, value
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1477442306/994995165.10000
+Output: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/702141920/10000
1 105_105
1 10_10
1 111_111
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out Mon Jun 15 05:43:22 2009
@@ -26,21 +26,21 @@
type: string
Reduce Output Operator
key expressions:
- expr: 3
+ expr: _col3
type: string
sort order: +
Map-reduce partition columns:
- expr: 2
+ expr: _col2
type: string
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
@@ -58,7 +58,7 @@
query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
Input: default/src_null
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/435874957/1843130221.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/828690607/10000
1.0 1 same 0
1.0 1 same 1
1.0 1 same 2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out Mon Jun 15 05:43:22 2009
@@ -21,22 +21,18 @@
expressions:
expr: key
type: string
- expr: value
- type: string
- expr: key
- type: string
Select Operator
expressions:
- expr: 2
+ expr: _col2
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
Reduce Operator Tree:
Extract
@@ -58,7 +54,7 @@
FROM INPUT4) a
ORDER BY KEY2 LIMIT 10
Input: default/input4
-Output: /Users/char/Documents/workspace/Hive-Clean/ql/../build/ql/tmp/404500543/217337677.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1252571176/10000
0
0
0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input23.q.out Mon Jun 15 05:43:22 2009
@@ -39,9 +39,9 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/njain/hive5/hive5/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
Path -> Partition:
- file:/data/users/njain/hive5/hive5/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
@@ -60,7 +60,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/hive5/hive5/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:
@@ -68,35 +68,35 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
- 1 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+ 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
Filter Operator
predicate:
- expr: ((((2 = '2008-04-08') and (3 = '11')) and (6 = '2008-04-08')) and (7 = '14'))
+ expr: ((((_col2 = '2008-04-08') and (_col3 = '11')) and (_col6 = '2008-04-08')) and (_col7 = '14'))
type: boolean
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
- expr: 4
+ expr: _col4
type: string
- expr: 5
+ expr: _col5
type: string
- expr: 6
+ expr: _col6
type: string
- expr: 7
+ expr: _col7
type: string
Limit
File Output Operator
compressed: false
GlobalTableId: 0
- directory: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/57557850/240891616.10001.insclause-0
+ directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/987896879/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -111,4 +111,4 @@
query: select * from srcpart a join srcpart b where a.ds = '2008-04-08' and a.hr = '11' and b.ds = '2008-04-08' and b.hr = '14' limit 5
Input: default/srcpart/ds=2008-04-08/hr=11
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/738588790/856672066.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1484665177/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input24.q.out Mon Jun 15 05:43:22 2009
@@ -15,14 +15,11 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: d
- type: string
- Filter Operator
- predicate:
- expr: (0 = '2009-01-01')
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (d = '2009-01-01')
+ type: boolean
+ Select Operator
Group By Operator
aggregations:
expr: count(1)
@@ -31,16 +28,16 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -56,6 +53,6 @@
query: select count(1) from tst x where x.d='2009-01-01'
Input: default/tst/d=2009-01-01
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/321060343/178308884.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/826416972/10000
0
query: drop table tst
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out Mon Jun 15 05:43:22 2009
@@ -40,11 +40,11 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: int
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: string
Reduce Operator Tree:
Extract
@@ -60,15 +60,15 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/221582197/417273265.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/905940285/10002
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: int
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: string
File Output Operator
compressed: false
@@ -76,15 +76,15 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- /data/users/njain/hive5/hive5/build/ql/tmp/221582197/417273265.10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/905940285/10003
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: int
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: string
File Output Operator
compressed: false
@@ -114,11 +114,11 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: int
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: string
Reduce Operator Tree:
Extract
@@ -143,5 +143,5 @@
) subq
Input: default/tst/d=2009-01-01
Input: default/tst/d=2009-02-02
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/128845781/511626368.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2079633835/10000
query: drop table tst
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out Mon Jun 15 05:43:22 2009
@@ -35,18 +35,18 @@
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
Reduce Operator Tree:
Extract
@@ -62,17 +62,17 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /Users/char/Documents/workspace/Hive-Clean/build/ql/tmp/604361087/3711964.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1762363316/10002
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
File Output Operator
compressed: false
@@ -80,17 +80,17 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- /Users/char/Documents/workspace/Hive-Clean/build/ql/tmp/604361087/3711964.10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1762363316/10003
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
File Output Operator
compressed: false
@@ -122,13 +122,13 @@
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
@@ -152,7 +152,7 @@
select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
)subq
Input: default/srcpart/ds=2008-04-08/hr=11
-Output: /Users/char/Documents/workspace/Hive-Clean/ql/../build/ql/tmp/171937392/70987593.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/987288914/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/input30.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input30.q.out Mon Jun 15 05:43:22 2009
@@ -17,11 +17,11 @@
Map Reduce
Alias -> Map Operator Tree:
src
- Select Operator
- Filter Operator
- predicate:
- expr: (((hash(rand(UDFToLong(460476415))) & 2147483647) % 32) = 0)
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (((hash(rand(UDFToLong(460476415))) & 2147483647) % 32) = 0)
+ type: boolean
+ Select Operator
Group By Operator
aggregations:
expr: count(1)
@@ -30,20 +30,20 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
File Output Operator
compressed: false
@@ -71,7 +71,7 @@
Output: default/tst_dest30
query: select * from tst_dest30
Input: default/tst_dest30
-Output: /data/users/njain/hive3/hive3/ql/../build/ql/tmp/193236256/1067571802.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/672961134/10000
18
query: drop table tst_dest30
query: drop table dest30
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input31.q.out Mon Jun 15 05:43:22 2009
@@ -26,20 +26,20 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
File Output Operator
compressed: false
@@ -67,7 +67,7 @@
Output: default/tst_dest31
query: select * from tst_dest31
Input: default/tst_dest31
-Output: /mnt/vol/devrs005.snc1/rmurthy/hive-committer/ql/../build/ql/tmp/614253361/1040799242.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500549894/10000
500
query: drop table tst_dest31
query: drop table dest31
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input32.q.out Mon Jun 15 05:43:22 2009
@@ -26,20 +26,20 @@
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
File Output Operator
compressed: false
@@ -67,7 +67,7 @@
Output: default/tst_dest32
query: select * from tst_dest32
Input: default/tst_dest32
-Output: /mnt/vol/devrs005.snc1/rmurthy/hive-committer/ql/../build/ql/tmp/96880977/397675071.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1041678385/10000
1000
query: drop table tst_dest32
query: drop table dest32
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out Mon Jun 15 05:43:22 2009
@@ -27,27 +27,27 @@
type: string
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
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Limit
File Output Operator
@@ -61,14 +61,14 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/1838172884/323536142.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1732554576/10002
Reduce Output Operator
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
@@ -98,7 +98,7 @@
Output: default/t2
query: SELECT * FROM T2 SORT BY key, value
Input: default/t2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/631913402/841369613.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/856748724/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out Mon Jun 15 05:43:22 2009
@@ -21,14 +21,14 @@
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
Reduce Operator Tree:
Extract
@@ -44,17 +44,17 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/777531825/8374423.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2049580485/10002
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
Reduce Operator Tree:
Extract
@@ -73,7 +73,7 @@
query: select * from src sort by key limit 10
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/781039993/138503313.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/83498755/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out Mon Jun 15 05:43:22 2009
@@ -25,38 +25,32 @@
type: array<int>
expr: lintstring
type: array<struct<myint:int,mystring:string,underscore_int:int>>
- Select Operator
- expressions:
- expr: 0
- type: array<int>
- expr: 1
- type: array<struct<myint:int,mystring:string,underscore_int:int>>
- Transform Operator
- command: /bin/cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- Reduce Output Operator
- key expressions:
- expr: tkey
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: tkey
- type: string
- tag: -1
- value expressions:
- expr: tkey
- type: string
- expr: tvalue
- type: string
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ key expressions:
+ expr: tkey
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: tkey
+ type: string
+ tag: -1
+ value expressions:
+ expr: tkey
+ type: string
+ expr: tvalue
+ type: string
Reduce Operator Tree:
Extract
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -89,7 +83,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/1082689233/217248273.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1852145259/10000
[0,0,0] [{"myint":0,"mystring":"0","underscore_int":0}]
[1,2,3] [{"myint":1,"mystring":"1","underscore_int":1}]
[2,4,6] [{"myint":4,"mystring":"8","underscore_int":2}]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out Mon Jun 15 05:43:22 2009
@@ -16,28 +16,24 @@
src1
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: UDFToDouble(0)
- type: double
- 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: UDFToDouble(_col0)
+ type: double
+ 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
@@ -56,7 +52,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/412916640/832757248.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1402252959/10000
NULL 238
NULL NULL
NULL 311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out Mon Jun 15 05:43:22 2009
@@ -16,32 +16,28 @@
src1
Select Operator
expressions:
- expr: key
- type: string
+ expr: (UDFToDouble(4) + null)
+ type: double
+ expr: (UDFToDouble(key) - null)
+ type: double
+ expr: (null + null)
+ type: double
Select Operator
expressions:
- expr: (UDFToDouble(4) + null)
+ expr: _col0
type: double
- expr: (UDFToDouble(0) - null)
+ expr: UDFToInteger(_col1)
+ type: int
+ expr: _col2
type: double
- expr: (null + null)
- type: double
- Select Operator
- expressions:
- expr: 0
- type: double
- expr: UDFToInteger(1)
- type: int
- expr: 2
- type: double
- 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
@@ -60,7 +56,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/746725763/14447488.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2130331866/10000
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL