hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [08/30] hive git commit: HIVE-13945 : Decimal value is displayed as rounded when selecting where clause with that decimal value (Sergey Shelukhin, reviewed by Ashutosh Chauhan)
Date Thu, 07 Jul 2016 19:49:53 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/1b5ee3d8/ql/src/test/results/clientpositive/vectorization_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vectorization_13.q.out b/ql/src/test/results/clientpositive/vectorization_13.q.out
index aa014a0..e82e474 100644
--- a/ql/src/test/results/clientpositive/vectorization_13.q.out
+++ b/ql/src/test/results/clientpositive/vectorization_13.q.out
@@ -81,7 +81,7 @@ STAGE PLANS:
             alias: alltypesorc
             Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats:
NONE
             Filter Operator
-              predicate: (((cfloat < 3569.0) and (10.175 >= cdouble) and (cboolean1
<> 1)) or ((UDFToDouble(ctimestamp1) > 11.0) and (UDFToDouble(ctimestamp2) <>
12.0) and (UDFToDouble(ctinyint) < 9763215.5639))) (type: boolean)
+              predicate: (((cfloat < 3569) and (10.175 >= cdouble) and (cboolean1 <>
1)) or ((UDFToDouble(ctimestamp1) > 11.0) and (UDFToDouble(ctimestamp2) <> 12.0)
and (CAST( ctinyint AS decimal(11,4)) < 9763215.5639))) (type: boolean)
               Statistics: Num rows: 2730 Data size: 586959 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
                 expressions: cboolean1 (type: boolean), ctinyint (type: tinyint), ctimestamp1
(type: timestamp), cfloat (type: float), cstring1 (type: string)
@@ -108,7 +108,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10
           Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
           Select Operator
-            expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type: timestamp),
_col3 (type: float), _col4 (type: string), (- _col1) (type: tinyint), _col5 (type: tinyint),
((- _col1) + _col5) (type: tinyint), _col6 (type: double), (_col6 * UDFToDouble(((- _col1)
+ _col5))) (type: double), (- _col6) (type: double), (79.553 * UDFToDouble(_col3)) (type:
double), _col7 (type: double), (- _col6) (type: double), _col8 (type: double), (UDFToDouble(((-
_col1) + _col5)) - 10.175) (type: double), (- (- _col6)) (type: double), (-26.28 / (- (- _col6)))
(type: double), _col9 (type: float), ((_col6 * UDFToDouble(((- _col1) + _col5))) / UDFToDouble(_col1))
(type: double), _col10 (type: tinyint)
+            expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type: timestamp),
_col3 (type: float), _col4 (type: string), (- _col1) (type: tinyint), _col5 (type: tinyint),
((- _col1) + _col5) (type: tinyint), _col6 (type: double), (_col6 * UDFToDouble(((- _col1)
+ _col5))) (type: double), (- _col6) (type: double), (79.553 * _col3) (type: float), _col7
(type: double), (- _col6) (type: double), _col8 (type: double), (CAST( ((- _col1) + _col5)
AS decimal(3,0)) - 10.175) (type: decimal(7,3)), (- (- _col6)) (type: double), (-26.28 / (-
(- _col6))) (type: double), _col9 (type: float), ((_col6 * UDFToDouble(((- _col1) + _col5)))
/ UDFToDouble(_col1)) (type: double), _col10 (type: tinyint)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
             Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
             File Output Operator
