This is an automated email from the ASF dual-hosted git repository. yamamuro pushed a commit to branch branch-3.0 in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/branch-3.0 by this push: new d400880 [SPARK-31527][SQL][TESTS][FOLLOWUP] Fix the number of rows in `DateTimeBenchmark` d400880 is described below commit d4008804f987fa3d3405335e2469886a0d61dd67 Author: Max Gekk <max.g...@gmail.com> AuthorDate: Mon May 4 09:39:50 2020 +0900 [SPARK-31527][SQL][TESTS][FOLLOWUP] Fix the number of rows in `DateTimeBenchmark` ### What changes were proposed in this pull request? - Changed to the number of rows in benchmark cases from 3 to the actual number `N`. - Regenerated benchmark results in the environment: | Item | Description | | ---- | ----| | Region | us-west-2 (Oregon) | | Instance | r3.xlarge | | AMI | ubuntu/images/hvm-ssd/ubuntu-bionic-18.04-amd64-server-20190722.1 (ami-06f2f779464715dc5) | | Java | OpenJDK 64-Bit Server VM 1.8.0_242 and OpenJDK 64-Bit Server VM 11.0.6+10 | ### Why are the changes needed? The changes are needed to have: - Correct benchmark results - Base line for other perf improvements that can be checked in the same environment. ### Does this PR introduce _any_ user-facing change? No ### How was this patch tested? By running the benchmark and checking its output. Closes #28440 from MaxGekk/SPARK-31527-DateTimeBenchmark-followup. Authored-by: Max Gekk <max.g...@gmail.com> Signed-off-by: Takeshi Yamamuro <yamam...@apache.org> (cherry picked from commit 2fb85f6b684843f337b6e73ba57ee9e57a53496d) Signed-off-by: Takeshi Yamamuro <yamam...@apache.org> --- .../benchmarks/DateTimeBenchmark-jdk11-results.txt | 474 ++++++++++----------- sql/core/benchmarks/DateTimeBenchmark-results.txt | 474 ++++++++++----------- .../execution/benchmark/DateTimeBenchmark.scala | 2 +- 3 files changed, 475 insertions(+), 475 deletions(-) diff --git a/sql/core/benchmarks/DateTimeBenchmark-jdk11-results.txt b/sql/core/benchmarks/DateTimeBenchmark-jdk11-results.txt index 1004bcf..61b4c76 100644 --- a/sql/core/benchmarks/DateTimeBenchmark-jdk11-results.txt +++ b/sql/core/benchmarks/DateTimeBenchmark-jdk11-results.txt @@ -2,456 +2,456 @@ datetime +/- interval ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz datetime +/- interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date + interval(m) 919 933 22 0.0 306237514.3 1.0X -date + interval(m, d) 910 916 9 0.0 303338619.0 1.0X -date + interval(m, d, ms) 3912 3923 16 0.0 1303942791.7 0.2X -date - interval(m) 883 887 6 0.0 294268789.3 1.0X -date - interval(m, d) 898 911 18 0.0 299453403.0 1.0X -date - interval(m, d, ms) 3937 3944 11 0.0 1312269472.0 0.2X -timestamp + interval(m) 2226 2236 14 0.0 741972014.3 0.4X -timestamp + interval(m, d) 2264 2274 13 0.0 754709121.0 0.4X -timestamp + interval(m, d, ms) 2202 2223 30 0.0 734001075.0 0.4X -timestamp - interval(m) 1992 2005 17 0.0 664152744.7 0.5X -timestamp - interval(m, d) 2069 2075 9 0.0 689631159.0 0.4X -timestamp - interval(m, d, ms) 2240 2244 6 0.0 746538728.0 0.4X +date + interval(m) 1485 1567 116 6.7 148.5 1.0X +date + interval(m, d) 1504 1510 9 6.6 150.4 1.0X +date + interval(m, d, ms) 7000 7013 18 1.4 700.0 0.2X +date - interval(m) 1466 1478 17 6.8 146.6 1.0X +date - interval(m, d) 1533 1534 1 6.5 153.3 1.0X +date - interval(m, d, ms) 7014 7019 7 1.4 701.4 0.2X +timestamp + interval(m) 3062 3064 3 3.3 306.2 0.5X +timestamp + interval(m, d) 3133 3136 5 3.2 313.3 0.5X +timestamp + interval(m, d, ms) 3401 3402 3 2.9 340.1 0.4X +timestamp - interval(m) 3025 3037 17 3.3 302.5 0.5X +timestamp - interval(m, d) 3083 3120 51 3.2 308.3 0.5X +timestamp - interval(m, d, ms) 3371 3379 11 3.0 337.1 0.4X ================================================================================================ Extract components ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz cast to timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -cast to timestamp wholestage off 178 180 3 56.1 17.8 1.0X -cast to timestamp wholestage on 189 192 4 53.0 18.9 0.9X +cast to timestamp wholestage off 339 339 1 29.5 33.9 1.0X +cast to timestamp wholestage on 330 337 9 30.3 33.0 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz year of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -year of timestamp wholestage off 760 761 1 13.2 76.0 1.0X -year of timestamp wholestage on 731 741 10 13.7 73.1 1.0X +year of timestamp wholestage off 1226 1237 15 8.2 122.6 1.0X +year of timestamp wholestage on 1230 1242 9 8.1 123.0 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz quarter of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -quarter of timestamp wholestage off 1005 1013 10 9.9 100.5 1.0X -quarter of timestamp wholestage on 981 986 3 10.2 98.1 1.0X +quarter of timestamp wholestage off 1602 1606 7 6.2 160.2 1.0X +quarter of timestamp wholestage on 1511 1514 3 6.6 151.1 1.1X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz month of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -month of timestamp wholestage off 754 758 6 13.3 75.4 1.0X -month of timestamp wholestage on 719 729 11 13.9 71.9 1.0X +month of timestamp wholestage off 1227 1233 8 8.1 122.7 1.0X +month of timestamp wholestage on 1226 1242 28 8.2 122.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz weekofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -weekofyear of timestamp wholestage off 1085 1088 4 9.2 108.5 1.0X -weekofyear of timestamp wholestage on 1075 1091 13 9.3 107.5 1.0X +weekofyear of timestamp wholestage off 1965 1980 20 5.1 196.5 1.0X +weekofyear of timestamp wholestage on 1816 1833 17 5.5 181.6 1.1X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz day of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -day of timestamp wholestage off 751 770 27 13.3 75.1 1.0X -day of timestamp wholestage on 735 741 7 13.6 73.5 1.0X +day of timestamp wholestage off 1229 1231 3 8.1 122.9 1.0X +day of timestamp wholestage on 1222 1230 10 8.2 122.2 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz dayofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -dayofyear of timestamp wholestage off 765 769 5 13.1 76.5 1.0X -dayofyear of timestamp wholestage on 762 770 7 13.1 76.2 1.0X +dayofyear of timestamp wholestage off 1294 1297 4 7.7 129.4 1.0X +dayofyear of timestamp wholestage on 1257 1264 6 8.0 125.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz dayofmonth of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -dayofmonth of timestamp wholestage off 780 782 2 12.8 78.0 1.0X -dayofmonth of timestamp wholestage on 720 736 12 13.9 72.0 1.1X +dayofmonth of timestamp wholestage off 1247 1253 8 8.0 124.7 1.0X +dayofmonth of timestamp wholestage on 1225 1229 4 8.2 122.5 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz dayofweek of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -dayofweek of timestamp wholestage off 887 899 17 11.3 88.7 1.0X -dayofweek of timestamp wholestage on 820 847 20 12.2 82.0 1.1X +dayofweek of timestamp wholestage off 1416 1416 0 7.1 141.6 1.0X +dayofweek of timestamp wholestage on 1376 1382 8 7.3 137.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz weekday of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -weekday of timestamp wholestage off 821 825 5 12.2 82.1 1.0X -weekday of timestamp wholestage on 802 814 9 12.5 80.2 1.0X +weekday of timestamp wholestage off 1350 1351 1 7.4 135.0 1.0X +weekday of timestamp wholestage on 1308 1318 13 7.6 130.8 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz hour of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -hour of timestamp wholestage off 611 622 14 16.4 61.1 1.0X -hour of timestamp wholestage on 571 577 8 17.5 57.1 1.1X +hour of timestamp wholestage off 1004 1007 3 10.0 100.4 1.0X +hour of timestamp wholestage on 928 938 7 10.8 92.8 1.1X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz minute of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -minute of timestamp wholestage off 607 615 12 16.5 60.7 1.0X -minute of timestamp wholestage on 573 580 6 17.5 57.3 1.1X +minute of timestamp wholestage off 1009 1020 15 9.9 100.9 1.0X +minute of timestamp wholestage on 933 935 2 10.7 93.3 1.1X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz second of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -second of timestamp wholestage off 615 616 2 16.3 61.5 1.0X -second of timestamp wholestage on 564 575 8 17.7 56.4 1.1X +second of timestamp wholestage off 995 995 0 10.0 99.5 1.0X +second of timestamp wholestage on 932 937 8 10.7 93.2 1.1X ================================================================================================ Current date and time ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz current_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -current_date wholestage off 166 169 4 60.4 16.6 1.0X -current_date wholestage on 150 153 3 66.7 15.0 1.1X +current_date wholestage off 292 316 34 34.2 29.2 1.0X +current_date wholestage on 270 276 6 37.0 27.0 1.1X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz current_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -current_timestamp wholestage off 179 181 2 55.8 17.9 1.0X -current_timestamp wholestage on 162 324 138 61.9 16.2 1.1X +current_timestamp wholestage off 313 328 20 31.9 31.3 1.0X +current_timestamp wholestage on 270 331 95 37.0 27.0 1.2X ================================================================================================ Date arithmetic ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz cast to date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -cast to date wholestage off 658 661 5 15.2 65.8 1.0X -cast to date wholestage on 644 654 10 15.5 64.4 1.0X +cast to date wholestage off 1078 1081 3 9.3 107.8 1.0X +cast to date wholestage on 1035 1040 7 9.7 103.5 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz last_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -last_day wholestage off 768 772 5 13.0 76.8 1.0X -last_day wholestage on 737 750 12 13.6 73.7 1.0X +last_day wholestage off 1265 1266 3 7.9 126.5 1.0X +last_day wholestage on 1236 1246 10 8.1 123.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz next_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -next_day wholestage off 691 704 17 14.5 69.1 1.0X -next_day wholestage on 664 676 10 15.1 66.4 1.0X +next_day wholestage off 1118 1118 1 8.9 111.8 1.0X +next_day wholestage on 1085 1090 8 9.2 108.5 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_add: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_add wholestage off 646 646 0 15.5 64.6 1.0X -date_add wholestage on 623 640 13 16.1 62.3 1.0X +date_add wholestage off 1052 1054 4 9.5 105.2 1.0X +date_add wholestage on 1046 1051 6 9.6 104.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_sub: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_sub wholestage off 638 645 9 15.7 63.8 1.0X -date_sub wholestage on 618 629 8 16.2 61.8 1.0X +date_sub wholestage off 1075 1075 0 9.3 107.5 1.0X +date_sub wholestage on 1043 1046 3 9.6 104.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz add_months: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -add_months wholestage off 892 896 5 11.2 89.2 1.0X -add_months wholestage on 926 938 7 10.8 92.6 1.0X +add_months wholestage off 1409 1409 0 7.1 140.9 1.0X +add_months wholestage on 1448 1453 4 6.9 144.8 1.0X ================================================================================================ Formatting dates ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz format date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -format date wholestage off 3395 3439 62 2.9 339.5 1.0X -format date wholestage on 3418 3438 14 2.9 341.8 1.0X +format date wholestage off 5373 5390 24 1.9 537.3 1.0X +format date wholestage on 5337 5346 12 1.9 533.7 1.0X ================================================================================================ Formatting timestamps ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz from_unixtime: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -from_unixtime wholestage off 4565 4592 38 2.2 456.5 1.0X -from_unixtime wholestage on 4608 4635 32 2.2 460.8 1.0X +from_unixtime wholestage off 7302 7308 9 1.4 730.2 1.0X +from_unixtime wholestage on 7298 7319 16 1.4 729.8 1.0X ================================================================================================ Convert timestamps ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz from_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -from_utc_timestamp wholestage off 801 807 9 12.5 80.1 1.0X -from_utc_timestamp wholestage on 819 830 7 12.2 81.9 1.0X +from_utc_timestamp wholestage off 1322 1355 48 7.6 132.2 1.0X +from_utc_timestamp wholestage on 1290 1294 5 7.8 129.0 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_utc_timestamp wholestage off 1108 1114 8 9.0 110.8 1.0X -to_utc_timestamp wholestage on 1067 1078 13 9.4 106.7 1.0X +to_utc_timestamp wholestage off 1692 1705 18 5.9 169.2 1.0X +to_utc_timestamp wholestage on 1653 1657 4 6.1 165.3 1.0X ================================================================================================ Intervals ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz cast interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -cast interval wholestage off 211 213 2 47.4 21.1 1.0X -cast interval wholestage on 185 188 3 54.1 18.5 1.1X +cast interval wholestage off 340 356 22 29.4 34.0 1.0X +cast interval wholestage on 293 296 2 34.1 29.3 1.2X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz datediff: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -datediff wholestage off 1120 1120 1 8.9 112.0 1.0X -datediff wholestage on 1174 1205 19 8.5 117.4 1.0X +datediff wholestage off 1843 1862 28 5.4 184.3 1.0X +datediff wholestage on 1766 1780 16 5.7 176.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz months_between: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -months_between wholestage off 3669 3688 26 2.7 366.9 1.0X -months_between wholestage on 3687 3819 181 2.7 368.7 1.0X +months_between wholestage off 5856 5858 2 1.7 585.6 1.0X +months_between wholestage on 5799 5815 14 1.7 579.9 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz window: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -window wholestage off 1147 1148 1 0.9 1146.6 1.0X -window wholestage on 16997 17207 226 0.1 16996.7 0.1X +window wholestage off 2017 2147 183 0.5 2017.4 1.0X +window wholestage on 47789 47910 91 0.0 47788.6 0.0X ================================================================================================ Truncation ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc YEAR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc YEAR wholestage off 1824 1859 50 5.5 182.4 1.0X -date_trunc YEAR wholestage on 1844 1942 71 5.4 184.4 1.0X +date_trunc YEAR wholestage off 2689 2689 1 3.7 268.9 1.0X +date_trunc YEAR wholestage on 2655 2670 17 3.8 265.5 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc YYYY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc YYYY wholestage off 1808 1815 11 5.5 180.8 1.0X -date_trunc YYYY wholestage on 1833 1864 49 5.5 183.3 1.0X +date_trunc YYYY wholestage off 2698 2700 3 3.7 269.8 1.0X +date_trunc YYYY wholestage on 2654 2660 6 3.8 265.4 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc YY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc YY wholestage off 1867 1883 23 5.4 186.7 1.0X -date_trunc YY wholestage on 1843 1861 15 5.4 184.3 1.0X +date_trunc YY wholestage off 2692 2697 7 3.7 269.2 1.0X +date_trunc YY wholestage on 2653 2662 7 3.8 265.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MON: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MON wholestage off 1845 1858 18 5.4 184.5 1.0X -date_trunc MON wholestage on 1830 1893 42 5.5 183.0 1.0X +date_trunc MON wholestage off 2752 2756 6 3.6 275.2 1.0X +date_trunc MON wholestage on 2666 2675 15 3.8 266.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MONTH: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MONTH wholestage off 1822 1855 47 5.5 182.2 1.0X -date_trunc MONTH wholestage on 1832 1863 20 5.5 183.2 1.0X +date_trunc MONTH wholestage off 2743 2746 4 3.6 274.3 1.0X +date_trunc MONTH wholestage on 2667 2673 8 3.7 266.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MM: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MM wholestage off 1843 1848 7 5.4 184.3 1.0X -date_trunc MM wholestage on 1886 1905 14 5.3 188.6 1.0X +date_trunc MM wholestage off 2741 2741 1 3.6 274.1 1.0X +date_trunc MM wholestage on 2670 2678 7 3.7 267.0 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc DAY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc DAY wholestage off 1542 1545 4 6.5 154.2 1.0X -date_trunc DAY wholestage on 1610 1616 5 6.2 161.0 1.0X +date_trunc DAY wholestage off 2338 2342 6 4.3 233.8 1.0X +date_trunc DAY wholestage on 2269 2277 7 4.4 226.9 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc DD: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc DD wholestage off 1521 1529 11 6.6 152.1 1.0X -date_trunc DD wholestage on 1595 1611 21 6.3 159.5 1.0X +date_trunc DD wholestage off 2324 2325 1 4.3 232.4 1.0X +date_trunc DD wholestage on 2270 2273 2 4.4 227.0 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc HOUR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc HOUR wholestage off 1496 1543 67 6.7 149.6 1.0X -date_trunc HOUR wholestage on 1567 1594 18 6.4 156.7 1.0X +date_trunc HOUR wholestage off 2325 2326 1 4.3 232.5 1.0X +date_trunc HOUR wholestage on 2284 2295 8 4.4 228.4 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MINUTE: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MINUTE wholestage off 230 230 1 43.5 23.0 1.0X -date_trunc MINUTE wholestage on 288 295 7 34.7 28.8 0.8X +date_trunc MINUTE wholestage off 407 408 0 24.5 40.7 1.0X +date_trunc MINUTE wholestage on 382 386 3 26.1 38.2 1.1X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc SECOND: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc SECOND wholestage off 247 249 4 40.5 24.7 1.0X -date_trunc SECOND wholestage on 297 314 12 33.6 29.7 0.8X +date_trunc SECOND wholestage off 404 404 1 24.8 40.4 1.0X +date_trunc SECOND wholestage on 386 390 4 25.9 38.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc WEEK: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc WEEK wholestage off 1786 1788 3 5.6 178.6 1.0X -date_trunc WEEK wholestage on 1786 1832 46 5.6 178.6 1.0X +date_trunc WEEK wholestage off 2693 2694 2 3.7 269.3 1.0X +date_trunc WEEK wholestage on 2619 2629 10 3.8 261.9 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc QUARTER: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc QUARTER wholestage off 2319 2365 66 4.3 231.9 1.0X -date_trunc QUARTER wholestage on 2424 2551 182 4.1 242.4 1.0X +date_trunc QUARTER wholestage off 3454 3466 17 2.9 345.4 1.0X +date_trunc QUARTER wholestage on 3384 3404 24 3.0 338.4 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc year: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc year wholestage off 180 189 12 55.5 18.0 1.0X -trunc year wholestage on 271 277 5 36.9 27.1 0.7X +trunc year wholestage off 339 340 1 29.5 33.9 1.0X +trunc year wholestage on 337 347 9 29.7 33.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc yyyy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc yyyy wholestage off 189 191 4 52.9 18.9 1.0X -trunc yyyy wholestage on 276 284 6 36.2 27.6 0.7X +trunc yyyy wholestage off 347 348 2 28.8 34.7 1.0X +trunc yyyy wholestage on 334 335 2 29.9 33.4 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc yy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc yy wholestage off 189 190 1 52.9 18.9 1.0X -trunc yy wholestage on 279 294 11 35.9 27.9 0.7X +trunc yy wholestage off 339 346 11 29.5 33.9 1.0X +trunc yy wholestage on 333 338 5 30.0 33.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc mon: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc mon wholestage off 185 186 1 54.1 18.5 1.0X -trunc mon wholestage on 272 285 13 36.8 27.2 0.7X +trunc mon wholestage off 339 347 11 29.5 33.9 1.0X +trunc mon wholestage on 331 336 4 30.2 33.1 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc month: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc month wholestage off 190 190 1 52.6 19.0 1.0X -trunc month wholestage on 293 300 4 34.1 29.3 0.6X +trunc month wholestage off 341 344 3 29.3 34.1 1.0X +trunc month wholestage on 332 338 9 30.1 33.2 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc mm: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc mm wholestage off 178 182 6 56.3 17.8 1.0X -trunc mm wholestage on 306 312 5 32.7 30.6 0.6X +trunc mm wholestage off 337 338 1 29.6 33.7 1.0X +trunc mm wholestage on 332 336 5 30.1 33.2 1.0X ================================================================================================ Parsing ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to timestamp str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to timestamp str wholestage off 111 117 8 9.0 110.9 1.0X -to timestamp str wholestage on 101 109 6 9.9 100.6 1.1X +to timestamp str wholestage off 184 187 4 5.4 183.9 1.0X +to timestamp str wholestage on 159 162 2 6.3 159.4 1.2X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_timestamp wholestage off 735 746 15 1.4 734.9 1.0X -to_timestamp wholestage on 708 725 11 1.4 708.2 1.0X +to_timestamp wholestage off 1683 1689 8 0.6 1683.3 1.0X +to_timestamp wholestage on 1722 1725 4 0.6 1721.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_unix_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_unix_timestamp wholestage off 718 727 12 1.4 717.9 1.0X -to_unix_timestamp wholestage on 739 755 12 1.4 739.1 1.0X +to_unix_timestamp wholestage off 1733 1736 4 0.6 1733.1 1.0X +to_unix_timestamp wholestage on 1687 1690 4 0.6 1686.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to date str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to date str wholestage off 124 125 1 8.0 124.4 1.0X -to date str wholestage on 134 138 3 7.5 133.9 0.9X +to date str wholestage off 218 220 4 4.6 217.6 1.0X +to date str wholestage on 213 215 2 4.7 212.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_date wholestage off 1510 1544 48 0.7 1510.4 1.0X -to_date wholestage on 1544 1557 15 0.6 1544.2 1.0X +to_date wholestage off 3697 3699 2 0.3 3697.2 1.0X +to_date wholestage on 3603 3624 15 0.3 3602.7 1.0X ================================================================================================ Conversion from/to external types ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 11.0.5+10-LTS on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 11.0.7+10-post-Ubuntu-2ubuntu218.04 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz To/from Java's date-time: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -From java.sql.Date 269 278 9 18.6 53.7 1.0X -From java.time.LocalDate 227 234 7 22.0 45.4 1.2X -Collect java.sql.Date 1164 1272 141 4.3 232.8 0.2X -Collect java.time.LocalDate 1070 1130 59 4.7 214.1 0.3X -From java.sql.Timestamp 246 248 2 20.3 49.2 1.1X -From java.time.Instant 214 216 2 23.4 42.8 1.3X -Collect longs 814 831 15 6.1 162.7 0.3X -Collect java.sql.Timestamp 1016 1096 78 4.9 203.2 0.3X -Collect java.time.Instant 1012 1093 86 4.9 202.4 0.3X +From java.sql.Date 432 436 7 11.6 86.4 1.0X +From java.time.LocalDate 343 347 6 14.6 68.6 1.3X +Collect java.sql.Date 1888 2453 971 2.6 377.6 0.2X +Collect java.time.LocalDate 1779 1820 42 2.8 355.7 0.2X +From java.sql.Timestamp 375 384 9 13.3 75.0 1.2X +From java.time.Instant 317 326 8 15.8 63.5 1.4X +Collect longs 1338 1428 115 3.7 267.6 0.3X +Collect java.sql.Timestamp 1716 2014 281 2.9 343.1 0.3X +Collect java.time.Instant 1832 1970 122 2.7 366.5 0.2X diff --git a/sql/core/benchmarks/DateTimeBenchmark-results.txt b/sql/core/benchmarks/DateTimeBenchmark-results.txt index dba6c90..3ef2f92 100644 --- a/sql/core/benchmarks/DateTimeBenchmark-results.txt +++ b/sql/core/benchmarks/DateTimeBenchmark-results.txt @@ -2,456 +2,456 @@ datetime +/- interval ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz datetime +/- interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date + interval(m) 1003 1012 13 0.0 334353721.7 1.0X -date + interval(m, d) 1154 1174 29 0.0 384575202.7 0.9X -date + interval(m, d, ms) 4338 4366 40 0.0 1446002701.3 0.2X -date - interval(m) 850 858 8 0.0 283424914.7 1.2X -date - interval(m, d) 1017 1031 19 0.0 339034354.7 1.0X -date - interval(m, d, ms) 4699 4717 25 0.0 1566218686.3 0.2X -timestamp + interval(m) 2044 2046 3 0.0 681382301.0 0.5X -timestamp + interval(m, d) 2215 2249 48 0.0 738464286.7 0.5X -timestamp + interval(m, d, ms) 2053 2063 13 0.0 684393366.0 0.5X -timestamp - interval(m) 1668 1677 12 0.0 556138256.7 0.6X -timestamp - interval(m, d) 1865 1882 25 0.0 621574795.3 0.5X -timestamp - interval(m, d, ms) 2075 2077 3 0.0 691569937.3 0.5X +date + interval(m) 1613 1622 13 6.2 161.3 1.0X +date + interval(m, d) 1729 1752 32 5.8 172.9 0.9X +date + interval(m, d, ms) 6421 6424 5 1.6 642.1 0.3X +date - interval(m) 1441 1443 2 6.9 144.1 1.1X +date - interval(m, d) 1687 1689 2 5.9 168.7 1.0X +date - interval(m, d, ms) 6617 6625 11 1.5 661.7 0.2X +timestamp + interval(m) 2713 2733 28 3.7 271.3 0.6X +timestamp + interval(m, d) 3027 3032 8 3.3 302.7 0.5X +timestamp + interval(m, d, ms) 3501 3509 12 2.9 350.1 0.5X +timestamp - interval(m) 2892 2895 4 3.5 289.2 0.6X +timestamp - interval(m, d) 3190 3196 9 3.1 319.0 0.5X +timestamp - interval(m, d, ms) 3497 3500 5 2.9 349.7 0.5X ================================================================================================ Extract components ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz cast to timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -cast to timestamp wholestage off 192 192 0 52.2 19.2 1.0X -cast to timestamp wholestage on 163 166 3 61.3 16.3 1.2X +cast to timestamp wholestage off 321 323 2 31.1 32.1 1.0X +cast to timestamp wholestage on 294 306 10 34.0 29.4 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz year of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -year of timestamp wholestage off 743 745 4 13.5 74.3 1.0X -year of timestamp wholestage on 708 715 5 14.1 70.8 1.0X +year of timestamp wholestage off 1235 1242 9 8.1 123.5 1.0X +year of timestamp wholestage on 1208 1216 8 8.3 120.8 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz quarter of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -quarter of timestamp wholestage off 848 857 12 11.8 84.8 1.0X -quarter of timestamp wholestage on 803 813 6 12.5 80.3 1.1X +quarter of timestamp wholestage off 1415 1424 12 7.1 141.5 1.0X +quarter of timestamp wholestage on 1338 1341 4 7.5 133.8 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz month of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -month of timestamp wholestage off 740 745 7 13.5 74.0 1.0X -month of timestamp wholestage on 703 710 5 14.2 70.3 1.1X +month of timestamp wholestage off 1224 1225 1 8.2 122.4 1.0X +month of timestamp wholestage on 1193 1202 8 8.4 119.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz weekofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -weekofyear of timestamp wholestage off 1162 1182 28 8.6 116.2 1.0X -weekofyear of timestamp wholestage on 1093 1102 9 9.2 109.3 1.1X +weekofyear of timestamp wholestage off 1864 1866 3 5.4 186.4 1.0X +weekofyear of timestamp wholestage on 1827 1840 7 5.5 182.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz day of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -day of timestamp wholestage off 742 748 9 13.5 74.2 1.0X -day of timestamp wholestage on 703 713 7 14.2 70.3 1.1X +day of timestamp wholestage off 1209 1211 2 8.3 120.9 1.0X +day of timestamp wholestage on 1191 1194 6 8.4 119.1 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz dayofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -dayofyear of timestamp wholestage off 791 799 11 12.6 79.1 1.0X -dayofyear of timestamp wholestage on 732 744 9 13.7 73.2 1.1X +dayofyear of timestamp wholestage off 1270 1271 2 7.9 127.0 1.0X +dayofyear of timestamp wholestage on 1241 1250 12 8.1 124.1 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz dayofmonth of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -dayofmonth of timestamp wholestage off 738 752 20 13.6 73.8 1.0X -dayofmonth of timestamp wholestage on 695 712 9 14.4 69.5 1.1X +dayofmonth of timestamp wholestage off 1236 1250 20 8.1 123.6 1.0X +dayofmonth of timestamp wholestage on 1193 1195 3 8.4 119.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz dayofweek of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -dayofweek of timestamp wholestage off 854 856 3 11.7 85.4 1.0X -dayofweek of timestamp wholestage on 819 839 16 12.2 81.9 1.0X +dayofweek of timestamp wholestage off 1402 1405 4 7.1 140.2 1.0X +dayofweek of timestamp wholestage on 1352 1359 7 7.4 135.2 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz weekday of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -weekday of timestamp wholestage off 816 821 7 12.3 81.6 1.0X -weekday of timestamp wholestage on 788 800 8 12.7 78.8 1.0X +weekday of timestamp wholestage off 1346 1347 2 7.4 134.6 1.0X +weekday of timestamp wholestage on 1294 1299 7 7.7 129.4 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz hour of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -hour of timestamp wholestage off 595 595 1 16.8 59.5 1.0X -hour of timestamp wholestage on 533 541 10 18.8 53.3 1.1X +hour of timestamp wholestage off 1000 1008 11 10.0 100.0 1.0X +hour of timestamp wholestage on 936 941 6 10.7 93.6 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz minute of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -minute of timestamp wholestage off 585 588 4 17.1 58.5 1.0X -minute of timestamp wholestage on 532 545 11 18.8 53.2 1.1X +minute of timestamp wholestage off 969 976 10 10.3 96.9 1.0X +minute of timestamp wholestage on 933 936 4 10.7 93.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz second of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -second of timestamp wholestage off 579 589 13 17.3 57.9 1.0X -second of timestamp wholestage on 529 537 6 18.9 52.9 1.1X +second of timestamp wholestage off 1002 1005 3 10.0 100.2 1.0X +second of timestamp wholestage on 935 938 2 10.7 93.5 1.1X ================================================================================================ Current date and time ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz current_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -current_date wholestage off 171 174 4 58.4 17.1 1.0X -current_date wholestage on 152 155 3 65.6 15.2 1.1X +current_date wholestage off 308 316 11 32.5 30.8 1.0X +current_date wholestage on 265 275 12 37.8 26.5 1.2X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz current_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -current_timestamp wholestage off 178 181 4 56.2 17.8 1.0X -current_timestamp wholestage on 138 149 7 72.6 13.8 1.3X +current_timestamp wholestage off 307 312 7 32.6 30.7 1.0X +current_timestamp wholestage on 263 268 5 38.1 26.3 1.2X ================================================================================================ Date arithmetic ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz cast to date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -cast to date wholestage off 630 640 14 15.9 63.0 1.0X -cast to date wholestage on 591 594 5 16.9 59.1 1.1X +cast to date wholestage off 1061 1065 5 9.4 106.1 1.0X +cast to date wholestage on 985 991 11 10.2 98.5 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz last_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -last_day wholestage off 759 778 26 13.2 75.9 1.0X -last_day wholestage on 727 736 9 13.8 72.7 1.0X +last_day wholestage off 1261 1262 1 7.9 126.1 1.0X +last_day wholestage on 1223 1235 12 8.2 122.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz next_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -next_day wholestage off 649 659 15 15.4 64.9 1.0X -next_day wholestage on 628 629 1 15.9 62.8 1.0X +next_day wholestage off 1114 1119 7 9.0 111.4 1.0X +next_day wholestage on 1034 1038 3 9.7 103.4 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_add: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_add wholestage off 621 622 1 16.1 62.1 1.0X -date_add wholestage on 600 606 6 16.7 60.0 1.0X +date_add wholestage off 1059 1076 25 9.4 105.9 1.0X +date_add wholestage on 1012 1021 9 9.9 101.2 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_sub: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_sub wholestage off 611 626 21 16.4 61.1 1.0X -date_sub wholestage on 588 600 7 17.0 58.8 1.0X +date_sub wholestage off 1046 1046 0 9.6 104.6 1.0X +date_sub wholestage on 1019 1023 3 9.8 101.9 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz add_months: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -add_months wholestage off 843 845 2 11.9 84.3 1.0X -add_months wholestage on 818 831 11 12.2 81.8 1.0X +add_months wholestage off 1392 1393 1 7.2 139.2 1.0X +add_months wholestage on 1335 1346 14 7.5 133.5 1.0X ================================================================================================ Formatting dates ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz format date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -format date wholestage off 3557 3569 18 2.8 355.7 1.0X -format date wholestage on 3564 3588 17 2.8 356.4 1.0X +format date wholestage off 5959 5994 50 1.7 595.9 1.0X +format date wholestage on 5991 6008 28 1.7 599.1 1.0X ================================================================================================ Formatting timestamps ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz from_unixtime: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -from_unixtime wholestage off 4875 4887 17 2.1 487.5 1.0X -from_unixtime wholestage on 4845 4870 16 2.1 484.5 1.0X +from_unixtime wholestage off 8851 8872 29 1.1 885.1 1.0X +from_unixtime wholestage on 8855 8872 10 1.1 885.5 1.0X ================================================================================================ Convert timestamps ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz from_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -from_utc_timestamp wholestage off 665 671 8 15.0 66.5 1.0X -from_utc_timestamp wholestage on 654 672 14 15.3 65.4 1.0X +from_utc_timestamp wholestage off 1105 1107 2 9.0 110.5 1.0X +from_utc_timestamp wholestage on 1072 1084 11 9.3 107.2 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_utc_timestamp wholestage off 982 983 1 10.2 98.2 1.0X -to_utc_timestamp wholestage on 877 889 9 11.4 87.7 1.1X +to_utc_timestamp wholestage off 1531 1534 3 6.5 153.1 1.0X +to_utc_timestamp wholestage on 1451 1463 14 6.9 145.1 1.1X ================================================================================================ Intervals ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz cast interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -cast interval wholestage off 200 206 9 50.1 20.0 1.0X -cast interval wholestage on 157 163 5 63.6 15.7 1.3X +cast interval wholestage off 360 366 8 27.8 36.0 1.0X +cast interval wholestage on 286 292 7 35.0 28.6 1.3X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz datediff: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -datediff wholestage off 1065 1068 4 9.4 106.5 1.0X -datediff wholestage on 1028 1047 15 9.7 102.8 1.0X +datediff wholestage off 1809 1814 8 5.5 180.9 1.0X +datediff wholestage on 1742 1751 8 5.7 174.2 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz months_between: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -months_between wholestage off 3102 3111 13 3.2 310.2 1.0X -months_between wholestage on 2970 3028 46 3.4 297.0 1.0X +months_between wholestage off 5007 5007 1 2.0 500.7 1.0X +months_between wholestage on 4957 4980 35 2.0 495.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz window: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -window wholestage off 1142 1154 16 0.9 1142.2 1.0X -window wholestage on 14817 15049 257 0.1 14816.5 0.1X +window wholestage off 1945 2027 116 0.5 1945.3 1.0X +window wholestage on 45637 45648 8 0.0 45637.2 0.0X ================================================================================================ Truncation ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc YEAR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc YEAR wholestage off 1516 1518 2 6.6 151.6 1.0X -date_trunc YEAR wholestage on 1458 1468 9 6.9 145.8 1.0X +date_trunc YEAR wholestage off 2463 2465 2 4.1 246.3 1.0X +date_trunc YEAR wholestage on 2406 2409 3 4.2 240.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc YYYY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc YYYY wholestage off 1535 1535 1 6.5 153.5 1.0X -date_trunc YYYY wholestage on 1453 1461 7 6.9 145.3 1.1X +date_trunc YYYY wholestage off 2462 2463 1 4.1 246.2 1.0X +date_trunc YYYY wholestage on 2407 2411 6 4.2 240.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc YY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc YY wholestage off 1561 1567 9 6.4 156.1 1.0X -date_trunc YY wholestage on 1452 1467 16 6.9 145.2 1.1X +date_trunc YY wholestage off 2462 2466 6 4.1 246.2 1.0X +date_trunc YY wholestage on 2401 2406 4 4.2 240.1 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MON: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MON wholestage off 1522 1531 13 6.6 152.2 1.0X -date_trunc MON wholestage on 1458 1467 7 6.9 145.8 1.0X +date_trunc MON wholestage off 2437 2437 0 4.1 243.7 1.0X +date_trunc MON wholestage on 2416 2421 6 4.1 241.6 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MONTH: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MONTH wholestage off 1518 1519 0 6.6 151.8 1.0X -date_trunc MONTH wholestage on 1452 1465 16 6.9 145.2 1.0X +date_trunc MONTH wholestage off 2430 2437 9 4.1 243.0 1.0X +date_trunc MONTH wholestage on 2417 2423 5 4.1 241.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MM: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MM wholestage off 1531 1532 1 6.5 153.1 1.0X -date_trunc MM wholestage on 1453 1463 8 6.9 145.3 1.1X +date_trunc MM wholestage off 2429 2431 3 4.1 242.9 1.0X +date_trunc MM wholestage on 2417 2421 4 4.1 241.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc DAY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc DAY wholestage off 1287 1309 31 7.8 128.7 1.0X -date_trunc DAY wholestage on 1310 1337 16 7.6 131.0 1.0X +date_trunc DAY wholestage off 2074 2075 2 4.8 207.4 1.0X +date_trunc DAY wholestage on 2001 2010 16 5.0 200.1 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc DD: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc DD wholestage off 1322 1328 9 7.6 132.2 1.0X -date_trunc DD wholestage on 1282 1324 28 7.8 128.2 1.0X +date_trunc DD wholestage off 2067 2067 0 4.8 206.7 1.0X +date_trunc DD wholestage on 2000 2003 3 5.0 200.0 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc HOUR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc HOUR wholestage off 1379 1393 20 7.3 137.9 1.0X -date_trunc HOUR wholestage on 1288 1302 11 7.8 128.8 1.1X +date_trunc HOUR wholestage off 2074 2084 14 4.8 207.4 1.0X +date_trunc HOUR wholestage on 2057 2067 10 4.9 205.7 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc MINUTE: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc MINUTE wholestage off 243 245 2 41.2 24.3 1.0X -date_trunc MINUTE wholestage on 213 219 8 47.0 21.3 1.1X +date_trunc MINUTE wholestage off 362 364 3 27.6 36.2 1.0X +date_trunc MINUTE wholestage on 319 333 14 31.3 31.9 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc SECOND: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc SECOND wholestage off 238 245 11 42.1 23.8 1.0X -date_trunc SECOND wholestage on 201 210 9 49.7 20.1 1.2X +date_trunc SECOND wholestage off 361 366 7 27.7 36.1 1.0X +date_trunc SECOND wholestage on 324 341 23 30.9 32.4 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc WEEK: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc WEEK wholestage off 1443 1477 49 6.9 144.3 1.0X -date_trunc WEEK wholestage on 1491 1516 17 6.7 149.1 1.0X +date_trunc WEEK wholestage off 2385 2393 11 4.2 238.5 1.0X +date_trunc WEEK wholestage on 2313 2322 6 4.3 231.3 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz date_trunc QUARTER: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -date_trunc QUARTER wholestage off 2017 2039 32 5.0 201.7 1.0X -date_trunc QUARTER wholestage on 1966 2005 36 5.1 196.6 1.0X +date_trunc QUARTER wholestage off 3278 3280 2 3.1 327.8 1.0X +date_trunc QUARTER wholestage on 3228 3234 8 3.1 322.8 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc year: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc year wholestage off 206 206 1 48.6 20.6 1.0X -trunc year wholestage on 175 178 2 57.2 17.5 1.2X +trunc year wholestage off 328 331 4 30.5 32.8 1.0X +trunc year wholestage on 286 295 9 35.0 28.6 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc yyyy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc yyyy wholestage off 188 189 2 53.2 18.8 1.0X -trunc yyyy wholestage on 176 180 4 56.9 17.6 1.1X +trunc yyyy wholestage off 317 319 3 31.5 31.7 1.0X +trunc yyyy wholestage on 283 287 6 35.3 28.3 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc yy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc yy wholestage off 191 191 0 52.4 19.1 1.0X -trunc yy wholestage on 175 180 4 57.0 17.5 1.1X +trunc yy wholestage off 321 321 0 31.1 32.1 1.0X +trunc yy wholestage on 284 293 11 35.2 28.4 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc mon: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc mon wholestage off 203 205 3 49.3 20.3 1.0X -trunc mon wholestage on 183 186 2 54.8 18.3 1.1X +trunc mon wholestage off 318 319 1 31.4 31.8 1.0X +trunc mon wholestage on 283 287 4 35.4 28.3 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc month: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc month wholestage off 199 199 0 50.3 19.9 1.0X -trunc month wholestage on 177 179 2 56.4 17.7 1.1X +trunc month wholestage off 319 321 3 31.3 31.9 1.0X +trunc month wholestage on 286 293 7 35.0 28.6 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz trunc mm: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -trunc mm wholestage off 198 198 1 50.5 19.8 1.0X -trunc mm wholestage on 180 183 3 55.7 18.0 1.1X +trunc mm wholestage off 317 319 2 31.5 31.7 1.0X +trunc mm wholestage on 282 285 3 35.4 28.2 1.1X ================================================================================================ Parsing ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to timestamp str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to timestamp str wholestage off 138 139 2 7.2 138.2 1.0X -to timestamp str wholestage on 129 138 7 7.8 128.9 1.1X +to timestamp str wholestage off 219 220 0 4.6 219.4 1.0X +to timestamp str wholestage on 214 218 6 4.7 214.1 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_timestamp wholestage off 885 889 5 1.1 885.3 1.0X -to_timestamp wholestage on 854 866 10 1.2 854.0 1.0X +to_timestamp wholestage off 1912 1913 2 0.5 1912.0 1.0X +to_timestamp wholestage on 1671 1675 7 0.6 1670.8 1.1X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_unix_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_unix_timestamp wholestage off 848 856 12 1.2 848.1 1.0X -to_unix_timestamp wholestage on 826 850 18 1.2 826.4 1.0X +to_unix_timestamp wholestage off 1761 1763 3 0.6 1761.1 1.0X +to_unix_timestamp wholestage on 1695 1697 2 0.6 1695.4 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to date str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to date str wholestage off 167 171 5 6.0 167.2 1.0X -to date str wholestage on 165 173 4 6.1 165.0 1.0X +to date str wholestage off 267 272 7 3.7 266.9 1.0X +to date str wholestage on 266 267 2 3.8 265.8 1.0X -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz to_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -to_date wholestage off 1612 1633 31 0.6 1611.7 1.0X -to_date wholestage on 1588 1605 19 0.6 1588.2 1.0X +to_date wholestage off 3705 3743 55 0.3 3704.6 1.0X +to_date wholestage on 3736 3746 11 0.3 3736.4 1.0X ================================================================================================ Conversion from/to external types ================================================================================================ -Java HotSpot(TM) 64-Bit Server VM 1.8.0_251-b08 on Mac OS X 10.15.4 -Intel(R) Core(TM) i9-9980HK CPU @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws +Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz To/from Java's date-time: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -From java.sql.Date 245 247 1 20.4 49.0 1.0X -From java.time.LocalDate 228 233 4 21.9 45.6 1.1X -Collect java.sql.Date 1239 1361 209 4.0 247.9 0.2X -Collect java.time.LocalDate 1049 1107 54 4.8 209.8 0.2X -From java.sql.Timestamp 247 252 4 20.2 49.5 1.0X -From java.time.Instant 156 158 3 32.1 31.2 1.6X -Collect longs 854 910 59 5.9 170.8 0.3X -Collect java.sql.Timestamp 1133 1140 12 4.4 226.6 0.2X -Collect java.time.Instant 1108 1159 74 4.5 221.7 0.2X +From java.sql.Date 400 406 6 12.5 80.1 1.0X +From java.time.LocalDate 343 349 7 14.6 68.6 1.2X +Collect java.sql.Date 1904 2739 1170 2.6 380.9 0.2X +Collect java.time.LocalDate 1477 1495 19 3.4 295.3 0.3X +From java.sql.Timestamp 376 388 10 13.3 75.2 1.1X +From java.time.Instant 237 239 3 21.1 47.4 1.7X +Collect longs 1258 1356 111 4.0 251.7 0.3X +Collect java.sql.Timestamp 1878 1937 64 2.7 375.6 0.2X +Collect java.time.Instant 1667 1904 238 3.0 333.4 0.2X diff --git a/sql/core/src/test/scala/org/apache/spark/sql/execution/benchmark/DateTimeBenchmark.scala b/sql/core/src/test/scala/org/apache/spark/sql/execution/benchmark/DateTimeBenchmark.scala index 0034819..f56efa3 100644 --- a/sql/core/src/test/scala/org/apache/spark/sql/execution/benchmark/DateTimeBenchmark.scala +++ b/sql/core/src/test/scala/org/apache/spark/sql/execution/benchmark/DateTimeBenchmark.scala @@ -61,7 +61,7 @@ object DateTimeBenchmark extends SqlBasedBenchmark { withSQLConf(SQLConf.SESSION_LOCAL_TIMEZONE.key -> LA.getId) { val N = 10000000 runBenchmark("datetime +/- interval") { - val benchmark = new Benchmark("datetime +/- interval", 3, output = output) + val benchmark = new Benchmark("datetime +/- interval", N, output = output) val ts = "cast(id as timestamp)" val dt = s"cast($ts as date)" benchmark.addCase("date + interval(m)") { _ => --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org