You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2013/11/07 07:12:58 UTC
svn commit: r1539531 - in /hive/trunk/ql/src:
java/org/apache/hadoop/hive/ql/udf/ test/org/apache/hadoop/hive/ql/udf/
test/results/beelinepositive/ test/results/clientpositive/
Author: xuefu
Date: Thu Nov 7 06:12:57 2013
New Revision: 1539531
URL: http://svn.apache.org/r1539531
Log:
HIVE-5655: Hive incorrecly handles divide-by-zero case (reviewed by Edward and Brock)
Added:
hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/udf/TestUDFOPDivide.java
Modified:
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPDivide.java
hive/trunk/ql/src/test/results/beelinepositive/udf_round.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_round_2.q.out
hive/trunk/ql/src/test/results/clientpositive/vectorization_13.q.out
hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out
Modified: hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPDivide.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPDivide.java?rev=1539531&r1=1539530&r2=1539531&view=diff
==============================================================================
--- hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPDivide.java (original)
+++ hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPDivide.java Thu Nov 7 06:12:57 2013
@@ -62,7 +62,7 @@ public class UDFOPDivide extends UDF {
public DoubleWritable evaluate(DoubleWritable a, DoubleWritable b) {
// LOG.info("Get input " + a.getClass() + ":" + a + " " + b.getClass() + ":"
// + b);
- if ((a == null) || (b == null)) {
+ if (a == null || b == null || b.get() == 0.0) {
return null;
}
Added: hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/udf/TestUDFOPDivide.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/udf/TestUDFOPDivide.java?rev=1539531&view=auto
==============================================================================
--- hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/udf/TestUDFOPDivide.java (added)
+++ hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/udf/TestUDFOPDivide.java Thu Nov 7 06:12:57 2013
@@ -0,0 +1,29 @@
+package org.apache.hadoop.hive.ql.udf;
+
+import org.apache.hadoop.hive.common.type.HiveDecimal;
+import org.apache.hadoop.hive.serde2.io.DoubleWritable;
+import org.apache.hadoop.hive.serde2.io.HiveDecimalWritable;
+
+import org.junit.Assert;
+import org.junit.Test;
+
+public class TestUDFOPDivide {
+
+ UDFOPDivide udf = new UDFOPDivide();
+
+ @Test
+ public void testDivideByZero() {
+ // Double
+ DoubleWritable left = new DoubleWritable(4.5);
+ DoubleWritable right = new DoubleWritable(0.0);
+ DoubleWritable result = udf.evaluate(left, right);
+ Assert.assertNull(result);
+
+ // Decimal
+ HiveDecimalWritable dec1 = new HiveDecimalWritable(HiveDecimal.create("4.5"));
+ HiveDecimalWritable dec2 = new HiveDecimalWritable(HiveDecimal.create("0"));
+ HiveDecimalWritable dec3 = udf.evaluate(dec1, dec2);
+ Assert.assertNull(dec3);
+ }
+
+}
Modified: hive/trunk/ql/src/test/results/beelinepositive/udf_round.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/beelinepositive/udf_round.q.out?rev=1539531&r1=1539530&r2=1539531&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/beelinepositive/udf_round.q.out (original)
+++ hive/trunk/ql/src/test/results/beelinepositive/udf_round.q.out Thu Nov 7 06:12:57 2013
@@ -16,7 +16,7 @@ Saving all output to "!!{outputDirectory
round(1.0/0.0, 0), round(power(-1.0,0.5), 0)
FROM src LIMIT 1;
'_c0','_c1','_c2','_c3','_c4'
-'','','','Infinity','NaN'
+'','','','','NaN'
1 row selected
>>>
>>> SELECT
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out?rev=1539531&r1=1539530&r2=1539531&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_round.q.out Thu Nov 7 06:12:57 2013
@@ -23,7 +23,7 @@ FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-NULL NULL NULL Infinity NaN
+NULL NULL NULL NULL NaN
PREHOOK: query: SELECT
round(55555), round(55555, 0), round(55555, 1), round(55555, 2), round(55555, 3),
round(55555, -1), round(55555, -2), round(55555, -3), round(55555, -4),
Modified: hive/trunk/ql/src/test/results/clientpositive/udf_round_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/udf_round_2.q.out?rev=1539531&r1=1539530&r2=1539531&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/udf_round_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/udf_round_2.q.out Thu Nov 7 06:12:57 2013
@@ -57,4 +57,4 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: Lineage: tsttbl1.n EXPRESSION []
-Infinity Infinity Infinity Infinity
+NULL NULL NULL NULL
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_13.q.out?rev=1539531&r1=1539530&r2=1539531&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_13.q.out Thu Nov 7 06:12:57 2013
@@ -895,26 +895,26 @@ NULL -1 1969-12-31 16:00:10.785 -1.0 NUL
NULL -1 1969-12-31 16:00:11.049 -1.389 NULL 1 -1 0 -1.3890000581741333 -0.0 1.3890000581741333 -110.49912162792683 0.0 1.3890000581741333 0.0 -10.175 -1.3890000581741333 18.920085600677048 -1.389 0.0 -1
NULL -1 1969-12-31 16:00:12.403 -1.0 NULL 1 -1 0 -1.0 -0.0 1.0 -79.553 0.0 1.0 0.0 -10.175 -1.0 26.28 -1.0 0.0 -1
NULL -1 1969-12-31 16:00:14.985 -1.0 NULL 1 -1 0 -1.0 -0.0 1.0 -79.553 0.0 1.0 0.0 -10.175 -1.0 26.28 -1.0 0.0 -1
-NULL 0 1969-12-31 16:00:00.183 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:00.437 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:00.705 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:02.71 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:04.055 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:04.626 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:04.662 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:05.959 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:09.544 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:10.139 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:10.24 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:11.089 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:12.049 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:13.039 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:13.396 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:14.343 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:14.822 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:15.616 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:15.629 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-NULL 0 1969-12-31 16:00:15.777 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
+NULL 0 1969-12-31 16:00:00.183 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:00.437 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:00.705 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:02.71 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:04.055 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:04.626 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:04.662 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:05.959 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:09.544 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:10.139 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:10.24 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:11.089 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:12.049 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:13.039 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:13.396 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:14.343 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:14.822 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:15.616 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:15.629 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+NULL 0 1969-12-31 16:00:15.777 0.0 NULL 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
NULL 1 1969-12-31 16:00:00.519 1.0 NULL -1 1 0 1.0 0.0 -1.0 79.553 0.0 -1.0 0.0 -10.175 1.0 -26.28 1.0 0.0 1
NULL 1 1969-12-31 16:00:02.579 1.0 NULL -1 1 0 1.0 0.0 -1.0 79.553 0.0 -1.0 0.0 -10.175 1.0 -26.28 1.0 0.0 1
NULL 1 1969-12-31 16:00:04.916 1.0 NULL -1 1 0 1.0 0.0 -1.0 79.553 0.0 -1.0 0.0 -10.175 1.0 -26.28 1.0 0.0 1
@@ -2474,19 +2474,19 @@ true -1 1969-12-31 16:00:15.065 -1.0 821
true -1 1969-12-31 16:00:15.242 -1.0 cvLH6Eat2yFsyy7p 1 -1 0 -1.0 -0.0 1.0 -79.553 0.0 1.0 0.0 -10.175 -1.0 26.28 -1.0 0.0 -1
true -1 1969-12-31 16:00:16.189 -1.0 cvLH6Eat2yFsyy7p 1 -1 0 -1.0 -0.0 1.0 -79.553 0.0 1.0 0.0 -10.175 -1.0 26.28 -1.0 0.0 -1
true -1 1969-12-31 16:00:16.228 -1.0 821UdmGbkEf4j 1 -1 0 -1.0 -0.0 1.0 -79.553 0.0 1.0 0.0 -10.175 -1.0 26.28 -1.0 0.0 -1
-true 0 1969-12-31 16:00:00.181 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:01.268 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:02.284 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:04.336 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:05.166 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:06.311 0.0 821UdmGbkEf4j 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:07.552 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:07.615 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:08.742 0.0 821UdmGbkEf4j 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:09.017 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:09.566 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:09.922 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
-true 0 1969-12-31 16:00:10.688 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 -Infinity 0.0 NaN 0
+true 0 1969-12-31 16:00:00.181 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:01.268 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:02.284 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:04.336 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:05.166 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:06.311 0.0 821UdmGbkEf4j 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:07.552 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:07.615 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:08.742 0.0 821UdmGbkEf4j 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:09.017 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:09.566 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:09.922 0.0 1cGVWH7n1QU 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
+true 0 1969-12-31 16:00:10.688 0.0 cvLH6Eat2yFsyy7p 0 0 0 0.0 0.0 -0.0 0.0 0.0 -0.0 0.0 -10.175 0.0 NULL 0.0 NULL 0
true 1 1969-12-31 16:00:00.106 1.0 1cGVWH7n1QU -1 1 0 1.0 0.0 -1.0 79.553 0.0 -1.0 0.0 -10.175 1.0 -26.28 1.0 0.0 1
true 1 1969-12-31 16:00:00.125 1.0 cvLH6Eat2yFsyy7p -1 1 0 1.0 0.0 -1.0 79.553 0.0 -1.0 0.0 -10.175 1.0 -26.28 1.0 0.0 1
true 1 1969-12-31 16:00:00.342 1.0 1cGVWH7n1QU -1 1 0 1.0 0.0 -1.0 79.553 0.0 -1.0 0.0 -10.175 1.0 -26.28 1.0 0.0 1
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out?rev=1539531&r1=1539530&r2=1539531&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_short_regress.q.out Thu Nov 7 06:12:57 2013
@@ -8717,7 +8717,7 @@ POSTHOOK: Input: default@alltypesorc
1969-12-31 15:59:44.646 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 54 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 54.0 NULL 0.001413979988882123 -54 -7196.0 0.0 NULL NULL 0.4866666666666667 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:44.708 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -22 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -22.0 NULL 6.522017819364598E-4 22 15601.0 0.0 NULL NULL -1.1945454545454546 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:44.782 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL 7 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL 7.0 NULL 6.522017819364598E-4 -7 15601.0 0.0 NULL NULL 3.7542857142857144 0.0 NULL NULL 1 1 NULL
-1969-12-31 15:59:44.904 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 0 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 0.0 NULL 0.0 0 -200.0 0.0 NULL NULL -Infinity 0.0 NULL NULL 1 1 NULL
+1969-12-31 15:59:44.904 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 0 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 0.0 NULL 0.0 0 -200.0 0.0 NULL NULL NULL 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:45.137 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -32 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -32.0 NULL 0.0 32 -200.0 0.0 NULL NULL -0.82125 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:45.153 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 42 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 42.0 NULL 0.0 -42 -200.0 0.0 NULL NULL 0.6257142857142858 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:45.169 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -60 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -60.0 NULL 0.0 60 -200.0 0.0 NULL NULL -0.438 0.0 NULL NULL 1 1 NULL
@@ -8867,7 +8867,7 @@ POSTHOOK: Input: default@alltypesorc
1969-12-31 15:59:55.492 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 14 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 14.0 NULL 0.001413979988882123 -14 -7196.0 0.0 NULL NULL 1.8771428571428572 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:55.508 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 31 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 31.0 NULL 0.0 -31 -200.0 0.0 NULL NULL 0.847741935483871 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:55.755 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL -33 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL -33.0 NULL 0.0 33 -200.0 0.0 NULL NULL -0.7963636363636364 0.0 NULL NULL 1 1 NULL
-1969-12-31 15:59:55.829 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 0 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 0.0 NULL 0.0 0 -200.0 0.0 NULL NULL -Infinity 0.0 NULL NULL 1 1 NULL
+1969-12-31 15:59:55.829 NULL NULL NULL NULL -200.0 NULL NULL 1 -1 NULL 0 NULL NULL 0.0 NULL NULL NULL 0.0 -0.050875000000000004 NULL 0.0 NULL NULL 0.0 NULL 0.0 0 -200.0 0.0 NULL NULL NULL 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:55.847 NULL NULL NULL NULL 15601.0 NULL NULL 1 -1 NULL -9 NULL NULL 0.0 NULL NULL NULL 0.0 6.522017819370554E-4 NULL 0.0 NULL NULL -9.0 NULL 6.522017819364598E-4 9 15601.0 0.0 NULL NULL -2.92 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:55.9 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL -21 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL -21.0 NULL 0.001413979988882123 21 -7196.0 0.0 NULL NULL -1.2514285714285716 0.0 NULL NULL 1 1 NULL
1969-12-31 15:59:55.971 NULL NULL NULL NULL -7196.0 NULL NULL 1 -1 NULL 8 NULL NULL 0.0 NULL NULL NULL 0.0 -0.0014139799888827128 NULL 0.0 NULL NULL 8.0 NULL 0.001413979988882123 -8 -7196.0 0.0 NULL NULL 3.285 0.0 NULL NULL 1 1 NULL