/
OrcNestedSchemaPruningBenchmark-results.txt
53 lines (45 loc) · 4.42 KB
/
OrcNestedSchemaPruningBenchmark-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
================================================================================================
Nested Schema Pruning Benchmark For ORC v1
================================================================================================
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Selection: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Top-level column 107 131 17 9.4 106.8 1.0X
Nested column 645 672 15 1.6 644.9 0.2X
Nested column in array 1430 1479 41 0.7 1430.1 0.1X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Limiting: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Top-level column 333 386 41 3.0 333.1 1.0X
Nested column 824 862 39 1.2 824.4 0.4X
Nested column in array 1872 1986 59 0.5 1872.4 0.2X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Repartitioning: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Top-level column 303 317 12 3.3 303.1 1.0X
Nested column 803 838 23 1.2 803.1 0.4X
Nested column in array 1879 1969 84 0.5 1879.1 0.2X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Repartitioning by exprs: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Top-level column 325 342 9 3.1 324.9 1.0X
Nested column 873 922 44 1.1 872.9 0.4X
Nested column in array 1896 2018 84 0.5 1896.4 0.2X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Sample: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Top-level column 111 129 17 9.0 111.3 1.0X
Nested column 577 648 59 1.7 576.9 0.2X
Nested column in array 1439 1499 42 0.7 1438.6 0.1X
OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure
Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz
Sorting: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Top-level column 448 517 36 2.2 448.2 1.0X
Nested column 1010 1055 29 1.0 1010.2 0.4X
Nested column in array 2271 2300 22 0.4 2271.2 0.2X