You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jd...@apache.org on 2016/12/04 00:45:33 UTC
[03/10] hive git commit: HIVE-15334: HIVE-13945 changed scale rules
for division (Jason Dere, reviewed by Sergey Shelukhin)
http://git-wip-us.apache.org/repos/asf/hive/blob/eb5dde21/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out b/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out
index 8af5a1c..db160e1 100644
--- a/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out
+++ b/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out
@@ -38,18 +38,18 @@ STAGE PLANS:
predicate: ((cdecimal1 > 0) and (cdecimal1 < 12345.5678) and (cdecimal2 <> 0) and (cdecimal2 > 1000) and cdouble is not null) (type: boolean)
Statistics: Num rows: 455 Data size: 78809 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: (cdecimal1 + cdecimal2) (type: decimal(25,14)), (cdecimal1 - (2 * cdecimal2)) (type: decimal(26,14)), ((cdecimal1 + 2.34) / cdecimal2) (type: decimal(38,23)), (cdecimal1 * (cdecimal2 / 3.4)) (type: decimal(38,28)), (cdecimal1 % 10) (type: decimal(12,10)), UDFToInteger(cdecimal1) (type: int), UDFToShort(cdecimal2) (type: smallint), UDFToByte(cdecimal2) (type: tinyint), UDFToLong(cdecimal1) (type: bigint), UDFToBoolean(cdecimal1) (type: boolean), UDFToDouble(cdecimal2) (type: double), UDFToFloat(cdecimal1) (type: float), UDFToString(cdecimal2) (type: string), CAST( cdecimal1 AS TIMESTAMP) (type: timestamp)
+ expressions: (cdecimal1 + cdecimal2) (type: decimal(25,14)), (cdecimal1 - (2 * cdecimal2)) (type: decimal(26,14)), ((cdecimal1 + 2.34) / cdecimal2) (type: decimal(38,23)), (cdecimal1 * (cdecimal2 / 3.4)) (type: decimal(38,27)), (cdecimal1 % 10) (type: decimal(12,10)), UDFToInteger(cdecimal1) (type: int), UDFToShort(cdecimal2) (type: smallint), UDFToByte(cdecimal2) (type: tinyint), UDFToLong(cdecimal1) (type: bigint), UDFToBoolean(cdecimal1) (type: boolean), UDFToDouble(cdecimal2) (type: double), UDFToFloat(cdecimal1) (type: float), UDFToString(cdecimal2) (type: string), CAST( cdecimal1 AS TIMESTAMP) (type: timestamp)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
Statistics: Num rows: 455 Data size: 78809 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: _col0 (type: decimal(25,14)), _col1 (type: decimal(26,14)), _col2 (type: decimal(38,23)), _col3 (type: decimal(38,28)), _col4 (type: decimal(12,10)), _col5 (type: int), _col6 (type: smallint), _col7 (type: tinyint), _col8 (type: bigint), _col9 (type: boolean), _col10 (type: double), _col11 (type: float), _col12 (type: string), _col13 (type: timestamp)
+ key expressions: _col0 (type: decimal(25,14)), _col1 (type: decimal(26,14)), _col2 (type: decimal(38,23)), _col3 (type: decimal(38,27)), _col4 (type: decimal(12,10)), _col5 (type: int), _col6 (type: smallint), _col7 (type: tinyint), _col8 (type: bigint), _col9 (type: boolean), _col10 (type: double), _col11 (type: float), _col12 (type: string), _col13 (type: timestamp)
sort order: ++++++++++++++
Statistics: Num rows: 455 Data size: 78809 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: decimal(25,14)), KEY.reducesinkkey1 (type: decimal(26,14)), KEY.reducesinkkey2 (type: decimal(38,23)), KEY.reducesinkkey3 (type: decimal(38,28)), KEY.reducesinkkey4 (type: decimal(12,10)), KEY.reducesinkkey5 (type: int), KEY.reducesinkkey6 (type: smallint), KEY.reducesinkkey7 (type: tinyint), KEY.reducesinkkey8 (type: bigint), KEY.reducesinkkey9 (type: boolean), KEY.reducesinkkey10 (type: double), KEY.reducesinkkey11 (type: float), KEY.reducesinkkey12 (type: string), KEY.reducesinkkey13 (type: timestamp)
+ expressions: KEY.reducesinkkey0 (type: decimal(25,14)), KEY.reducesinkkey1 (type: decimal(26,14)), KEY.reducesinkkey2 (type: decimal(38,23)), KEY.reducesinkkey3 (type: decimal(38,27)), KEY.reducesinkkey4 (type: decimal(12,10)), KEY.reducesinkkey5 (type: int), KEY.reducesinkkey6 (type: smallint), KEY.reducesinkkey7 (type: tinyint), KEY.reducesinkkey8 (type: bigint), KEY.reducesinkkey9 (type: boolean), KEY.reducesinkkey10 (type: double), KEY.reducesinkkey11 (type: float), KEY.reducesinkkey12 (type: string), KEY.reducesinkkey13 (type: timestamp)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
Statistics: Num rows: 455 Data size: 78809 Basic stats: COMPLETE Column stats: NONE
Limit
@@ -81,13 +81,13 @@ LIMIT 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_test
#### A masked pattern was here ####
-1836.44199584197700 -1166.02723492725400 0.83726978148337131458955 245972.5581081025580455294364554849 5.6189189189 835 1000 -24 835 true 1000.823076923077 835.6189 1000.823076923077 1969-12-31 16:13:55.618918918
-1856.13222453224620 -1178.52931392929240 0.83724497870140374273038 251275.4432432496874832128177818760 4.5783783784 844 1011 -13 844 true 1011.5538461538462 844.57837 1011.5538461538462 1969-12-31 16:14:04.578378378
-1858.75758835761550 -1180.19625779623100 0.83724171136694298221079 251986.7675675756486118069543362480 5.7729729730 845 1012 -12 845 true 1012.9846153846155 845.77295 1012.9846153846155 1969-12-31 16:14:05.772972973
-1862.69563409566930 -1182.69667359663860 0.83723682763446158861586 253055.6391891996966694739599371224 7.5648648649 847 1015 -9 847 true 1015.1307692307693 847.5649 1015.1307692307693 1969-12-31 16:14:07.564864864
-1883.69854469852330 -1196.03222453224660 0.83721112592864992485015 258794.4932432367711690165346689984 7.1216216216 857 1026 2 857 true 1026.5769230769233 857.12164 1026.5769230769233 1969-12-31 16:14:17.121621621
-1886.32390852389240 -1197.69916839918480 0.83720795345819015087813 259516.3743243194445698729852508744 8.3162162162 858 1028 4 858 true 1028.0076923076924 858.3162 1028.0076923076924 1969-12-31 16:14:18.316216216
-1887.63659043657700 -1198.53264033265400 0.83720637053221313673364 259877.6918918878226000553442090620 8.9135135135 858 1028 4 858 true 1028.723076923077 858.9135 1028.723076923077 1969-12-31 16:14:18.913513513
-1895.51268191268460 -1203.53347193346920 0.83719691901713431682002 262050.8756756764929300794233581876 2.4972972973 862 1033 9 862 true 1033.0153846153846 862.4973 1033.0153846153846 1969-12-31 16:14:22.497297297
-1909.95218295221550 -1212.70166320163100 0.83717979369462356311054 266058.5472973072557375360130254372 9.0675675676 869 1040 16 869 true 1040.8846153846155 869.06757 1040.8846153846155 1969-12-31 16:14:29.067567567
-1913.89022869026920 -1215.20207900203840 0.83717516799957965211367 267156.8270270394559195677611589825 0.8594594595 870 1043 19 870 true 1043.0307692307692 870.85944 1043.0307692307692 1969-12-31 16:14:30.859459459
+1836.44199584197700 -1166.02723492725400 0.83726978148337131458955 245972.558108102558044693817536566 5.6189189189 835 1000 -24 835 true 1000.823076923077 835.6189 1000.823076923077 1969-12-31 16:13:55.618918918
+1856.13222453224620 -1178.52931392929240 0.83724497870140374273038 251275.443243249687478989925889984 4.5783783784 844 1011 -13 844 true 1011.5538461538462 844.57837 1011.5538461538462 1969-12-31 16:14:04.578378378
+1858.75758835761550 -1180.19625779623100 0.83724171136694298221079 251986.767567575648615190046228140 5.7729729730 845 1012 -12 845 true 1012.9846153846155 845.77295 1012.9846153846155 1969-12-31 16:14:05.772972973
+1862.69563409566930 -1182.69667359663860 0.83723682763446158861586 253055.639189199696672864219396582 7.5648648649 847 1015 -9 847 true 1015.1307692307693 847.5649 1015.1307692307693 1969-12-31 16:14:07.564864864
+1883.69854469852330 -1196.03222453224660 0.83721112592864992485015 258794.493243236771165588048182512 7.1216216216 857 1026 2 857 true 1026.5769230769233 857.12164 1026.5769230769233 1969-12-31 16:14:17.121621621
+1886.32390852389240 -1197.69916839918480 0.83720795345819015087813 259516.374324319444568156352818442 8.3162162162 858 1028 4 858 true 1028.0076923076924 858.3162 1028.0076923076924 1969-12-31 16:14:18.316216216
+1887.63659043657700 -1198.53264033265400 0.83720637053221313673364 259877.691891887822598337517182035 8.9135135135 858 1028 4 858 true 1028.723076923077 858.9135 1028.723076923077 1969-12-31 16:14:18.913513513
+1895.51268191268460 -1203.53347193346920 0.83719691901713431682002 262050.875675676492928354428763593 2.4972972973 862 1033 9 862 true 1033.0153846153846 862.4973 1033.0153846153846 1969-12-31 16:14:22.497297297
+1909.95218295221550 -1212.70166320163100 0.83717979369462356311054 266058.547297307255740143215728140 9.0675675676 869 1040 16 869 true 1040.8846153846155 869.06757 1040.8846153846155 1969-12-31 16:14:29.067567567
+1913.89022869026920 -1215.20207900203840 0.83717516799957965211367 267156.827027039455923922058456280 0.8594594595 870 1043 19 870 true 1043.0307692307692 870.85944 1043.0307692307692 1969-12-31 16:14:30.859459459
http://git-wip-us.apache.org/repos/asf/hive/blob/eb5dde21/ql/src/test/results/clientpositive/vector_decimal_precision.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_decimal_precision.q.out b/ql/src/test/results/clientpositive/vector_decimal_precision.q.out
index c5f9e4d..ca14c44 100644
--- a/ql/src/test/results/clientpositive/vector_decimal_precision.q.out
+++ b/ql/src/test/results/clientpositive/vector_decimal_precision.q.out
@@ -265,37 +265,37 @@ NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
-0.0000000000 0.0000000000 0.000000000000000000
-0.0000000000 0.0000000000 0.000000000000000000
-0.0000000000 0.0000000000 0.000000000000000000
-0.0000000000 0.0000000000 0.000000000000000000
-0.0000000000 0.0000000000 0.000000000000000000
-0.1234567890 0.2469135780 0.041152263000000000
-0.1234567890 0.2469135780 0.041152263000000000
-1.2345678901 2.4691357802 0.411522630033333333
-1.2345678901 2.4691357802 0.411522630033333333
-1.2345678901 2.4691357802 0.411522630033333333
-12.3456789012 24.6913578024 4.115226300400000000
-12.3456789012 24.6913578024 4.115226300400000000
-12.3456789012 24.6913578024 4.115226300400000000
-123.4567890123 246.9135780246 41.152263004100000000
-123.4567890123 246.9135780246 41.152263004100000000
-123.4567890123 246.9135780246 41.152263004100000000
-1234.5678901235 2469.1357802470 411.522630041166666667
-1234.5678901235 2469.1357802470 411.522630041166666667
-1234.5678901235 2469.1357802470 411.522630041166666667
-12345.6789012346 24691.3578024692 4115.226300411533333333
-12345.6789012346 24691.3578024692 4115.226300411533333333
-123456.7890123456 246913.5780246912 41152.263004115200000000
-123456.7890123457 246913.5780246914 41152.263004115233333333
-1234567.8901234560 2469135.7802469120 411522.630041152000000000
-1234567.8901234568 2469135.7802469136 411522.630041152266666667
-12345678.9012345600 24691357.8024691200 4115226.300411520000000000
-12345678.9012345679 24691357.8024691358 4115226.300411522633333333
-123456789.0123456000 246913578.0246912000 41152263.004115200000000000
-123456789.0123456789 246913578.0246913578 41152263.004115226300000000
-1234567890.1234560000 2469135780.2469120000 411522630.041152000000000000
-1234567890.1234567890 2469135780.2469135780 411522630.041152263000000000
+0.0000000000 0.0000000000 0.000000000000
+0.0000000000 0.0000000000 0.000000000000
+0.0000000000 0.0000000000 0.000000000000
+0.0000000000 0.0000000000 0.000000000000
+0.0000000000 0.0000000000 0.000000000000
+0.1234567890 0.2469135780 0.041152263000
+0.1234567890 0.2469135780 0.041152263000
+1.2345678901 2.4691357802 0.411522630033
+1.2345678901 2.4691357802 0.411522630033
+1.2345678901 2.4691357802 0.411522630033
+12.3456789012 24.6913578024 4.115226300400
+12.3456789012 24.6913578024 4.115226300400
+12.3456789012 24.6913578024 4.115226300400
+123.4567890123 246.9135780246 41.152263004100
+123.4567890123 246.9135780246 41.152263004100
+123.4567890123 246.9135780246 41.152263004100
+1234.5678901235 2469.1357802470 411.522630041167
+1234.5678901235 2469.1357802470 411.522630041167
+1234.5678901235 2469.1357802470 411.522630041167
+12345.6789012346 24691.3578024692 4115.226300411533
+12345.6789012346 24691.3578024692 4115.226300411533
+123456.7890123456 246913.5780246912 41152.263004115200
+123456.7890123457 246913.5780246914 41152.263004115233
+1234567.8901234560 2469135.7802469120 411522.630041152000
+1234567.8901234568 2469135.7802469136 411522.630041152267
+12345678.9012345600 24691357.8024691200 4115226.300411520000
+12345678.9012345679 24691357.8024691358 4115226.300411522633
+123456789.0123456000 246913578.0246912000 41152263.004115200000
+123456789.0123456789 246913578.0246913578 41152263.004115226300
+1234567890.1234560000 2469135780.2469120000 411522630.041152000000
+1234567890.1234567890 2469135780.2469135780 411522630.041152263000
PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -348,37 +348,37 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.1234567890 0.013717421000000000
-0.1234567890 0.013717421000000000
-1.2345678901 0.137174210011111111
-1.2345678901 0.137174210011111111
-1.2345678901 0.137174210011111111
-12.3456789012 1.371742100133333333
-12.3456789012 1.371742100133333333
-12.3456789012 1.371742100133333333
-123.4567890123 13.717421001366666667
-123.4567890123 13.717421001366666667
-123.4567890123 13.717421001366666667
-1234.5678901235 137.174210013722222222
-1234.5678901235 137.174210013722222222
-1234.5678901235 137.174210013722222222
-12345.6789012346 1371.742100137177777778
-12345.6789012346 1371.742100137177777778
-123456.7890123456 13717.421001371733333333
-123456.7890123457 13717.421001371744444444
-1234567.8901234560 137174.210013717333333333
-1234567.8901234568 137174.210013717422222222
-12345678.9012345600 1371742.100137173333333333
-12345678.9012345679 1371742.100137174211111111
-123456789.0123456000 13717421.001371733333333333
-123456789.0123456789 13717421.001371742100000000
-1234567890.1234560000 137174210.013717333333333333
-1234567890.1234567890 137174210.013717421000000000
+0.0000000000 0.000000000000
+0.0000000000 0.000000000000
+0.0000000000 0.000000000000
+0.0000000000 0.000000000000
+0.0000000000 0.000000000000
+0.1234567890 0.013717421000
+0.1234567890 0.013717421000
+1.2345678901 0.137174210011
+1.2345678901 0.137174210011
+1.2345678901 0.137174210011
+12.3456789012 1.371742100133
+12.3456789012 1.371742100133
+12.3456789012 1.371742100133
+123.4567890123 13.717421001367
+123.4567890123 13.717421001367
+123.4567890123 13.717421001367
+1234.5678901235 137.174210013722
+1234.5678901235 137.174210013722
+1234.5678901235 137.174210013722
+12345.6789012346 1371.742100137178
+12345.6789012346 1371.742100137178
+123456.7890123456 13717.421001371733
+123456.7890123457 13717.421001371744
+1234567.8901234560 137174.210013717333
+1234567.8901234568 137174.210013717422
+12345678.9012345600 1371742.100137173333
+12345678.9012345679 1371742.100137174211
+123456789.0123456000 13717421.001371733333
+123456789.0123456789 13717421.001371742100
+1234567890.1234560000 137174210.013717333333
+1234567890.1234567890 137174210.013717421000
PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -431,37 +431,37 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.0000000000 0.000000000000000000
-0.1234567890 0.004572473666666667
-0.1234567890 0.004572473666666667
-1.2345678901 0.045724736670370370
-1.2345678901 0.045724736670370370
-1.2345678901 0.045724736670370370
-12.3456789012 0.457247366711111111
-12.3456789012 0.457247366711111111
-12.3456789012 0.457247366711111111
-123.4567890123 4.572473667122222222
-123.4567890123 4.572473667122222222
-123.4567890123 4.572473667122222222
-1234.5678901235 45.724736671240740741
-1234.5678901235 45.724736671240740741
-1234.5678901235 45.724736671240740741
-12345.6789012346 457.247366712392592593
-12345.6789012346 457.247366712392592593
-123456.7890123456 4572.473667123911111111
-123456.7890123457 4572.473667123914814815
-1234567.8901234560 45724.736671239111111111
-1234567.8901234568 45724.736671239140740741
-12345678.9012345600 457247.366712391111111111
-12345678.9012345679 457247.366712391403703704
-123456789.0123456000 4572473.667123911111111111
-123456789.0123456789 4572473.667123914033333333
-1234567890.1234560000 45724736.671239111111111111
-1234567890.1234567890 45724736.671239140333333333
+0.0000000000 0.0000000000000
+0.0000000000 0.0000000000000
+0.0000000000 0.0000000000000
+0.0000000000 0.0000000000000
+0.0000000000 0.0000000000000
+0.1234567890 0.0045724736667
+0.1234567890 0.0045724736667
+1.2345678901 0.0457247366704
+1.2345678901 0.0457247366704
+1.2345678901 0.0457247366704
+12.3456789012 0.4572473667111
+12.3456789012 0.4572473667111
+12.3456789012 0.4572473667111
+123.4567890123 4.5724736671222
+123.4567890123 4.5724736671222
+123.4567890123 4.5724736671222
+1234.5678901235 45.7247366712407
+1234.5678901235 45.7247366712407
+1234.5678901235 45.7247366712407
+12345.6789012346 457.2473667123926
+12345.6789012346 457.2473667123926
+123456.7890123456 4572.4736671239111
+123456.7890123457 4572.4736671239148
+1234567.8901234560 45724.7366712391111
+1234567.8901234568 45724.7366712391407
+12345678.9012345600 457247.3667123911111
+12345678.9012345679 457247.3667123914037
+123456789.0123456000 4572473.6671239111111
+123456789.0123456789 4572473.6671239140333
+1234567890.1234560000 45724736.6712391111111
+1234567890.1234567890 45724736.6712391403333
PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision