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
