/
DateTimeRebaseBenchmark-jdk11-results.txt
154 lines (138 loc) · 14.6 KB
/
DateTimeRebaseBenchmark-jdk11-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 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 23014 23014 0 4.3 230.1 1.0X
before 1582, noop 13628 13628 0 7.3 136.3 1.7X
after 1582, rebase EXCEPTION 36903 36903 0 2.7 369.0 0.6X
after 1582, rebase LEGACY 37741 37741 0 2.6 377.4 0.6X
after 1582, rebase CORRECTED 37113 37113 0 2.7 371.1 0.6X
before 1582, rebase LEGACY 27944 27944 0 3.6 279.4 0.8X
before 1582, rebase CORRECTED 27541 27541 0 3.6 275.4 0.8X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 15205 16290 1513 6.6 152.0 1.0X
after 1582, vec off, rebase LEGACY 14800 15152 388 6.8 148.0 1.0X
after 1582, vec off, rebase CORRECTED 15592 15745 158 6.4 155.9 1.0X
after 1582, vec on, rebase EXCEPTION 4438 4694 236 22.5 44.4 3.4X
after 1582, vec on, rebase LEGACY 4468 4585 130 22.4 44.7 3.4X
after 1582, vec on, rebase CORRECTED 4353 4513 139 23.0 43.5 3.5X
before 1582, vec off, rebase LEGACY 14607 14904 320 6.8 146.1 1.0X
before 1582, vec off, rebase CORRECTED 14282 14551 269 7.0 142.8 1.1X
before 1582, vec on, rebase LEGACY 5276 5378 97 19.0 52.8 2.9X
before 1582, vec on, rebase CORRECTED 4291 4418 147 23.3 42.9 3.5X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 3873 3873 0 25.8 38.7 1.0X
before 1900, noop 3935 3935 0 25.4 39.3 1.0X
after 1900, rebase EXCEPTION 24036 24036 0 4.2 240.4 0.2X
after 1900, rebase LEGACY 24804 24804 0 4.0 248.0 0.2X
after 1900, rebase CORRECTED 24212 24212 0 4.1 242.1 0.2X
before 1900, rebase LEGACY 28263 28263 0 3.5 282.6 0.1X
before 1900, rebase CORRECTED 24445 24445 0 4.1 244.5 0.2X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 18872 19403 678 5.3 188.7 1.0X
after 1900, vec off, rebase LEGACY 19228 19451 193 5.2 192.3 1.0X
after 1900, vec off, rebase CORRECTED 19047 19327 324 5.3 190.5 1.0X
after 1900, vec on, rebase EXCEPTION 6986 7025 49 14.3 69.9 2.7X
after 1900, vec on, rebase LEGACY 7456 7544 110 13.4 74.6 2.5X
after 1900, vec on, rebase CORRECTED 6892 7100 242 14.5 68.9 2.7X
before 1900, vec off, rebase LEGACY 22398 22756 547 4.5 224.0 0.8X
before 1900, vec off, rebase CORRECTED 19194 19479 248 5.2 191.9 1.0X
before 1900, vec on, rebase LEGACY 10888 11065 234 9.2 108.9 1.7X
before 1900, vec on, rebase CORRECTED 6830 6899 60 14.6 68.3 2.8X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 3729 3729 0 26.8 37.3 1.0X
before 1900, noop 3635 3635 0 27.5 36.4 1.0X
after 1900, rebase EXCEPTION 17891 17891 0 5.6 178.9 0.2X
after 1900, rebase LEGACY 16771 16771 0 6.0 167.7 0.2X
after 1900, rebase CORRECTED 17749 17749 0 5.6 177.5 0.2X
before 1900, rebase LEGACY 21395 21395 0 4.7 213.9 0.2X
before 1900, rebase CORRECTED 17452 17452 0 5.7 174.5 0.2X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 16526 17079 483 6.1 165.3 1.0X
after 1900, vec off, rebase LEGACY 16082 16406 354 6.2 160.8 1.0X
after 1900, vec off, rebase CORRECTED 16236 16439 210 6.2 162.4 1.0X
after 1900, vec on, rebase EXCEPTION 5789 5841 64 17.3 57.9 2.9X
after 1900, vec on, rebase LEGACY 5596 5743 212 17.9 56.0 3.0X
after 1900, vec on, rebase CORRECTED 5754 5843 78 17.4 57.5 2.9X
before 1900, vec off, rebase LEGACY 19298 19630 476 5.2 193.0 0.9X
before 1900, vec off, rebase CORRECTED 16074 16116 43 6.2 160.7 1.0X
before 1900, vec on, rebase LEGACY 8600 8896 394 11.6 86.0 1.9X
before 1900, vec on, rebase CORRECTED 5831 5976 130 17.1 58.3 2.8X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 3877 3877 0 25.8 38.8 1.0X
before 1900, noop 3710 3710 0 27.0 37.1 1.0X
after 1900, rebase EXCEPTION 16141 16141 0 6.2 161.4 0.2X
after 1900, rebase LEGACY 16501 16501 0 6.1 165.0 0.2X
after 1900, rebase CORRECTED 18796 18796 0 5.3 188.0 0.2X
before 1900, rebase LEGACY 22112 22112 0 4.5 221.1 0.2X
before 1900, rebase CORRECTED 20571 20571 0 4.9 205.7 0.2X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 19486 19528 37 5.1 194.9 1.0X
after 1900, vec off, rebase LEGACY 19605 19721 143 5.1 196.0 1.0X
after 1900, vec off, rebase CORRECTED 19485 19703 219 5.1 194.9 1.0X
after 1900, vec on, rebase EXCEPTION 7012 7163 180 14.3 70.1 2.8X
after 1900, vec on, rebase LEGACY 7947 7974 24 12.6 79.5 2.5X
after 1900, vec on, rebase CORRECTED 7052 7119 58 14.2 70.5 2.8X
before 1900, vec off, rebase LEGACY 22448 22791 348 4.5 224.5 0.9X
before 1900, vec off, rebase CORRECTED 18681 19302 544 5.4 186.8 1.0X
before 1900, vec on, rebase LEGACY 10377 10755 502 9.6 103.8 1.9X
before 1900, vec on, rebase CORRECTED 6332 6480 129 15.8 63.3 3.1X
================================================================================================
Rebasing dates/timestamps in ORC datasource
================================================================================================
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 20113 20113 0 5.0 201.1 1.0X
before 1582, noop 12088 12088 0 8.3 120.9 1.7X
after 1582 26142 26142 0 3.8 261.4 0.8X
before 1582 19795 19795 0 5.1 198.0 1.0X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 9686 9870 189 10.3 96.9 1.0X
after 1582, vec on 4529 4596 110 22.1 45.3 2.1X
before 1582, vec off 9802 10135 386 10.2 98.0 1.0X
before 1582, vec on 5099 5251 161 19.6 51.0 1.9X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 3695 3695 0 27.1 36.9 1.0X
before 1900, noop 3756 3756 0 26.6 37.6 1.0X
after 1900 18907 18907 0 5.3 189.1 0.2X
before 1900 22424 22424 0 4.5 224.2 0.2X
OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure
Intel(R) Xeon(R) Platinum 8171M 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 11146 11420 459 9.0 111.5 1.0X
after 1900, vec on 5958 6094 135 16.8 59.6 1.9X
before 1900, vec off 14053 14183 175 7.1 140.5 0.8X
before 1900, vec on 8941 9161 229 11.2 89.4 1.2X