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/08/11 04:06:32 UTC
svn commit: r802976 [4/17] - 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/lib/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/...
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -107,7 +109,7 @@
Output: default/dest1
query: SELECT * FROM dest1 SORT BY key, value
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/895109430/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/660141896/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_null
+ TableScan
+ alias: src_null
Select Operator
expressions:
expr: a
@@ -59,7 +61,7 @@
query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
Input: default/src_null
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/125046373/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/497061078/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
a:input4
+ TableScan
+ alias: input4
Select Operator
expressions:
expr: key
@@ -56,7 +58,7 @@
FROM INPUT4) a
ORDER BY KEY2 LIMIT 10
Input: default/input4
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/945658600/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1382133902/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -12,7 +12,10 @@
Map Reduce
Alias -> Map Operator Tree:
b
+ TableScan
+ alias: b
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (hr = '14'))
type: boolean
@@ -29,7 +32,10 @@
expr: hr
type: string
a
+ TableScan
+ alias: a
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (hr = '11'))
type: boolean
@@ -47,9 +53,9 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -68,7 +74,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/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -80,6 +86,7 @@
1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((((_col2 = '2008-04-08') and (_col3 = '11')) and (_col6 = '2008-04-08')) and (_col7 = '14'))
type: boolean
@@ -106,7 +113,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1797615685/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1962615553/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -122,4 +129,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: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1293686104/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/107545677/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: (d = '2009-01-01')
@@ -60,6 +62,6 @@
query: select count(1) from tst x where x.d='2009-01-01'
Input: default/tst/d=2009-01-01
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/914060511/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1878605126/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:subq-subquery1:x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: (d = '2009-01-01')
@@ -64,7 +66,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1648055539/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/197206999/10002
Union
Select Operator
expressions:
@@ -81,7 +83,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1648055539/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/197206999/10003
Union
Select Operator
expressions:
@@ -103,6 +105,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:subq-subquery2:x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: (d = '2009-02-02')
@@ -153,5 +157,5 @@
) subq
Input: default/tst/d=2009-01-01
Input: default/tst/d=2009-02-02
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/297483633/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1412410730/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:subq-subquery1:a
+ TableScan
+ alias: a
Filter Operator
predicate:
expr: ((ds = '2008-04-08') and (hr = '11'))
@@ -66,7 +68,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/136969549/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082108429/10002
Union
Select Operator
expressions:
@@ -85,7 +87,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/136969549/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1082108429/10003
Union
Select Operator
expressions:
@@ -109,6 +111,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:subq-subquery2:b
+ TableScan
+ alias: b
Filter Operator
predicate:
expr: ((ds = '2008-04-08') and (hr = '14'))
@@ -162,7 +166,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/116487966/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/168463886/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/input2_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out Tue Aug 11 02:06:23 2009
@@ -12,6 +12,8 @@
Map Reduce
Alias -> Map Operator Tree:
x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(300))
@@ -42,7 +44,7 @@
query: SELECT x.* FROM SRC x WHERE x.key < 300 LIMIT 5
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/689430698/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/515715119/10000
238 val_238
86 val_86
27 val_27
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (((hash(rand(UDFToLong(460476415))) & 2147483647) % 32) = 0)
@@ -75,7 +77,7 @@
Output: default/tst_dest30
query: select * from tst_dest30
Input: default/tst_dest30
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1981954297/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1316741609/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcbucket
+ TableScan
+ alias: srcbucket
Select Operator
Group By Operator
aggregations:
@@ -71,7 +73,7 @@
Output: default/tst_dest31
query: select * from tst_dest31
Input: default/tst_dest31
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1184857393/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2034201146/10000
493
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
srcbucket
+ TableScan
+ alias: srcbucket
Select Operator
Group By Operator
aggregations:
@@ -71,7 +73,7 @@
Output: default/tst_dest32
query: select * from tst_dest32
Input: default/tst_dest32
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/54515043/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1142748652/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
t:t1
+ TableScan
+ alias: t1
Select Operator
expressions:
expr: key
@@ -62,7 +64,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1988545079/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1953025922/10002
Reduce Output Operator
sort order:
tag: -1
@@ -99,7 +101,7 @@
Output: default/t2
query: SELECT * FROM T2 SORT BY key, value
Input: default/t2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1233838218/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/741107383/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -44,7 +46,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1809793683/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1741200337/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -73,7 +75,7 @@
query: select * from src sort by key limit 10
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1717158908/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/385052408/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
tmap:src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: lint
@@ -85,7 +87,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/915690046/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/120418612/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/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1
+ TableScan
+ alias: src1
Filter Operator
predicate:
expr: key is null
@@ -45,10 +47,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/514038565/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2028160907/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1369456847/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/886482304/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -88,4 +90,4 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/439706537/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2074725714/10000
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1
+ TableScan
+ alias: src1
Select Operator
expressions:
expr: null
@@ -44,10 +46,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1246196954/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1105502435/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2070937236/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1662408362/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -87,7 +89,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1350143879/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/136163075/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1
+ TableScan
+ alias: src1
Select Operator
expressions:
expr: (UDFToDouble(4) + null)
@@ -48,10 +50,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2001020819/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1626829975/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/546572245/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2078440366/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -93,7 +95,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/290179113/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/60632490/10000
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1
+ TableScan
+ alias: src1
Filter Operator
predicate:
expr: (null = null)
@@ -52,10 +54,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/2053307008/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1618745236/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/694414280/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1286113627/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -95,4 +97,4 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1570451077/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1674136764/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: lint
@@ -78,7 +80,7 @@
Output: default/input_columnarserde
query: SELECT input_columnarserde.* FROM input_columnarserde DISTRIBUTE BY 1
Input: default/input_columnarserde
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2034641093/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1695989715/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
@@ -92,7 +94,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/334887658/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1755799278/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -21,6 +21,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: lint
@@ -49,10 +51,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/517762331/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1925142463/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1867126986/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1140895264/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -98,7 +100,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/683760130/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/842958925/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
@@ -112,7 +114,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/189330657/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1145493551/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: lint
@@ -78,7 +80,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1
Input: default/dest1
-Output: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/604433188/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/54447048/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
@@ -92,7 +94,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: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/848270212/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1845091515/10000
0 0 NULL 1712634731 record_0
1 10 NULL 465985200 record_1
2 20 NULL -751827638 record_2
@@ -111,7 +113,7 @@
Output: default/dest1
query: SELECT * from dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/1928951519/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/482165346/10000
[0,0,0]
[1,2,3]
[2,4,6]
@@ -130,7 +132,7 @@
Output: default/dest1
query: SELECT * from dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/deploy-trunk-apache-hive/build/ql/tmp/1672243759/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/244883137/10000
{"key_0":"value_0"}
{"key_1":"value_1"}
{"key_2":"value_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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,11 +15,15 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Filter Operator
+ isSamplingPred: false
predicate:
expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12'))
type: boolean
Filter Operator
+ isSamplingPred: false
predicate:
expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12'))
type: boolean
@@ -48,7 +52,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -62,14 +66,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/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -88,7 +92,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/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -98,11 +102,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -120,9 +124,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/297808158/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/430187082/10002
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -137,7 +141,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/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Reduce Operator Tree:
@@ -145,7 +149,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10000
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -158,7 +162,7 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -167,7 +171,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -181,10 +185,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/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/880173234/10001
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1548094656/10001
query: FROM srcpart
@@ -193,7 +197,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/583441670/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1182712706/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -19,7 +19,10 @@
Map Reduce
Alias -> Map Operator Tree:
srcpart
+ TableScan
+ alias: srcpart
Filter Operator
+ isSamplingPred: false
predicate:
expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-08')) and (hr = '12'))
type: boolean
@@ -48,7 +51,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -62,10 +65,11 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Filter Operator
+ isSamplingPred: false
predicate:
expr: (((UDFToDouble(key) < UDFToDouble(100)) and (ds = '2008-04-09')) and (hr = '12'))
type: boolean
@@ -94,7 +98,7 @@
File Output Operator
compressed: false
GlobalTableId: 2
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -108,15 +112,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -135,10 +139,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
partition values:
ds 2008-04-09
@@ -157,7 +161,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -167,11 +171,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -189,9 +193,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10004
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -206,7 +210,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Reduce Operator Tree:
@@ -214,7 +218,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10000
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -227,7 +231,7 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -236,7 +240,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10000
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -250,10 +254,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10001
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10001
Stage: Stage-8
Conditional Operator
@@ -261,11 +265,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10002
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10002
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -283,9 +287,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005
Path -> Partition:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/538933043/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/169095192/10005
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -300,7 +304,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
Reduce Operator Tree:
@@ -308,7 +312,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10002
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -321,7 +325,7 @@
bucket_count -1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
- location file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
@@ -330,7 +334,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10002
+ source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10002
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -344,10 +348,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/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest2
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest2
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- tmp directory: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1990075660/10003
+ tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/32810842/10003
query: FROM srcpart
@@ -359,7 +363,7 @@
Output: default/dest2
query: SELECT dest1.* FROM dest1 sort by key,value,ds,hr
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/305007713/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1367548594/10000
0 val_0 12 2008-04-08
0 val_0 12 2008-04-08
0 val_0 12 2008-04-08
@@ -446,7 +450,7 @@
98 val_98 12 2008-04-08
query: SELECT dest2.* FROM dest2 sort by key,value,ds,hr
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1696118746/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1502320344/10000
0 val_0 12 2008-04-09
0 val_0 12 2008-04-09
0 val_0 12 2008-04-09
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part5.q.out Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
@@ -50,10 +52,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1070846773/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1321538842/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1822724007/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/378526421/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -98,7 +100,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
Input: default/tmptable
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/994747882/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1919037456/10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out Tue Aug 11 02:06:23 2009
@@ -12,6 +12,8 @@
Map Reduce
Alias -> Map Operator Tree:
x
+ TableScan
+ alias: x
Filter Operator
predicate:
expr: (UDFToDouble(ds) = UDFToDouble(((2008 - 4) - 8)))
@@ -49,4 +51,4 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/447936279/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/758866598/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -17,11 +17,15 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:a-subquery1:x
+ TableScan
+ alias: x
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
type: boolean
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
type: boolean
@@ -64,11 +68,15 @@
expr: _col3
type: string
null-subquery2:a-subquery2:y
+ TableScan
+ alias: y
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
type: boolean
Filter Operator
+ isSamplingPred: false
predicate:
expr: ((ds = '2008-04-08') and (UDFToDouble(key) < UDFToDouble(100)))
type: boolean
@@ -112,10 +120,10 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -134,10 +142,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/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -156,7 +164,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/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -164,7 +172,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/526431721/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/260684261/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -186,7 +194,7 @@
SORT BY A.key
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_2/build/ql/tmp/891014726/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1095258770/10000
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
0 val_0 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out Tue Aug 11 02:06:23 2009
@@ -12,11 +12,15 @@
Map Reduce
Alias -> Map Operator Tree:
x
+ TableScan
+ alias: x
Filter Operator
+ isSamplingPred: false
predicate:
expr: (key is not null and (ds = '2008-04-08'))
type: boolean
Filter Operator
+ isSamplingPred: false
predicate:
expr: (key is not null and (ds = '2008-04-08'))
type: boolean
@@ -34,7 +38,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/741456423/10001
+ directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1563301845/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -44,10 +48,10 @@
columns.types string:string:string:string
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -66,10 +70,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/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -88,7 +92,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/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -96,11 +100,10 @@
Fetch Operator
limit: -1
-
query: SELECT x.* FROM SRCPART x WHERE key IS NOT NULL AND ds = '2008-04-08'
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/675875634/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/261570775/10000
238 val_238 2008-04-08 11
86 val_86 2008-04-08 11
311 val_311 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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -44,10 +46,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1551879808/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/66296780/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/333825755/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/696386493/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -87,7 +89,7 @@
Output: default/dest4_sequencefile
query: SELECT dest4_sequencefile.* FROM dest4_sequencefile
Input: default/dest4_sequencefile
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1330571265/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1740018571/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: lint[1]
@@ -39,10 +41,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/893288498/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/794454681/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/647174747/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/492458082/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -84,7 +86,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/761702774/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/264689843/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Filter Operator
predicate:
expr: (lint is not null and not mstringstring is null)
@@ -47,10 +49,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1379940084/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/630839318/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/476600317/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/284782500/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -92,7 +94,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1955798918/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/413755901/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: mstringstring['key_9']
@@ -35,7 +37,7 @@
query: FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], src_thrift.lintstring.myint
Input: default/src_thrift
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1386485192/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1059185497/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Filter Operator
predicate:
expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
@@ -45,7 +47,7 @@
OR lintstring.myint IS NOT NULL
OR lintstring IS NOT NULL
Input: default/src_thrift
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/533384116/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/607559356/10000
NULL [0]
NULL [1]
NULL [4]
@@ -74,6 +76,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Filter Operator
predicate:
expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
@@ -107,7 +111,7 @@
OR lintstring.myint IS NOT NULL
OR lintstring IS NOT NULL
Input: default/src_thrift
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1269187205/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/364349054/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(10))
@@ -42,6 +44,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(10))
@@ -94,7 +98,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/63021860/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1266394522/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -137,7 +141,7 @@
(SELECT * FROM src WHERE src.key < 10) src2
SORT BY k1, v1, k2, v2
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2035203874/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1838206361/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -14,6 +14,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2
+ TableScan
+ alias: src2
Reduce Output Operator
key expressions:
expr: key
@@ -27,6 +29,8 @@
expr: value
type: string
src1
+ TableScan
+ alias: src1
Reduce Output Operator
key expressions:
expr: key
@@ -87,7 +91,7 @@
Output: default/dest_j1
query: SELECT dest_j1.* FROM dest_j1
Input: default/dest_j1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_3/build/ql/tmp/1786745892/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/862388733/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
x:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -31,6 +33,8 @@
type: string
tag: 0
y:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -86,7 +90,7 @@
ON (x.key = Y.key)
SELECT Y.*
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1524530660/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1608637001/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -37,6 +39,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -96,7 +100,7 @@
(SELECT src.key as c3, src.value as c4 from src) src2
ON src1.c1 = src2.c3 AND src1.c1 < 100
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/542706340/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1302752228/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -40,6 +42,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -66,6 +70,8 @@
expr: _col0
type: string
src3:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(80))
@@ -127,7 +133,7 @@
(SELECT src.key as c5, src.value as c6 from src) src3
ON src1.c1 = src3.c5 AND src3.c5 < 80
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/23536302/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1418897079/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -21,6 +21,8 @@
Map Reduce
Alias -> Map Operator Tree:
src2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -43,6 +45,8 @@
expr: _col1
type: string
src1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -102,6 +106,8 @@
expr: _col0
type: string
src3:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(200))
@@ -161,7 +167,7 @@
(SELECT src.key as c5, src.value as c6 from src) src3
ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/259098425/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1605427587/10000
0 val_0
0 val_0
0 val_0