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/14 09:48:09 UTC
svn commit: r804106 [6/24] - in /hadoop/hive/trunk: ./
contrib/src/java/org/apache/hadoop/hive/contrib/udaf/
contrib/src/java/org/apache/hadoop/hive/contrib/udaf/example/
contrib/src/java/org/apache/hadoop/hive/contrib/udf/
contrib/src/java/org/apache/...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/louter_join_ppr.q.out Fri Aug 14 07:48:02 2009
@@ -50,7 +50,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ expr: ((key > 10) and (key < 20))
type: boolean
Reduce Output Operator
key expressions:
@@ -68,11 +68,11 @@
type: string
Needs Tagging: true
Path -> Alias:
- 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
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src [a]
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -91,10 +91,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -113,10 +113,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -131,7 +131,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -145,7 +145,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: ((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col2) > UDFToDouble(15))) and (UDFToDouble(_col2) < UDFToDouble(25)))
+ expr: ((((_col0 > 10) and (_col0 < 20)) and (_col2 > 15)) and (_col2 < 25))
type: boolean
Select Operator
expressions:
@@ -161,7 +161,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/374479646/10001
+ directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1573242871/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -185,7 +185,7 @@
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/216486087/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/592926769/10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
@@ -240,7 +240,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: ((ds = '2008-04-08') and ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20))))
+ expr: ((ds = '2008-04-08') and ((key > 10) and (key < 20)))
type: boolean
Filter Operator
isSamplingPred: false
@@ -263,11 +263,11 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
- 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
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -282,10 +282,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -304,10 +304,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -326,7 +326,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -340,7 +340,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: ((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col4) > UDFToDouble(15))) and (UDFToDouble(_col4) < UDFToDouble(25)))
+ expr: ((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25))
type: boolean
Select Operator
expressions:
@@ -356,7 +356,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1382329177/10001
+ directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/614472149/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -380,7 +380,7 @@
Input: default/src
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1521057709/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1850755626/10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
@@ -437,7 +437,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ expr: ((key > 10) and (key < 20))
type: boolean
Reduce Output Operator
key expressions:
@@ -455,13 +455,13 @@
type: string
Needs Tagging: true
Path -> Alias:
- 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
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
- file:/data/users/athusoo/commits/hive_trunk_ws1/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/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src [a]
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -480,10 +480,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -502,10 +502,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
partition values:
ds 2008-04-09
@@ -524,10 +524,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
partition values:
ds 2008-04-09
@@ -546,10 +546,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -564,7 +564,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -578,7 +578,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: (((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col2) > UDFToDouble(15))) and (UDFToDouble(_col2) < UDFToDouble(25))) and (_col4 = '2008-04-08'))
+ expr: (((((_col0 > 10) and (_col0 < 20)) and (_col2 > 15)) and (_col2 < 25)) and (_col4 = '2008-04-08'))
type: boolean
Select Operator
expressions:
@@ -594,7 +594,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2039930137/10001
+ directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/302010175/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -620,7 +620,7 @@
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/617611715/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1342874033/10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
@@ -675,7 +675,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: (((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20))) and (ds = '2008-04-08'))
+ expr: (((key > 10) and (key < 20)) and (ds = '2008-04-08'))
type: boolean
Reduce Output Operator
key expressions:
@@ -695,11 +695,11 @@
type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
- 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
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -714,10 +714,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -736,10 +736,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -758,7 +758,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -772,7 +772,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: (((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col4) > UDFToDouble(15))) and (UDFToDouble(_col4) < UDFToDouble(25))) and (_col2 = '2008-04-08'))
+ expr: (((((_col0 > 10) and (_col0 < 20)) and (_col4 > 15)) and (_col4 < 25)) and (_col2 = '2008-04-08'))
type: boolean
Select Operator
expressions:
@@ -788,7 +788,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/116279383/10001
+ directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/864297430/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -812,7 +812,7 @@
Input: default/src
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/309612837/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/872577564/10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out Fri Aug 14 07:48:02 2009
@@ -24,9 +24,9 @@
expressions:
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -101,7 +101,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1222794059/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1594936617/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out Fri Aug 14 07:48:02 2009
@@ -23,9 +23,9 @@
expressions:
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -94,7 +94,7 @@
Output: default/dest1
query: SELECT * FROM (SELECT dest1.* FROM dest1 DISTRIBUTE BY key SORT BY key, ten, one, value) T
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1799546978/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/593292888/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out Fri Aug 14 07:48:02 2009
@@ -23,9 +23,9 @@
expressions:
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -94,7 +94,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1654922670/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1933750790/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out Fri Aug 14 07:48:02 2009
@@ -24,9 +24,9 @@
expressions:
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -101,7 +101,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/354616090/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/34806120/10000
90 9 0 val_90
90 9 0 val_90
90 9 0 val_90
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out Fri Aug 14 07:48:02 2009
@@ -23,9 +23,9 @@
expressions:
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -94,7 +94,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/197645124/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1487693767/10000
490 49 0 val_490
491 49 1 val_491
492 49 2 val_492
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out Fri Aug 14 07:48:02 2009
@@ -23,9 +23,9 @@
expressions:
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -94,7 +94,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/784520367/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/117785863/10000
490 49 0 val_490
491 49 1 val_491
492 49 2 val_492
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out Fri Aug 14 07:48:02 2009
@@ -27,9 +27,9 @@
type: string
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -106,7 +106,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1462787942/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1267286735/10000
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out Fri Aug 14 07:48:02 2009
@@ -28,9 +28,9 @@
type: string
expr: key
type: string
- expr: UDFToInteger((UDFToDouble(key) / UDFToDouble(10)))
+ expr: UDFToInteger((key / 10))
type: int
- expr: UDFToInteger((UDFToDouble(key) % UDFToDouble(10)))
+ expr: UDFToInteger((key % 10))
type: int
expr: value
type: string
@@ -48,7 +48,7 @@
type: string
sort order: ++
Map-reduce partition columns:
- expr: rand(UDFToLong(3))
+ expr: rand(3)
type: double
tag: -1
value expressions:
@@ -111,7 +111,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/16852304/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1294545033/10000
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Fri Aug 14 07:48:02 2009
@@ -15,7 +15,7 @@
alias: src2
Filter Operator
predicate:
- expr: (UDFToDouble(key) < UDFToDouble(10))
+ expr: (key < 10)
type: boolean
Reduce Output Operator
sort order:
@@ -30,7 +30,7 @@
alias: src1
Filter Operator
predicate:
- expr: (UDFToDouble(key) < UDFToDouble(10))
+ expr: (key < 10)
type: boolean
Reduce Output Operator
sort order:
@@ -50,7 +50,7 @@
outputColumnNames: _col0, _col1, _col2, _col3
Filter Operator
predicate:
- expr: ((UDFToDouble(_col0) < UDFToDouble(10)) and (UDFToDouble(_col2) < UDFToDouble(10)))
+ expr: ((_col0 < 10) and (_col2 < 10))
type: boolean
Select Operator
expressions:
@@ -73,7 +73,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1694927557/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/2027777065/10002
Reduce Output Operator
key expressions:
expr: _col0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out Fri Aug 14 07:48:02 2009
@@ -16,7 +16,7 @@
alias: src
Filter Operator
predicate:
- expr: (UDFToDouble(key) < UDFToDouble(100))
+ expr: (key < 100)
type: boolean
Select Operator
expressions:
@@ -27,7 +27,7 @@
outputColumnNames: _col0, _col1
Filter Operator
predicate:
- expr: (UDFToDouble(_col1) < UDFToDouble(100))
+ expr: (_col1 < 100)
type: boolean
Select Operator
expressions:
@@ -48,7 +48,7 @@
query: SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1984163495/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1738791810/10000
val_86
val_27
val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Fri Aug 14 07:48:02 2009
@@ -18,11 +18,11 @@
alias: src
Filter Operator
predicate:
- expr: (UDFToDouble(key) < UDFToDouble(100))
+ expr: (key < 100)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) < UDFToDouble(100))
+ expr: (key < 100)
type: boolean
Select Operator
expressions:
@@ -102,7 +102,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1559429496/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/766222009/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Fri Aug 14 07:48:02 2009
@@ -18,11 +18,11 @@
alias: src
Filter Operator
predicate:
- expr: (UDFToDouble(key) < UDFToDouble(100))
+ expr: (key < 100)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) < UDFToDouble(100))
+ expr: (key < 100)
type: boolean
Select Operator
expressions:
@@ -102,7 +102,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1898241418/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1541116592/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Fri Aug 14 07:48:02 2009
@@ -16,11 +16,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
Group By Operator
@@ -59,7 +59,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/161603981/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1836686316/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -79,11 +79,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
Group By Operator
@@ -122,7 +122,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/720088705/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1953617237/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -143,11 +143,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
Reduce Output Operator
@@ -175,7 +175,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1577457021/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/181284866/10002
Reduce Output Operator
sort order:
tag: -1
@@ -207,7 +207,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1185327154/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/2085444097/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -227,11 +227,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
Reduce Output Operator
@@ -265,5 +265,5 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/858984614/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/244114908/10000
0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Fri Aug 14 07:48:02 2009
@@ -17,11 +17,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
expressions:
@@ -67,7 +67,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/81167502/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/618354627/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -110,7 +110,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/45709324/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/918835817/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -129,11 +129,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
expressions:
@@ -190,7 +190,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/996927786/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1345933200/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -210,11 +210,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
expressions:
@@ -252,7 +252,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/912483231/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/719339517/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -295,7 +295,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/75894632/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1575416627/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -314,11 +314,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) > UDFToDouble(9999))
+ expr: (key > 9999)
type: boolean
Select Operator
expressions:
@@ -367,4 +367,4 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1160900647/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1789480791/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Fri Aug 14 07:48:02 2009
@@ -17,11 +17,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Select Operator
expressions:
@@ -68,7 +68,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1232529310/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/2126451963/10002
Reduce Output Operator
sort order:
tag: -1
@@ -105,7 +105,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1706398248/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/871904429/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -125,11 +125,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Select Operator
expressions:
@@ -184,7 +184,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2036729644/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/266232005/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -205,11 +205,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Select Operator
expressions:
@@ -245,7 +245,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/441797798/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/682272974/10002
Reduce Output Operator
sort order:
tag: -1
@@ -282,7 +282,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1197695098/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1786332270/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -302,11 +302,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(9999))
+ expr: (key = 9999)
type: boolean
Select Operator
expressions:
@@ -350,5 +350,5 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1769543362/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/346530810/10000
0 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out Fri Aug 14 07:48:02 2009
@@ -39,7 +39,7 @@
Limit
Filter Operator
predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(10))
+ expr: (_col0 < 10)
type: boolean
Select Operator
expressions:
@@ -64,7 +64,7 @@
(SELECT x.* FROM SRC x ORDER BY key limit 10) subq
where subq.key < 10
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/899139587/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1452809001/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Fri Aug 14 07:48:02 2009
@@ -63,11 +63,11 @@
type: string
Needs Tagging: true
Path -> Alias:
- 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
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src [a]
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -86,10 +86,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -108,10 +108,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -126,7 +126,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -140,7 +140,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: ((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col2) > UDFToDouble(15))) and (UDFToDouble(_col2) < UDFToDouble(25)))
+ expr: ((((_col0 > 10) and (_col0 < 20)) and (_col2 > 15)) and (_col2 < 25))
type: boolean
Select Operator
expressions:
@@ -156,7 +156,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/520891215/10001
+ directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1059297917/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -180,7 +180,7 @@
Input: default/srcpart/ds=2008-04-08/hr=11
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/630976667/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/50824508/10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
@@ -250,13 +250,13 @@
type: string
Needs Tagging: true
Path -> Alias:
- 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
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
- file:/data/users/athusoo/commits/hive_trunk_ws1/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/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 [b]
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src [a]
Path -> Partition:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
Partition
partition values:
ds 2008-04-08
@@ -275,10 +275,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -297,10 +297,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11
Partition
partition values:
ds 2008-04-09
@@ -319,10 +319,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
partition values:
ds 2008-04-09
@@ -341,10 +341,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -359,7 +359,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+ location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
Reduce Operator Tree:
@@ -373,7 +373,7 @@
Filter Operator
isSamplingPred: false
predicate:
- expr: (((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col2) > UDFToDouble(15))) and (UDFToDouble(_col2) < UDFToDouble(25))) and (_col4 = '2008-04-08'))
+ expr: (((((_col0 > 10) and (_col0 < 20)) and (_col2 > 15)) and (_col2 < 25)) and (_col4 = '2008-04-08'))
type: boolean
Select Operator
expressions:
@@ -389,7 +389,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1312771848/10001
+ directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/290690655/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -415,7 +415,7 @@
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2067779225/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/676402963/10000
17 val_17 17 val_17
17 val_17 17 val_17
18 val_18 18 val_18
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Fri Aug 14 07:48:02 2009
@@ -16,11 +16,11 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(10))
+ expr: (key = 10)
type: boolean
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(10))
+ expr: (key = 10)
type: boolean
Select Operator
expressions:
@@ -59,7 +59,7 @@
query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/661923183/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1472307014/10000
10 val_10
query: EXPLAIN
SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
@@ -95,7 +95,7 @@
alias: x
Filter Operator
predicate:
- expr: (UDFToDouble(key) = UDFToDouble(20))
+ expr: (key = 20)
type: boolean
Reduce Output Operator
key expressions:
@@ -121,7 +121,7 @@
outputColumnNames: _col0, _col1, _col2
Filter Operator
predicate:
- expr: (UDFToDouble(_col0) = UDFToDouble(20))
+ expr: (_col0 = 20)
type: boolean
Select Operator
expressions:
@@ -142,7 +142,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/610411732/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/2071281213/10002
Reduce Output Operator
key expressions:
expr: _col1
@@ -175,5 +175,5 @@
query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/235995833/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1376273049/10000
20 val_20 20
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out Fri Aug 14 07:48:02 2009
@@ -19,9 +19,9 @@
alias: src1
Select Operator
expressions:
- expr: (UDFToDouble(4) + null)
+ expr: (4 + null)
type: double
- expr: (UDFToDouble(key) - null)
+ expr: (key - null)
type: double
expr: (null + null)
type: double
@@ -50,10 +50,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/194859935/10000
+ destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/564929089/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1903200653/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/852084220/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -95,7 +95,7 @@
Output: default/ppd_constant_expr
query: SELECT ppd_constant_expr.* FROM ppd_constant_expr
Input: default/ppd_constant_expr
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/869842043/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2124439979/10000
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out Fri Aug 14 07:48:02 2009
@@ -70,7 +70,7 @@
outputColumnNames: _col0, _col1
Filter Operator
predicate:
- expr: ((_col0 > 'val_200') and ((UDFToDouble(_col1) > UDFToDouble(30)) or (_col0 < 'val_400')))
+ expr: ((_col0 > 'val_200') and ((_col1 > 30) or (_col0 < 'val_400')))
type: boolean
Select Operator
expressions:
@@ -94,7 +94,7 @@
(SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400')
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1347130772/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1522307797/10000
val_201
val_202
val_203
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out Fri Aug 14 07:48:02 2009
@@ -72,7 +72,7 @@
outputColumnNames: _col0, _col1
Filter Operator
predicate:
- expr: ((_col0 > 'val_200') and ((UDFToDouble(_col1) > UDFToDouble(30)) or (_col0 < 'val_400')))
+ expr: ((_col0 > 'val_200') and ((_col1 > 30) or (_col0 < 'val_400')))
type: boolean
Select Operator
expressions:
@@ -99,7 +99,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1187596438/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1758292485/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -146,7 +146,7 @@
WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
GROUP BY src1.c2
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/825792285/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/165114702/10000
val_4 1
val_399 2
val_396 3
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Fri Aug 14 07:48:02 2009
@@ -131,7 +131,7 @@
alias: src
Filter Operator
predicate:
- expr: ((key <> '306') and (sqrt(UDFToDouble(key)) <> UDFToDouble(13)))
+ expr: ((key <> '306') and (sqrt(key) <> 13))
type: boolean
Filter Operator
predicate:
@@ -166,7 +166,7 @@
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Filter Operator
predicate:
- expr: (((((_col2 <> '311') and ((_col3 <> 'val_50') or (_col2 > '1'))) and ((_col0 <> '10') or (_col2 <> '10'))) and (_col0 <> '14')) and (sqrt(UDFToDouble(_col4)) <> UDFToDouble(13)))
+ expr: (((((_col2 <> '311') and ((_col3 <> 'val_50') or (_col2 > '1'))) and ((_col0 <> '10') or (_col2 <> '10'))) and (_col0 <> '14')) and (sqrt(_col4) <> 13))
type: boolean
Select Operator
expressions:
@@ -198,7 +198,7 @@
ON src1.c2 = src3.c6
WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1783863777/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_3/build/ql/tmp/1524774871/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Fri Aug 14 07:48:02 2009
@@ -63,7 +63,7 @@
outputColumnNames: _col0, _col1
Filter Operator
predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(100))
+ expr: (_col0 < 100)
type: boolean
Select Operator
expressions:
@@ -89,7 +89,7 @@
name: mi1
Filter Operator
predicate:
- expr: ((UDFToDouble(_col0) >= UDFToDouble(100)) and (UDFToDouble(_col0) < UDFToDouble(200)))
+ expr: ((_col0 >= 100) and (_col0 < 200))
type: boolean
Select Operator
expressions:
@@ -115,7 +115,7 @@
name: mi2
Filter Operator
predicate:
- expr: ((UDFToDouble(_col0) >= UDFToDouble(200)) and (UDFToDouble(_col0) < UDFToDouble(300)))
+ expr: ((_col0 >= 200) and (_col0 < 300))
type: boolean
Select Operator
expressions:
@@ -137,7 +137,7 @@
name: mi3
Filter Operator
predicate:
- expr: (UDFToDouble(_col0) >= UDFToDouble(300))
+ expr: (_col0 >= 300)
type: boolean
Select Operator
expressions:
@@ -203,7 +203,7 @@
Output: ../build/ql/test/data/warehouse/mi4.out
query: SELECT mi1.* FROM mi1
Input: default/mi1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1662084677/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1064629756/10000
0 val_0
0 val_0
0 val_0
@@ -354,7 +354,7 @@
98 val_98
query: SELECT mi2.* FROM mi2
Input: default/mi2
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1663619015/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1947386768/10000
100 val_100
100 val_100
100 val_100
@@ -568,7 +568,7 @@
199 val_199
query: SELECT mi3.* FROM mi3
Input: default/mi3/ds=2008-04-08/hr=12
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/660410600/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1250417806/10000
200 2008-04-08 12
200 2008-04-08 12
200 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join1.q.out Fri Aug 14 07:48:02 2009
@@ -39,7 +39,7 @@
alias: a
Filter Operator
predicate:
- expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ expr: ((key > 10) and (key < 20))
type: boolean
Reduce Output Operator
key expressions:
@@ -65,7 +65,7 @@
outputColumnNames: _col0, _col1, _col2, _col3
Filter Operator
predicate:
- expr: ((((UDFToDouble(_col0) > UDFToDouble(10)) and (UDFToDouble(_col0) < UDFToDouble(20))) and (UDFToDouble(_col2) > UDFToDouble(15))) and (UDFToDouble(_col2) < UDFToDouble(25)))
+ expr: ((((_col0 > 10) and (_col0 < 20)) and (_col2 > 15)) and (_col2 < 25))
type: boolean
Select Operator
expressions:
@@ -98,7 +98,7 @@
SELECT a.key, a.value, b.key, b.value
WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1157143291/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_3/build/ql/tmp/1743643230/10000
17 val_17 17 val_17
18 val_18 18 val_18
18 val_18 18 val_18
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out Fri Aug 14 07:48:02 2009
@@ -81,7 +81,7 @@
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Filter Operator
predicate:
- expr: (((((_col0 > '10') and (_col0 < '20')) and (_col2 > '15')) and (_col2 < '25')) and (sqrt(UDFToDouble(_col4)) <> UDFToDouble(13)))
+ expr: (((((_col0 > '10') and (_col0 < '20')) and (_col2 > '15')) and (_col2 < '25')) and (sqrt(_col4) <> 13))
type: boolean
Select Operator
expressions:
@@ -119,7 +119,7 @@
SELECT a.key, a.value, b.key, b.value, c.key
WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1848803718/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1874030546/10000
150 val_150 150 val_150 150
152 val_152 152 val_152 152
152 val_152 152 val_152 152
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_transform.q.out Fri Aug 14 07:48:02 2009
@@ -50,7 +50,7 @@
Extract
Filter Operator
predicate:
- expr: (UDFToDouble(_col0) < UDFToDouble(100))
+ expr: (_col0 < 100)
type: boolean
Select Operator
expressions:
@@ -79,7 +79,7 @@
) tmap
SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
Input: default/src
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/683513848/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/603794391/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out Fri Aug 14 07:48:02 2009
@@ -19,11 +19,11 @@
alias: src
Filter Operator
predicate:
- expr: ((UDFToDouble(key) >= UDFToDouble(200)) and (UDFToDouble(key) < UDFToDouble(300)))
+ expr: ((key >= 200) and (key < 300))
type: boolean
Filter Operator
predicate:
- expr: ((UDFToDouble(key) >= UDFToDouble(200)) and (UDFToDouble(key) < UDFToDouble(300)))
+ expr: ((key >= 200) and (key < 300))
type: boolean
Select Operator
expressions:
@@ -54,10 +54,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/963537398/10000
+ destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/623709009/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/319542195/10002
+ file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2105860679/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -144,7 +144,7 @@
Output: default/dest1/table=2008-04-08
query: SELECT `int`.`location`, `int`.`type`, `int`.`table` FROM dest1 `int` WHERE `int`.`table` = '2008-04-08'
Input: default/dest1/table=2008-04-08
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1560089475/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/180511317/10000
238 val_238 2008-04-08
255 val_255 2008-04-08
278 val_278 2008-04-08