@@ -123,13 +123,13 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             Reduce Output Operator
-              key expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type:
timestamp), _col3 (type: float), _col4 (type: string), _col5 (type: tinyint), _col6 (type:
tinyint), _col7 (type: tinyint), _col8 (type: double), _col9 (type: double), _col10 (type:
double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type:
double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type:
float), _col19 (type: double), _col20 (type: tinyint)
+              key expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type:
timestamp), _col3 (type: float), _col4 (type: string), _col5 (type: tinyint), _col6 (type:
tinyint), _col7 (type: tinyint), _col8 (type: double), _col9 (type: double), _col10 (type:
double), _col11 (type: float), _col12 (type: double), _col13 (type: double), _col14 (type:
double), _col15 (type: decimal(7,3)), _col16 (type: double), _col17 (type: double), _col18
(type: float), _col19 (type: double), _col20 (type: tinyint)
               sort order: +++++++++++++++++++++
               Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
               TopN Hash Memory Usage: 0.1
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1 (type: tinyint),
KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey4
(type: string), KEY.reducesinkkey5 (type: tinyint), KEY.reducesinkkey6 (type: tinyint), KEY.reducesinkkey7
(type: tinyint), KEY.reducesinkkey8 (type: double), KEY.reducesinkkey9 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey11 (type: double), KEY.reducesinkkey12 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey14 (type: double), KEY.reducesinkkey15 (type: double), KEY.reducesinkkey16
(type: double), KEY.reducesinkkey17 (type: double), KEY.reducesinkkey18 (type: float), KEY.reducesinkkey19
(type: double), KEY.reducesinkkey20 (type: tinyint)
+          expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1 (type: tinyint),
KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey4
(type: string), KEY.reducesinkkey5 (type: tinyint), KEY.reducesinkkey6 (type: tinyint), KEY.reducesinkkey7
(type: tinyint), KEY.reducesinkkey8 (type: double), KEY.reducesinkkey9 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey11 (type: float), KEY.reducesinkkey12 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey14 (type: double), KEY.reducesinkkey15 (type: decimal(7,3)),
KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: double), KEY.reducesinkkey18
(type: float), KEY.reducesinkkey19 (type: double), KEY.reducesinkkey20 (type: tinyint)
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
           Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
           Limit
@@ -219,9 +219,9 @@ POSTHOOK: Input: default@alltypesorc
 #### A masked pattern was here ####
 NULL	-55	1969-12-31 16:00:11.38	-55.0	NULL	55	-55	0	-55.0	-0.0	55.0	-4375.415	0.0	55.0	0.0
-10.175	-55.0	0.47781818181818186	-55.0	0.0	-55
 NULL	-55	1969-12-31 16:00:11.751	-55.0	NULL	55	-55	0	-55.0	-0.0	55.0	-4375.415	0.0	55.0	0.0
-10.175	-55.0	0.47781818181818186	-55.0	0.0	-55
-NULL	-56	1969-12-31 16:00:13.602	-56.0	NULL	56	-56	0	-56.0	-0.0	56.0	-4454.968	0.0	56.0	0.0
-10.175	-56.0	0.4692857142857143	-56.0	0.0	-56
-NULL	-56	1969-12-31 16:00:13.958	-56.0	NULL	56	-56	0	-56.0	-0.0	56.0	-4454.968	0.0	56.0	0.0
-10.175	-56.0	0.4692857142857143	-56.0	0.0	-56
-NULL	-56	1969-12-31 16:00:15.038	-56.0	NULL	56	-56	0	-56.0	-0.0	56.0	-4454.968	0.0	56.0	0.0
-10.175	-56.0	0.4692857142857143	-56.0	0.0	-56
+NULL	-56	1969-12-31 16:00:13.602	-56.0	NULL	56	-56	0	-56.0	-0.0	56.0	-4454.9683	0.0	56.0
0.0	-10.175	-56.0	0.4692857142857143	-56.0	0.0	-56
+NULL	-56	1969-12-31 16:00:13.958	-56.0	NULL	56	-56	0	-56.0	-0.0	56.0	-4454.9683	0.0	56.0
0.0	-10.175	-56.0	0.4692857142857143	-56.0	0.0	-56
+NULL	-56	1969-12-31 16:00:15.038	-56.0	NULL	56	-56	0	-56.0	-0.0	56.0	-4454.9683	0.0	56.0
0.0	-10.175	-56.0	0.4692857142857143	-56.0	0.0	-56
 NULL	-57	1969-12-31 16:00:11.451	-57.0	NULL	57	-57	0	-57.0	-0.0	57.0	-4534.521	0.0	57.0	0.0
-10.175	-57.0	0.4610526315789474	-57.0	0.0	-57
 NULL	-57	1969-12-31 16:00:11.883	-57.0	NULL	57	-57	0	-57.0	-0.0	57.0	-4534.521	0.0	57.0	0.0
-10.175	-57.0	0.4610526315789474	-57.0	0.0	-57
 NULL	-57	1969-12-31 16:00:12.626	-57.0	NULL	57	-57	0	-57.0	-0.0	57.0	-4534.521	0.0	57.0	0.0
