/
ExtractBenchmark-results.txt
104 lines (98 loc) · 10.8 KB
/
ExtractBenchmark-results.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Invoke extract for timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
cast to timestamp 333 462 204 30.0 33.3 1.0X
YEAR of timestamp 1116 1189 64 9.0 111.6 0.3X
YEAROFWEEK of timestamp 1426 1440 16 7.0 142.6 0.2X
QUARTER of timestamp 1446 1481 38 6.9 144.6 0.2X
MONTH of timestamp 1221 1235 16 8.2 122.1 0.3X
WEEK of timestamp 2351 2403 86 4.3 235.1 0.1X
DAY of timestamp 1220 1229 10 8.2 122.0 0.3X
DAYOFWEEK of timestamp 1420 1431 13 7.0 142.0 0.2X
DOW of timestamp 1427 1440 19 7.0 142.7 0.2X
DOW_ISO of timestamp 1359 1369 9 7.4 135.9 0.2X
DAYOFWEEK_ISO of timestamp 1355 1366 11 7.4 135.5 0.2X
DOY of timestamp 1267 1276 15 7.9 126.7 0.3X
HOUR of timestamp 924 943 27 10.8 92.4 0.4X
MINUTE of timestamp 915 934 19 10.9 91.5 0.4X
SECOND of timestamp 1139 1150 17 8.8 113.9 0.3X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Invoke date_part for timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
cast to timestamp 382 394 16 26.2 38.2 1.0X
YEAR of timestamp 1161 1169 8 8.6 116.1 0.3X
YEAROFWEEK of timestamp 1405 1421 17 7.1 140.5 0.3X
QUARTER of timestamp 1435 1452 23 7.0 143.5 0.3X
MONTH of timestamp 1194 1203 10 8.4 119.4 0.3X
WEEK of timestamp 2314 2340 25 4.3 231.4 0.2X
DAY of timestamp 1188 1210 26 8.4 118.8 0.3X
DAYOFWEEK of timestamp 1389 1406 15 7.2 138.9 0.3X
DOW of timestamp 1392 1408 26 7.2 139.2 0.3X
DOW_ISO of timestamp 1316 1335 21 7.6 131.6 0.3X
DAYOFWEEK_ISO of timestamp 1315 1321 7 7.6 131.5 0.3X
DOY of timestamp 1261 1280 18 7.9 126.1 0.3X
HOUR of timestamp 905 908 6 11.1 90.5 0.4X
MINUTE of timestamp 902 922 27 11.1 90.2 0.4X
SECOND of timestamp 1122 1126 6 8.9 112.2 0.3X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Invoke extract for date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
cast to date 1083 1105 20 9.2 108.3 1.0X
YEAR of date 1158 1172 14 8.6 115.8 0.9X
YEAROFWEEK of date 1381 1394 12 7.2 138.1 0.8X
QUARTER of date 1441 1442 1 6.9 144.1 0.8X
MONTH of date 1196 1203 10 8.4 119.6 0.9X
WEEK of date 2308 2325 15 4.3 230.8 0.5X
DAY of date 1172 1196 27 8.5 117.2 0.9X
DAYOFWEEK of date 1397 1404 13 7.2 139.7 0.8X
DOW of date 1401 1412 17 7.1 140.1 0.8X
DOW_ISO of date 1309 1325 15 7.6 130.9 0.8X
DAYOFWEEK_ISO of date 1321 1329 9 7.6 132.1 0.8X
DOY of date 1221 1235 14 8.2 122.1 0.9X
HOUR of date 1923 1989 69 5.2 192.3 0.6X
MINUTE of date 1900 1907 12 5.3 190.0 0.6X
SECOND of date 2119 2133 15 4.7 211.9 0.5X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Invoke date_part for date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
cast to date 1068 1084 20 9.4 106.8 1.0X
YEAR of date 1157 1167 8 8.6 115.7 0.9X
YEAROFWEEK of date 1379 1395 14 7.3 137.9 0.8X
QUARTER of date 1436 1439 2 7.0 143.6 0.7X
MONTH of date 1175 1189 12 8.5 117.5 0.9X
WEEK of date 2329 2332 5 4.3 232.9 0.5X
DAY of date 1182 1189 6 8.5 118.2 0.9X
DAYOFWEEK of date 1386 1412 25 7.2 138.6 0.8X
DOW of date 1386 1394 14 7.2 138.6 0.8X
DOW_ISO of date 1311 1342 41 7.6 131.1 0.8X
DAYOFWEEK_ISO of date 1312 1328 14 7.6 131.2 0.8X
DOY of date 1222 1234 11 8.2 122.2 0.9X
HOUR of date 1897 1906 8 5.3 189.7 0.6X
MINUTE of date 1913 1928 16 5.2 191.3 0.6X
SECOND of date 2120 2132 13 4.7 212.0 0.5X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Invoke extract for interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
cast to interval 1422 1450 30 7.0 142.2 1.0X
YEAR of interval 1472 1482 14 6.8 147.2 1.0X
MONTH of interval 1482 1495 12 6.7 148.2 1.0X
DAY of interval 1483 1492 8 6.7 148.3 1.0X
HOUR of interval 1491 1502 15 6.7 149.1 1.0X
MINUTE of interval 1491 1495 4 6.7 149.1 1.0X
SECOND of interval 1605 1618 19 6.2 160.5 0.9X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Invoke date_part for interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
cast to interval 1452 1468 23 6.9 145.2 1.0X
YEAR of interval 1467 1479 12 6.8 146.7 1.0X
MONTH of interval 1487 1498 10 6.7 148.7 1.0X
DAY of interval 1486 1492 7 6.7 148.6 1.0X
HOUR of interval 1489 1493 4 6.7 148.9 1.0X
MINUTE of interval 1488 1492 4 6.7 148.8 1.0X
SECOND of interval 1599 1613 16 6.3 159.9 0.9X