/
DateTimeRebaseBenchmark-jdk17-results.txt
154 lines (138 loc) · 14.5 KB
/
DateTimeRebaseBenchmark-jdk17-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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
================================================================================================
Rebasing dates/timestamps in Parquet datasource
================================================================================================
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Save DATE to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1582, noop 17033 17033 0 5.9 170.3 1.0X
before 1582, noop 10663 10663 0 9.4 106.6 1.6X
after 1582, rebase EXCEPTION 28651 28651 0 3.5 286.5 0.6X
after 1582, rebase LEGACY 28505 28505 0 3.5 285.0 0.6X
after 1582, rebase CORRECTED 29190 29190 0 3.4 291.9 0.6X
before 1582, rebase LEGACY 25420 25420 0 3.9 254.2 0.7X
before 1582, rebase CORRECTED 22736 22736 0 4.4 227.4 0.7X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Load DATE from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1582, vec off, rebase EXCEPTION 13103 13188 106 7.6 131.0 1.0X
after 1582, vec off, rebase LEGACY 12718 12761 40 7.9 127.2 1.0X
after 1582, vec off, rebase CORRECTED 12882 12921 57 7.8 128.8 1.0X
after 1582, vec on, rebase EXCEPTION 4733 4851 150 21.1 47.3 2.8X
after 1582, vec on, rebase LEGACY 4802 4901 95 20.8 48.0 2.7X
after 1582, vec on, rebase CORRECTED 4727 4804 119 21.2 47.3 2.8X
before 1582, vec off, rebase LEGACY 13751 13795 55 7.3 137.5 1.0X
before 1582, vec off, rebase CORRECTED 12706 12790 89 7.9 127.1 1.0X
before 1582, vec on, rebase LEGACY 6183 6232 54 16.2 61.8 2.1X
before 1582, vec on, rebase CORRECTED 4760 4828 59 21.0 47.6 2.8X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Save TIMESTAMP_INT96 to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, noop 3980 3980 0 25.1 39.8 1.0X
before 1900, noop 3790 3790 0 26.4 37.9 1.1X
after 1900, rebase EXCEPTION 18601 18601 0 5.4 186.0 0.2X
after 1900, rebase LEGACY 18286 18286 0 5.5 182.9 0.2X
after 1900, rebase CORRECTED 19499 19499 0 5.1 195.0 0.2X
before 1900, rebase LEGACY 21613 21613 0 4.6 216.1 0.2X
before 1900, rebase CORRECTED 19612 19612 0 5.1 196.1 0.2X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Load TIMESTAMP_INT96 from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, vec off, rebase EXCEPTION 20143 20220 125 5.0 201.4 1.0X
after 1900, vec off, rebase LEGACY 19895 19935 40 5.0 199.0 1.0X
after 1900, vec off, rebase CORRECTED 20084 20279 174 5.0 200.8 1.0X
after 1900, vec on, rebase EXCEPTION 6477 6509 41 15.4 64.8 3.1X
after 1900, vec on, rebase LEGACY 6663 6707 55 15.0 66.6 3.0X
after 1900, vec on, rebase CORRECTED 6499 6545 59 15.4 65.0 3.1X
before 1900, vec off, rebase LEGACY 22907 22981 65 4.4 229.1 0.9X
before 1900, vec off, rebase CORRECTED 20329 20470 188 4.9 203.3 1.0X
before 1900, vec on, rebase LEGACY 9380 9423 40 10.7 93.8 2.1X
before 1900, vec on, rebase CORRECTED 6633 6697 69 15.1 66.3 3.0X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Save TIMESTAMP_MICROS to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, noop 3916 3916 0 25.5 39.2 1.0X
before 1900, noop 3883 3883 0 25.8 38.8 1.0X
after 1900, rebase EXCEPTION 17247 17247 0 5.8 172.5 0.2X
after 1900, rebase LEGACY 16909 16909 0 5.9 169.1 0.2X
after 1900, rebase CORRECTED 17523 17523 0 5.7 175.2 0.2X
before 1900, rebase LEGACY 19751 19751 0 5.1 197.5 0.2X
before 1900, rebase CORRECTED 17816 17816 0 5.6 178.2 0.2X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Load TIMESTAMP_MICROS from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, vec off, rebase EXCEPTION 15900 15938 45 6.3 159.0 1.0X
after 1900, vec off, rebase LEGACY 15998 16044 47 6.3 160.0 1.0X
after 1900, vec off, rebase CORRECTED 15801 15829 41 6.3 158.0 1.0X
after 1900, vec on, rebase EXCEPTION 5898 5956 59 17.0 59.0 2.7X
after 1900, vec on, rebase LEGACY 5938 5954 26 16.8 59.4 2.7X
after 1900, vec on, rebase CORRECTED 5803 5821 15 17.2 58.0 2.7X
before 1900, vec off, rebase LEGACY 18723 18833 189 5.3 187.2 0.8X
before 1900, vec off, rebase CORRECTED 15765 15801 34 6.3 157.7 1.0X
before 1900, vec on, rebase LEGACY 8285 8368 77 12.1 82.8 1.9X
before 1900, vec on, rebase CORRECTED 5783 5825 45 17.3 57.8 2.7X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Save TIMESTAMP_MILLIS to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, noop 3887 3887 0 25.7 38.9 1.0X
before 1900, noop 3862 3862 0 25.9 38.6 1.0X
after 1900, rebase EXCEPTION 15900 15900 0 6.3 159.0 0.2X
after 1900, rebase LEGACY 17154 17154 0 5.8 171.5 0.2X
after 1900, rebase CORRECTED 17706 17706 0 5.6 177.1 0.2X
before 1900, rebase LEGACY 19370 19370 0 5.2 193.7 0.2X
before 1900, rebase CORRECTED 17245 17245 0 5.8 172.5 0.2X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Load TIMESTAMP_MILLIS from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, vec off, rebase EXCEPTION 16107 16137 32 6.2 161.1 1.0X
after 1900, vec off, rebase LEGACY 16390 16480 96 6.1 163.9 1.0X
after 1900, vec off, rebase CORRECTED 16621 16697 119 6.0 166.2 1.0X
after 1900, vec on, rebase EXCEPTION 6061 6077 23 16.5 60.6 2.7X
after 1900, vec on, rebase LEGACY 7011 7068 74 14.3 70.1 2.3X
after 1900, vec on, rebase CORRECTED 5923 5950 28 16.9 59.2 2.7X
before 1900, vec off, rebase LEGACY 19048 19079 27 5.2 190.5 0.8X
before 1900, vec off, rebase CORRECTED 16425 16519 96 6.1 164.2 1.0X
before 1900, vec on, rebase LEGACY 8835 8969 173 11.3 88.4 1.8X
before 1900, vec on, rebase CORRECTED 5989 6008 32 16.7 59.9 2.7X
================================================================================================
Rebasing dates/timestamps in ORC datasource
================================================================================================
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Save DATE to ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1582, noop 17408 17408 0 5.7 174.1 1.0X
before 1582, noop 10818 10818 0 9.2 108.2 1.6X
after 1582 23092 23092 0 4.3 230.9 0.8X
before 1582 18974 18974 0 5.3 189.7 0.9X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Load DATE from ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1582, vec off 10834 10857 21 9.2 108.3 1.0X
after 1582, vec on 4477 4488 13 22.3 44.8 2.4X
before 1582, vec off 12225 12234 8 8.2 122.3 0.9X
before 1582, vec on 5537 5545 13 18.1 55.4 2.0X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Save TIMESTAMP to ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, noop 3833 3833 0 26.1 38.3 1.0X
before 1900, noop 3830 3830 0 26.1 38.3 1.0X
after 1900 14665 14665 0 6.8 146.6 0.3X
before 1900 17466 17466 0 5.7 174.7 0.2X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz
Load TIMESTAMP from ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
after 1900, vec off 13605 13643 51 7.4 136.1 1.0X
after 1900, vec on 6552 6609 61 15.3 65.5 2.1X
before 1900, vec off 15715 15727 14 6.4 157.2 0.9X
before 1900, vec on 8632 8669 33 11.6 86.3 1.6X