-10.175	-57.0	0.4610526315789474	-57.0	0.0	-57
@@ -232,11 +232,11 @@ NULL	-58	1969-12-31 16:00:12.683	-58.0	NULL	58	-58	0	-58.0	-0.0	58.0
-4614.074	0
 NULL	-58	1969-12-31 16:00:12.948	-58.0	NULL	58	-58	0	-58.0	-0.0	58.0	-4614.074	0.0	58.0	0.0
-10.175	-58.0	0.4531034482758621	-58.0	0.0	-58
 NULL	-58	1969-12-31 16:00:14.066	-58.0	NULL	58	-58	0	-58.0	-0.0	58.0	-4614.074	0.0	58.0	0.0
-10.175	-58.0	0.4531034482758621	-58.0	0.0	-58
 NULL	-58	1969-12-31 16:00:15.658	-58.0	NULL	58	-58	0	-58.0	-0.0	58.0	-4614.074	0.0	58.0	0.0
-10.175	-58.0	0.4531034482758621	-58.0	0.0	-58
-NULL	-59	1969-12-31 16:00:12.008	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.6269999999995
0.0	59.0	0.0	-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
-NULL	-59	1969-12-31 16:00:13.15	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.6269999999995	0.0
59.0	0.0	-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
-NULL	-59	1969-12-31 16:00:13.625	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.6269999999995
0.0	59.0	0.0	-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
-NULL	-59	1969-12-31 16:00:15.296	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.6269999999995
0.0	59.0	0.0	-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
-NULL	-59	1969-12-31 16:00:15.861	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.6269999999995
0.0	59.0	0.0	-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
+NULL	-59	1969-12-31 16:00:12.008	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.627	0.0	59.0	0.0
-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
+NULL	-59	1969-12-31 16:00:13.15	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.627	0.0	59.0	0.0
-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
+NULL	-59	1969-12-31 16:00:13.625	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.627	0.0	59.0	0.0
-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
+NULL	-59	1969-12-31 16:00:15.296	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.627	0.0	59.0	0.0
-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
+NULL	-59	1969-12-31 16:00:15.861	-59.0	NULL	59	-59	0	-59.0	-0.0	59.0	-4693.627	0.0	59.0	0.0
-10.175	-59.0	0.44542372881355935	-59.0	0.0	-59
 NULL	-60	1969-12-31 16:00:11.504	-60.0	NULL	60	-60	0	-60.0	-0.0	60.0	-4773.18	0.0	60.0	0.0
-10.175	-60.0	0.438	-60.0	0.0	-60
 NULL	-60	1969-12-31 16:00:11.641	-60.0	NULL	60	-60	0	-60.0	-0.0	60.0	-4773.18	0.0	60.0	0.0
-10.175	-60.0	0.438	-60.0	0.0	-60
 NULL	-60	1969-12-31 16:00:11.996	-60.0	NULL	60	-60	0	-60.0	-0.0	60.0	-4773.18	0.0	60.0	0.0
-10.175	-60.0	0.438	-60.0	0.0	-60
@@ -338,7 +338,7 @@ STAGE PLANS:
             alias: alltypesorc
             Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats:
NONE
             Filter Operator
-              predicate: (((cfloat < 3569.0) and (10.175 >= cdouble) and (cboolean1
<> 1)) or ((UDFToDouble(ctimestamp1) > -1.388) and (UDFToDouble(ctimestamp2) <>
-1.3359999999999999) and (UDFToDouble(ctinyint) < 9763215.5639))) (type: boolean)
+              predicate: (((cfloat < 3569) and (10.175 >= cdouble) and (cboolean1 <>
1)) or ((UDFToDouble(ctimestamp1) > -1.388) and (UDFToDouble(ctimestamp2) <> -1.3359999999999999)
and (CAST( ctinyint AS decimal(11,4)) < 9763215.5639))) (type: boolean)
               Statistics: Num rows: 2730 Data size: 586959 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
                 expressions: cboolean1 (type: boolean), ctinyint (type: tinyint), ctimestamp1
(type: timestamp), cfloat (type: float), cstring1 (type: string)
@@ -365,7 +365,7 @@ STAGE PLANS:
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10
           Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
           Select Operator
