-
Notifications
You must be signed in to change notification settings - Fork 28k
/
JsonBenchmark-jdk17-results.txt
120 lines (106 loc) · 10.1 KB
/
JsonBenchmark-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
================================================================================================
Benchmark for performance of JSON parsing
================================================================================================
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
JSON schema inferring: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
No encoding 3946 4277 300 1.3 789.3 1.0X
UTF-8 is set 5538 5603 62 0.9 1107.6 0.7X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
count a short column: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
No encoding 2717 2768 69 1.8 543.4 1.0X
UTF-8 is set 4442 4471 40 1.1 888.3 0.6X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
count a wide column: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
No encoding 7313 7399 75 0.1 7313.2 1.0X
UTF-8 is set 6917 6966 52 0.1 6917.5 1.1X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
select wide row: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
No encoding 13896 14153 416 0.0 277929.9 1.0X
UTF-8 is set 14635 14954 398 0.0 292708.5 0.9X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Select a subset of 10 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Select 10 columns 2306 2356 45 0.4 2305.5 1.0X
Select 1 column 2688 2735 44 0.4 2687.6 0.9X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
creation of JSON parser per line: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Short column without encoding 774 800 24 1.3 773.9 1.0X
Short column with UTF-8 1155 1165 15 0.9 1154.6 0.7X
Wide column without encoding 9820 10034 236 0.1 9819.5 0.1X
Wide column with UTF-8 10137 10203 85 0.1 10136.9 0.1X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
JSON functions: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Text read 119 131 11 8.4 119.0 1.0X
from_json 1957 1965 10 0.5 1957.4 0.1X
json_tuple 2304 2336 28 0.4 2304.3 0.1X
get_json_object 2035 2048 12 0.5 2035.1 0.1X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Dataset of json strings: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Text read 520 530 9 9.6 103.9 1.0X
schema inferring 3406 3465 53 1.5 681.2 0.2X
parsing 3336 3368 28 1.5 667.3 0.2X
Preparing data for benchmarking ...
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Json files in the per-line mode: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Text read 1084 1106 20 4.6 216.7 1.0X
Schema inferring 4093 4162 67 1.2 818.6 0.3X
Parsing without charset 3787 3805 27 1.3 757.3 0.3X
Parsing with UTF-8 5531 5556 38 0.9 1106.3 0.2X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Write dates and timestamps: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Create a dataset of timestamps 217 222 4 4.6 216.6 1.0X
to_json(timestamp) 1216 1266 43 0.8 1216.3 0.2X
write timestamps to files 1111 1126 14 0.9 1110.8 0.2X
Create a dataset of dates 226 235 8 4.4 225.8 1.0X
to_json(date) 876 897 18 1.1 875.9 0.2X
write dates to files 777 787 11 1.3 776.9 0.3X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Read dates and timestamps: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
read timestamp text from files 273 275 3 3.7 272.9 1.0X
read timestamps from files 2649 2767 103 0.4 2649.2 0.1X
infer timestamps from files 7304 7361 50 0.1 7303.6 0.0X
read date text from files 261 275 13 3.8 261.1 1.0X
read date from files 960 967 6 1.0 960.4 0.3X
timestamp strings 302 308 7 3.3 302.3 0.9X
parse timestamps from Dataset[String] 3033 3122 83 0.3 3033.2 0.1X
infer timestamps from Dataset[String] 7525 7622 85 0.1 7525.3 0.0X
date strings 437 442 8 2.3 437.2 0.6X
parse dates from Dataset[String] 1375 1400 29 0.7 1375.5 0.2X
from_json(timestamp) 4109 4316 196 0.2 4109.4 0.1X
from_json(date) 2477 2496 17 0.4 2477.1 0.1X
OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz
Filters pushdown: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
w/o filters 21637 21894 231 0.0 216371.1 1.0X
pushdown disabled 20215 20335 104 0.0 202153.1 1.1X
w/ filters 807 850 38 0.1 8070.0 26.8X