0001 ================================================================================================
0002 parsing large select expressions
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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 8 15 8 0.0 8028037.0 1.0X
0010 100 select expressions 15 18 3 0.0 14899892.0 0.5X
0011 2500 select expressions 237 243 8 0.0 237252523.0 0.0X
0012
0013
0014 ================================================================================================
0015 many column field read and write
0016 ================================================================================================
0017
0018 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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) 59 72 8 1.7 591.0 1.0X
0023 1 cols x 100000 rows (exec in-mem) 57 81 15 1.8 566.0 1.0X
0024 1 cols x 100000 rows (read parquet) 61 78 13 1.6 614.8 1.0X
0025 1 cols x 100000 rows (write parquet) 147 158 10 0.7 1468.5 0.4X
0026 100 cols x 1000 rows (read in-mem) 57 62 6 1.8 565.8 1.0X
0027 100 cols x 1000 rows (exec in-mem) 76 83 10 1.3 758.7 0.8X
0028 100 cols x 1000 rows (read parquet) 70 79 10 1.4 700.8 0.8X
0029 100 cols x 1000 rows (write parquet) 150 162 11 0.7 1498.8 0.4X
0030 2500 cols x 40 rows (read in-mem) 413 424 15 0.2 4134.4 0.1X
0031 2500 cols x 40 rows (exec in-mem) 753 772 23 0.1 7528.2 0.1X
0032 2500 cols x 40 rows (read parquet) 304 312 8 0.3 3044.6 0.2X
0033 2500 cols x 40 rows (write parquet) 507 520 11 0.2 5069.3 0.1X
0034
0035
0036 ================================================================================================
0037 wide shallowly nested struct field read and write
0038 ================================================================================================
0039
0040 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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) 54 63 8 1.8 540.7 1.0X
0045 1 wide x 100000 rows (exec in-mem) 67 77 11 1.5 671.8 0.8X
0046 1 wide x 100000 rows (read parquet) 90 97 6 1.1 901.2 0.6X
0047 1 wide x 100000 rows (write parquet) 150 163 11 0.7 1503.9 0.4X
0048 100 wide x 1000 rows (read in-mem) 69 75 8 1.4 689.8 0.8X
0049 100 wide x 1000 rows (exec in-mem) 111 148 96 0.9 1111.5 0.5X
0050 100 wide x 1000 rows (read parquet) 181 241 35 0.6 1808.7 0.3X
0051 100 wide x 1000 rows (write parquet) 164 180 27 0.6 1636.1 0.3X
0052 2500 wide x 40 rows (read in-mem) 78 101 84 1.3 781.0 0.7X
0053 2500 wide x 40 rows (exec in-mem) 943 966 37 0.1 9430.9 0.1X
0054 2500 wide x 40 rows (read parquet) 1385 1453 95 0.1 13853.3 0.0X
0055 2500 wide x 40 rows (write parquet) 175 190 19 0.6 1745.5 0.3X
0056
0057
0058 ================================================================================================
0059 deeply nested struct field read and write
0060 ================================================================================================
0061
0062 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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) 44 49 6 2.3 441.1 1.0X
0067 1 deep x 100000 rows (exec in-mem) 54 59 6 1.9 536.4 0.8X
0068 1 deep x 100000 rows (read parquet) 65 68 6 1.5 646.1 0.7X
0069 1 deep x 100000 rows (write parquet) 141 147 9 0.7 1413.9 0.3X
0070 100 deep x 1000 rows (read in-mem) 459 470 11 0.2 4592.9 0.1X
0071 100 deep x 1000 rows (exec in-mem) 1736 1740 6 0.1 17355.1 0.0X
0072 100 deep x 1000 rows (read parquet) 1638 1643 6 0.1 16382.2 0.0X
0073 100 deep x 1000 rows (write parquet) 555 567 12 0.2 5548.4 0.1X
0074 250 deep x 400 rows (read in-mem) 2556 2556 1 0.0 25558.5 0.0X
0075 250 deep x 400 rows (exec in-mem) 10410 10416 8 0.0 104102.6 0.0X
0076 250 deep x 400 rows (read parquet) 9670 9688 26 0.0 96699.1 0.0X
0077 250 deep x 400 rows (write parquet) 2638 2642 5 0.0 26379.7 0.0X
0078
0079
0080 ================================================================================================
0081 bushy struct field read and write
0082 ================================================================================================
0083
0084 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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) 39 44 6 2.6 388.2 1.0X
0089 1 x 1 deep x 100000 rows (exec in-mem) 48 50 4 2.1 477.4 0.8X
0090 1 x 1 deep x 100000 rows (read parquet) 47 54 9 2.1 466.1 0.8X
0091 1 x 1 deep x 100000 rows (write parquet) 135 141 5 0.7 1350.5 0.3X
0092 128 x 8 deep x 1000 rows (read in-mem) 45 53 9 2.2 445.2 0.9X
0093 128 x 8 deep x 1000 rows (exec in-mem) 155 160 4 0.6 1553.0 0.2X
0094 128 x 8 deep x 1000 rows (read parquet) 173 217 31 0.6 1729.8 0.2X
0095 128 x 8 deep x 1000 rows (write parquet) 139 154 10 0.7 1389.9 0.3X
0096 1024 x 11 deep x 100 rows (read in-mem) 73 77 4 1.4 730.2 0.5X
0097 1024 x 11 deep x 100 rows (exec in-mem) 733 738 8 0.1 7326.1 0.1X
0098 1024 x 11 deep x 100 rows (read parquet) 652 660 8 0.2 6517.6 0.1X
0099 1024 x 11 deep x 100 rows (write parquet) 171 186 20 0.6 1706.4 0.2X
0100
0101
0102 ================================================================================================
0103 wide array field read and write
0104 ================================================================================================
0105
0106 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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) 43 46 4 2.3 429.7 1.0X
0111 1 wide x 100000 rows (exec in-mem) 54 57 4 1.8 542.4 0.8X
0112 1 wide x 100000 rows (read parquet) 82 87 8 1.2 816.6 0.5X
0113 1 wide x 100000 rows (write parquet) 137 159 19 0.7 1374.9 0.3X
0114 100 wide x 1000 rows (read in-mem) 37 39 4 2.7 367.1 1.2X
0115 100 wide x 1000 rows (exec in-mem) 45 50 6 2.2 451.6 1.0X
0116 100 wide x 1000 rows (read parquet) 52 57 5 1.9 520.8 0.8X
0117 100 wide x 1000 rows (write parquet) 125 131 8 0.8 1247.0 0.3X
0118 2500 wide x 40 rows (read in-mem) 35 39 4 2.9 348.8 1.2X
0119 2500 wide x 40 rows (exec in-mem) 46 49 5 2.2 456.0 0.9X
0120 2500 wide x 40 rows (read parquet) 51 55 6 2.0 508.3 0.8X
0121 2500 wide x 40 rows (write parquet) 129 135 6 0.8 1287.3 0.3X
0122
0123
0124 ================================================================================================
0125 wide map field read and write
0126 ================================================================================================
0127
0128 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 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) 39 48 9 2.5 394.2 1.0X
0133 1 wide x 100000 rows (exec in-mem) 51 56 9 1.9 514.4 0.8X
0134 1 wide x 100000 rows (read parquet) 119 124 7 0.8 1195.0 0.3X
0135 1 wide x 100000 rows (write parquet) 130 138 8 0.8 1299.8 0.3X
0136 100 wide x 1000 rows (read in-mem) 31 32 3 3.3 306.5 1.3X
0137 100 wide x 1000 rows (exec in-mem) 40 42 3 2.5 402.7 1.0X
0138 100 wide x 1000 rows (read parquet) 65 70 6 1.5 651.8 0.6X
0139 100 wide x 1000 rows (write parquet) 123 129 6 0.8 1228.5 0.3X
0140 2500 wide x 40 rows (read in-mem) 33 37 6 3.0 330.1 1.2X
0141 2500 wide x 40 rows (exec in-mem) 43 44 3 2.3 426.6 0.9X
0142 2500 wide x 40 rows (read parquet) 66 69 9 1.5 657.8 0.6X
0143 2500 wide x 40 rows (write parquet) 123 127 2 0.8 1234.4 0.3X
0144
0145