-            expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type: timestamp),
_col3 (type: float), _col4 (type: string), (- _col1) (type: tinyint), _col5 (type: tinyint),
((- _col1) + _col5) (type: tinyint), _col6 (type: double), (_col6 * UDFToDouble(((- _col1)
+ _col5))) (type: double), (- _col6) (type: double), (79.553 * UDFToDouble(_col3)) (type:
double), _col7 (type: double), (- _col6) (type: double), _col8 (type: double), (UDFToDouble(((-
_col1) + _col5)) - 10.175) (type: double), (- (- _col6)) (type: double), (-26.28 / (- (- _col6)))
(type: double), _col9 (type: float), ((_col6 * UDFToDouble(((- _col1) + _col5))) / UDFToDouble(_col1))
(type: double), _col10 (type: tinyint)
+            expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type: timestamp),
_col3 (type: float), _col4 (type: string), (- _col1) (type: tinyint), _col5 (type: tinyint),
((- _col1) + _col5) (type: tinyint), _col6 (type: double), (_col6 * UDFToDouble(((- _col1)
+ _col5))) (type: double), (- _col6) (type: double), (79.553 * _col3) (type: float), _col7
(type: double), (- _col6) (type: double), _col8 (type: double), (CAST( ((- _col1) + _col5)
AS decimal(3,0)) - 10.175) (type: decimal(7,3)), (- (- _col6)) (type: double), (-26.28 / (-
(- _col6))) (type: double), _col9 (type: float), ((_col6 * UDFToDouble(((- _col1) + _col5)))
/ UDFToDouble(_col1)) (type: double), _col10 (type: tinyint)
             outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
             Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
             File Output Operator
@@ -380,13 +380,13 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             Reduce Output Operator
-              key expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type:
timestamp), _col3 (type: float), _col4 (type: string), _col5 (type: tinyint), _col6 (type:
tinyint), _col7 (type: tinyint), _col8 (type: double), _col9 (type: double), _col10 (type:
double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type:
double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type:
float), _col19 (type: double), _col20 (type: tinyint)
+              key expressions: _col0 (type: boolean), _col1 (type: tinyint), _col2 (type:
timestamp), _col3 (type: float), _col4 (type: string), _col5 (type: tinyint), _col6 (type:
tinyint), _col7 (type: tinyint), _col8 (type: double), _col9 (type: double), _col10 (type:
double), _col11 (type: float), _col12 (type: double), _col13 (type: double), _col14 (type:
double), _col15 (type: decimal(7,3)), _col16 (type: double), _col17 (type: double), _col18
(type: float), _col19 (type: double), _col20 (type: tinyint)
               sort order: +++++++++++++++++++++
               Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
               TopN Hash Memory Usage: 0.1
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1 (type: tinyint),
KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey4
(type: string), KEY.reducesinkkey5 (type: tinyint), KEY.reducesinkkey6 (type: tinyint), KEY.reducesinkkey7
(type: tinyint), KEY.reducesinkkey8 (type: double), KEY.reducesinkkey9 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey11 (type: double), KEY.reducesinkkey12 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey14 (type: double), KEY.reducesinkkey15 (type: double), KEY.reducesinkkey16
(type: double), KEY.reducesinkkey17 (type: double), KEY.reducesinkkey18 (type: float), KEY.reducesinkkey19
(type: double), KEY.reducesinkkey20 (type: tinyint)
+          expressions: KEY.reducesinkkey0 (type: boolean), KEY.reducesinkkey1 (type: tinyint),
KEY.reducesinkkey2 (type: timestamp), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey4
(type: string), KEY.reducesinkkey5 (type: tinyint), KEY.reducesinkkey6 (type: tinyint), KEY.reducesinkkey7
(type: tinyint), KEY.reducesinkkey8 (type: double), KEY.reducesinkkey9 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey11 (type: float), KEY.reducesinkkey12 (type: double), KEY.reducesinkkey10
(type: double), KEY.reducesinkkey14 (type: double), KEY.reducesinkkey15 (type: decimal(7,3)),
KEY.reducesinkkey16 (type: double), KEY.reducesinkkey17 (type: double), KEY.reducesinkkey18
(type: float), KEY.reducesinkkey19 (type: double), KEY.reducesinkkey20 (type: tinyint)
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8,
_col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20
           Statistics: Num rows: 1365 Data size: 293479 Basic stats: COMPLETE Column stats:
NONE
           Limit


Mime
View raw message