0001 ================================================================================================
0002 parsing large select expressions
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0006 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0007 parsing large select: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 1 select expressions 5 13 8 0.0 5370143.0 1.0X
0010 100 select expressions 12 16 6 0.0 11995425.0 0.4X
0011 2500 select expressions 211 214 4 0.0 210927791.0 0.0X
0012
0013
0014 ================================================================================================
0015 many column field read and write
0016 ================================================================================================
0017
0018 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0019 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0020 many column field r/w: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0021 ------------------------------------------------------------------------------------------------------------------------
0022 1 cols x 100000 rows (read in-mem) 44 53 6 2.3 440.3 1.0X
0023 1 cols x 100000 rows (exec in-mem) 44 54 9 2.3 437.0 1.0X
0024 1 cols x 100000 rows (read parquet) 53 61 10 1.9 532.4 0.8X
0025 1 cols x 100000 rows (write parquet) 129 142 36 0.8 1291.6 0.3X
0026 100 cols x 1000 rows (read in-mem) 49 55 7 2.0 494.9 0.9X
0027 100 cols x 1000 rows (exec in-mem) 69 73 5 1.4 693.2 0.6X
0028 100 cols x 1000 rows (read parquet) 60 67 8 1.7 596.3 0.7X
0029 100 cols x 1000 rows (write parquet) 142 156 31 0.7 1417.8 0.3X
0030 2500 cols x 40 rows (read in-mem) 391 399 13 0.3 3912.6 0.1X
0031 2500 cols x 40 rows (exec in-mem) 743 749 8 0.1 7432.5 0.1X
0032 2500 cols x 40 rows (read parquet) 297 310 10 0.3 2972.8 0.1X
0033 2500 cols x 40 rows (write parquet) 485 492 16 0.2 4848.1 0.1X
0034
0035
0036 ================================================================================================
0037 wide shallowly nested struct field read and write
0038 ================================================================================================
0039
0040 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0041 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0042 wide shallowly nested struct field r/w: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0043 ------------------------------------------------------------------------------------------------------------------------
0044 1 wide x 100000 rows (read in-mem) 43 48 6 2.3 427.0 1.0X
0045 1 wide x 100000 rows (exec in-mem) 56 63 8 1.8 557.8 0.8X
0046 1 wide x 100000 rows (read parquet) 82 88 10 1.2 818.6 0.5X
0047 1 wide x 100000 rows (write parquet) 134 145 21 0.7 1344.6 0.3X
0048 100 wide x 1000 rows (read in-mem) 55 61 16 1.8 553.1 0.8X
0049 100 wide x 1000 rows (exec in-mem) 94 101 17 1.1 941.4 0.5X
0050 100 wide x 1000 rows (read parquet) 151 179 29 0.7 1511.7 0.3X
0051 100 wide x 1000 rows (write parquet) 147 157 9 0.7 1470.0 0.3X
0052 2500 wide x 40 rows (read in-mem) 66 69 9 1.5 658.9 0.6X
0053 2500 wide x 40 rows (exec in-mem) 853 871 30 0.1 8525.7 0.1X
0054 2500 wide x 40 rows (read parquet) 1158 1296 195 0.1 11577.8 0.0X
0055 2500 wide x 40 rows (write parquet) 157 173 23 0.6 1569.6 0.3X
0056
0057
0058 ================================================================================================
0059 deeply nested struct field read and write
0060 ================================================================================================
0061
0062 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0063 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0064 deeply nested struct field r/w: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0065 ------------------------------------------------------------------------------------------------------------------------
0066 1 deep x 100000 rows (read in-mem) 37 41 6 2.7 374.5 1.0X
0067 1 deep x 100000 rows (exec in-mem) 47 50 6 2.1 466.9 0.8X
0068 1 deep x 100000 rows (read parquet) 58 61 7 1.7 577.7 0.6X
0069 1 deep x 100000 rows (write parquet) 128 134 18 0.8 1282.2 0.3X
0070 100 deep x 1000 rows (read in-mem) 345 350 5 0.3 3447.8 0.1X
0071 100 deep x 1000 rows (exec in-mem) 1283 1283 0 0.1 12830.5 0.0X
0072 100 deep x 1000 rows (read parquet) 1201 1205 7 0.1 12005.2 0.0X
0073 100 deep x 1000 rows (write parquet) 436 443 9 0.2 4361.4 0.1X
0074 250 deep x 400 rows (read in-mem) 1882 1883 1 0.1 18819.9 0.0X
0075 250 deep x 400 rows (exec in-mem) 7705 7709 5 0.0 77054.4 0.0X
0076 250 deep x 400 rows (read parquet) 7052 7087 50 0.0 70517.1 0.0X
0077 250 deep x 400 rows (write parquet) 1978 1979 1 0.1 19780.3 0.0X
0078
0079
0080 ================================================================================================
0081 bushy struct field read and write
0082 ================================================================================================
0083
0084 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0085 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0086 bushy struct field r/w: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0087 ------------------------------------------------------------------------------------------------------------------------
0088 1 x 1 deep x 100000 rows (read in-mem) 34 39 7 2.9 341.5 1.0X
0089 1 x 1 deep x 100000 rows (exec in-mem) 42 45 5 2.4 423.4 0.8X
0090 1 x 1 deep x 100000 rows (read parquet) 42 45 6 2.4 423.8 0.8X
0091 1 x 1 deep x 100000 rows (write parquet) 124 132 19 0.8 1240.4 0.3X
0092 128 x 8 deep x 1000 rows (read in-mem) 39 42 6 2.6 387.3 0.9X
0093 128 x 8 deep x 1000 rows (exec in-mem) 134 138 6 0.7 1342.5 0.3X
0094 128 x 8 deep x 1000 rows (read parquet) 147 164 27 0.7 1468.2 0.2X
0095 128 x 8 deep x 1000 rows (write parquet) 130 142 34 0.8 1297.7 0.3X
0096 1024 x 11 deep x 100 rows (read in-mem) 64 68 11 1.6 639.3 0.5X
0097 1024 x 11 deep x 100 rows (exec in-mem) 642 652 14 0.2 6416.9 0.1X
0098 1024 x 11 deep x 100 rows (read parquet) 527 531 5 0.2 5268.1 0.1X
0099 1024 x 11 deep x 100 rows (write parquet) 155 166 28 0.6 1545.0 0.2X
0100
0101
0102 ================================================================================================
0103 wide array field read and write
0104 ================================================================================================
0105
0106 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0107 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0108 wide array field r/w: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0109 ------------------------------------------------------------------------------------------------------------------------
0110 1 wide x 100000 rows (read in-mem) 36 39 5 2.7 364.2 1.0X
0111 1 wide x 100000 rows (exec in-mem) 46 50 7 2.2 460.4 0.8X
0112 1 wide x 100000 rows (read parquet) 75 78 8 1.3 749.8 0.5X
0113 1 wide x 100000 rows (write parquet) 127 133 19 0.8 1266.0 0.3X
0114 100 wide x 1000 rows (read in-mem) 31 33 4 3.2 309.9 1.2X
0115 100 wide x 1000 rows (exec in-mem) 40 42 4 2.5 397.3 0.9X
0116 100 wide x 1000 rows (read parquet) 49 52 7 2.0 488.6 0.7X
0117 100 wide x 1000 rows (write parquet) 122 135 23 0.8 1216.2 0.3X
0118 2500 wide x 40 rows (read in-mem) 31 32 3 3.3 305.7 1.2X
0119 2500 wide x 40 rows (exec in-mem) 39 42 5 2.6 391.9 0.9X
0120 2500 wide x 40 rows (read parquet) 48 51 7 2.1 482.9 0.8X
0121 2500 wide x 40 rows (write parquet) 120 130 22 0.8 1203.6 0.3X
0122
0123
0124 ================================================================================================
0125 wide map field read and write
0126 ================================================================================================
0127
0128 OpenJDK 64-Bit Server VM 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09 on Linux 4.15.0-1044-aws
0129 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0130 wide map field r/w: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0131 ------------------------------------------------------------------------------------------------------------------------
0132 1 wide x 100000 rows (read in-mem) 35 40 8 2.9 348.8 1.0X
0133 1 wide x 100000 rows (exec in-mem) 46 47 2 2.2 461.8 0.8X
0134 1 wide x 100000 rows (read parquet) 124 127 7 0.8 1236.1 0.3X
0135 1 wide x 100000 rows (write parquet) 125 138 26 0.8 1245.4 0.3X
0136 100 wide x 1000 rows (read in-mem) 26 35 8 3.8 263.1 1.3X
0137 100 wide x 1000 rows (exec in-mem) 35 41 10 2.8 351.8 1.0X
0138 100 wide x 1000 rows (read parquet) 59 62 8 1.7 586.7 0.6X
0139 100 wide x 1000 rows (write parquet) 116 125 32 0.9 1158.2 0.3X
0140 2500 wide x 40 rows (read in-mem) 27 30 5 3.7 270.2 1.3X
0141 2500 wide x 40 rows (exec in-mem) 37 38 3 2.7 366.4 1.0X
0142 2500 wide x 40 rows (read parquet) 58 62 8 1.7 584.3 0.6X
0143 2500 wide x 40 rows (write parquet) 118 126 24 0.9 1176.1 0.3X
0144
0145