0001 ================================================================================================
0002 Pushdown for many distinct value case
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 Select 0 string row (value IS NULL): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 Parquet Vectorized 11943 12023 69 1.3 759.3 1.0X
0010 Parquet Vectorized (Pushdown) 880 934 44 17.9 55.9 13.6X
0011 Native ORC Vectorized 7847 7896 41 2.0 498.9 1.5X
0012 Native ORC Vectorized (Pushdown) 507 525 22 31.0 32.3 23.5X
0013
0014 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0015 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0016 Select 0 string row ('7864320' < value < '7864320'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0017 ------------------------------------------------------------------------------------------------------------------------
0018 Parquet Vectorized 12020 12040 13 1.3 764.2 1.0X
0019 Parquet Vectorized (Pushdown) 819 840 24 19.2 52.0 14.7X
0020 Native ORC Vectorized 8045 8062 14 2.0 511.5 1.5X
0021 Native ORC Vectorized (Pushdown) 498 535 55 31.6 31.7 24.1X
0022
0023 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0024 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0025 Select 1 string row (value = '7864320'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0026 ------------------------------------------------------------------------------------------------------------------------
0027 Parquet Vectorized 12006 12028 21 1.3 763.3 1.0X
0028 Parquet Vectorized (Pushdown) 772 800 25 20.4 49.1 15.6X
0029 Native ORC Vectorized 8074 8091 15 1.9 513.3 1.5X
0030 Native ORC Vectorized (Pushdown) 467 481 10 33.7 29.7 25.7X
0031
0032 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0033 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0034 Select 1 string row (value <=> '7864320'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0035 ------------------------------------------------------------------------------------------------------------------------
0036 Parquet Vectorized 11995 12021 30 1.3 762.6 1.0X
0037 Parquet Vectorized (Pushdown) 780 792 10 20.2 49.6 15.4X
0038 Native ORC Vectorized 8046 8066 12 2.0 511.6 1.5X
0039 Native ORC Vectorized (Pushdown) 476 489 13 33.0 30.3 25.2X
0040
0041 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0042 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0043 Select 1 string row ('7864320' <= value <= '7864320'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0044 ------------------------------------------------------------------------------------------------------------------------
0045 Parquet Vectorized 11967 11989 12 1.3 760.9 1.0X
0046 Parquet Vectorized (Pushdown) 775 788 11 20.3 49.3 15.4X
0047 Native ORC Vectorized 8028 8046 25 2.0 510.4 1.5X
0048 Native ORC Vectorized (Pushdown) 461 493 29 34.1 29.3 26.0X
0049
0050 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0051 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0052 Select all string rows (value IS NOT NULL): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0053 ------------------------------------------------------------------------------------------------------------------------
0054 Parquet Vectorized 21435 21513 46 0.7 1362.8 1.0X
0055 Parquet Vectorized (Pushdown) 21710 21742 33 0.7 1380.3 1.0X
0056 Native ORC Vectorized 19324 19373 35 0.8 1228.6 1.1X
0057 Native ORC Vectorized (Pushdown) 19535 19572 40 0.8 1242.0 1.1X
0058
0059 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0060 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0061 Select 0 int row (value IS NULL): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0062 ------------------------------------------------------------------------------------------------------------------------
0063 Parquet Vectorized 11008 11034 21 1.4 699.9 1.0X
0064 Parquet Vectorized (Pushdown) 762 767 6 20.6 48.4 14.4X
0065 Native ORC Vectorized 7156 7186 58 2.2 454.9 1.5X
0066 Native ORC Vectorized (Pushdown) 436 447 9 36.1 27.7 25.3X
0067
0068 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0069 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0070 Select 0 int row (7864320 < value < 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0071 ------------------------------------------------------------------------------------------------------------------------
0072 Parquet Vectorized 10987 11033 38 1.4 698.5 1.0X
0073 Parquet Vectorized (Pushdown) 766 776 11 20.5 48.7 14.4X
0074 Native ORC Vectorized 7160 7192 35 2.2 455.2 1.5X
0075 Native ORC Vectorized (Pushdown) 440 454 26 35.8 27.9 25.0X
0076
0077 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0078 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0079 Select 1 int row (value = 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0080 ------------------------------------------------------------------------------------------------------------------------
0081 Parquet Vectorized 11066 11082 19 1.4 703.6 1.0X
0082 Parquet Vectorized (Pushdown) 749 770 15 21.0 47.6 14.8X
0083 Native ORC Vectorized 7248 7294 57 2.2 460.8 1.5X
0084 Native ORC Vectorized (Pushdown) 437 450 16 36.0 27.8 25.3X
0085
0086 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0087 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0088 Select 1 int row (value <=> 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0089 ------------------------------------------------------------------------------------------------------------------------
0090 Parquet Vectorized 11066 11091 32 1.4 703.5 1.0X
0091 Parquet Vectorized (Pushdown) 754 776 28 20.9 47.9 14.7X
0092 Native ORC Vectorized 7257 7265 6 2.2 461.4 1.5X
0093 Native ORC Vectorized (Pushdown) 449 457 7 35.0 28.6 24.6X
0094
0095 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0096 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0097 Select 1 int row (7864320 <= value <= 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0098 ------------------------------------------------------------------------------------------------------------------------
0099 Parquet Vectorized 11067 11079 14 1.4 703.6 1.0X
0100 Parquet Vectorized (Pushdown) 753 762 8 20.9 47.9 14.7X
0101 Native ORC Vectorized 7251 7267 22 2.2 461.0 1.5X
0102 Native ORC Vectorized (Pushdown) 427 435 6 36.8 27.2 25.9X
0103
0104 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0105 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0106 Select 1 int row (7864319 < value < 7864321): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0107 ------------------------------------------------------------------------------------------------------------------------
0108 Parquet Vectorized 11055 11086 18 1.4 702.8 1.0X
0109 Parquet Vectorized (Pushdown) 748 753 6 21.0 47.5 14.8X
0110 Native ORC Vectorized 7227 7253 27 2.2 459.5 1.5X
0111 Native ORC Vectorized (Pushdown) 429 435 5 36.7 27.3 25.8X
0112
0113 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0114 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0115 Select 10% int rows (value < 1572864): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0116 ------------------------------------------------------------------------------------------------------------------------
0117 Parquet Vectorized 12060 12091 21 1.3 766.7 1.0X
0118 Parquet Vectorized (Pushdown) 2799 2821 17 5.6 178.0 4.3X
0119 Native ORC Vectorized 8334 8391 55 1.9 529.9 1.4X
0120 Native ORC Vectorized (Pushdown) 2197 2209 12 7.2 139.7 5.5X
0121
0122 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0123 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0124 Select 50% int rows (value < 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0125 ------------------------------------------------------------------------------------------------------------------------
0126 Parquet Vectorized 15593 15619 22 1.0 991.3 1.0X
0127 Parquet Vectorized (Pushdown) 10573 10584 10 1.5 672.2 1.5X
0128 Native ORC Vectorized 12276 12290 16 1.3 780.5 1.3X
0129 Native ORC Vectorized (Pushdown) 8931 8958 31 1.8 567.8 1.7X
0130
0131 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0132 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0133 Select 90% int rows (value < 14155776): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0134 ------------------------------------------------------------------------------------------------------------------------
0135 Parquet Vectorized 19094 19120 23 0.8 1214.0 1.0X
0136 Parquet Vectorized (Pushdown) 18327 18342 14 0.9 1165.2 1.0X
0137 Native ORC Vectorized 15890 15943 44 1.0 1010.2 1.2X
0138 Native ORC Vectorized (Pushdown) 15414 15442 24 1.0 980.0 1.2X
0139
0140 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0141 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0142 Select all int rows (value IS NOT NULL): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0143 ------------------------------------------------------------------------------------------------------------------------
0144 Parquet Vectorized 20010 20037 21 0.8 1272.2 1.0X
0145 Parquet Vectorized (Pushdown) 20297 20318 21 0.8 1290.4 1.0X
0146 Native ORC Vectorized 16994 17029 39 0.9 1080.5 1.2X
0147 Native ORC Vectorized (Pushdown) 17180 17224 53 0.9 1092.3 1.2X
0148
0149 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0150 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0151 Select all int rows (value > -1): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0152 ------------------------------------------------------------------------------------------------------------------------
0153 Parquet Vectorized 19988 20061 96 0.8 1270.8 1.0X
0154 Parquet Vectorized (Pushdown) 20343 20389 42 0.8 1293.4 1.0X
0155 Native ORC Vectorized 16932 16958 22 0.9 1076.5 1.2X
0156 Native ORC Vectorized (Pushdown) 17308 17351 31 0.9 1100.4 1.2X
0157
0158 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0159 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0160 Select all int rows (value != -1): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0161 ------------------------------------------------------------------------------------------------------------------------
0162 Parquet Vectorized 20167 20210 36 0.8 1282.2 1.0X
0163 Parquet Vectorized (Pushdown) 20508 20543 44 0.8 1303.9 1.0X
0164 Native ORC Vectorized 17038 17070 32 0.9 1083.3 1.2X
0165 Native ORC Vectorized (Pushdown) 17250 17663 538 0.9 1096.7 1.2X
0166
0167
0168 ================================================================================================
0169 Pushdown for few distinct value case (use dictionary encoding)
0170 ================================================================================================
0171
0172 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0173 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0174 Select 0 distinct string row (value IS NULL): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0175 ------------------------------------------------------------------------------------------------------------------------
0176 Parquet Vectorized 10641 10674 57 1.5 676.6 1.0X
0177 Parquet Vectorized (Pushdown) 661 665 7 23.8 42.0 16.1X
0178 Native ORC Vectorized 9194 9227 33 1.7 584.5 1.2X
0179 Native ORC Vectorized (Pushdown) 798 808 18 19.7 50.7 13.3X
0180
0181 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0182 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0183 Select 0 distinct string row ('100' < value < '100'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0184 ------------------------------------------------------------------------------------------------------------------------
0185 Parquet Vectorized 10785 10810 20 1.5 685.7 1.0X
0186 Parquet Vectorized (Pushdown) 656 666 10 24.0 41.7 16.5X
0187 Native ORC Vectorized 9435 9457 16 1.7 599.9 1.1X
0188 Native ORC Vectorized (Pushdown) 796 822 34 19.8 50.6 13.6X
0189
0190 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0191 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0192 Select 1 distinct string row (value = '100'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0193 ------------------------------------------------------------------------------------------------------------------------
0194 Parquet Vectorized 10639 10664 26 1.5 676.4 1.0X
0195 Parquet Vectorized (Pushdown) 734 742 5 21.4 46.7 14.5X
0196 Native ORC Vectorized 9346 9362 17 1.7 594.2 1.1X
0197 Native ORC Vectorized (Pushdown) 863 869 5 18.2 54.9 12.3X
0198
0199 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0200 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0201 Select 1 distinct string row (value <=> '100'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0202 ------------------------------------------------------------------------------------------------------------------------
0203 Parquet Vectorized 10617 10672 59 1.5 675.0 1.0X
0204 Parquet Vectorized (Pushdown) 736 747 8 21.4 46.8 14.4X
0205 Native ORC Vectorized 9345 9445 125 1.7 594.1 1.1X
0206 Native ORC Vectorized (Pushdown) 868 877 7 18.1 55.2 12.2X
0207
0208 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0209 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0210 Select 1 distinct string row ('100' <= value <= '100'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0211 ------------------------------------------------------------------------------------------------------------------------
0212 Parquet Vectorized 10750 10790 35 1.5 683.5 1.0X
0213 Parquet Vectorized (Pushdown) 745 748 6 21.1 47.4 14.4X
0214 Native ORC Vectorized 9471 9488 16 1.7 602.1 1.1X
0215 Native ORC Vectorized (Pushdown) 857 866 6 18.3 54.5 12.5X
0216
0217 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0218 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0219 Select all distinct string rows (value IS NOT NULL): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0220 ------------------------------------------------------------------------------------------------------------------------
0221 Parquet Vectorized 21173 21253 91 0.7 1346.1 1.0X
0222 Parquet Vectorized (Pushdown) 21369 21456 75 0.7 1358.6 1.0X
0223 Native ORC Vectorized 20282 20397 83 0.8 1289.5 1.0X
0224 Native ORC Vectorized (Pushdown) 20704 20768 48 0.8 1316.3 1.0X
0225
0226
0227 ================================================================================================
0228 Pushdown benchmark for StringStartsWith
0229 ================================================================================================
0230
0231 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0232 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0233 StringStartsWith filter: (value like '10%'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0234 ------------------------------------------------------------------------------------------------------------------------
0235 Parquet Vectorized 12426 12474 59 1.3 790.0 1.0X
0236 Parquet Vectorized (Pushdown) 1847 1855 8 8.5 117.4 6.7X
0237 Native ORC Vectorized 8336 8391 68 1.9 530.0 1.5X
0238 Native ORC Vectorized (Pushdown) 8514 8536 14 1.8 541.3 1.5X
0239
0240 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0241 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0242 StringStartsWith filter: (value like '1000%'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0243 ------------------------------------------------------------------------------------------------------------------------
0244 Parquet Vectorized 12143 12167 23 1.3 772.1 1.0X
0245 Parquet Vectorized (Pushdown) 751 758 9 21.0 47.7 16.2X
0246 Native ORC Vectorized 8064 8069 8 2.0 512.7 1.5X
0247 Native ORC Vectorized (Pushdown) 8226 8254 35 1.9 523.0 1.5X
0248
0249 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0250 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0251 StringStartsWith filter: (value like '786432%'): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0252 ------------------------------------------------------------------------------------------------------------------------
0253 Parquet Vectorized 12123 12142 13 1.3 770.8 1.0X
0254 Parquet Vectorized (Pushdown) 739 743 4 21.3 47.0 16.4X
0255 Native ORC Vectorized 8038 8052 10 2.0 511.0 1.5X
0256 Native ORC Vectorized (Pushdown) 8211 8227 12 1.9 522.0 1.5X
0257
0258
0259 ================================================================================================
0260 Pushdown benchmark for decimal
0261 ================================================================================================
0262
0263 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0264 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0265 Select 1 decimal(9, 2) row (value = 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0266 ------------------------------------------------------------------------------------------------------------------------
0267 Parquet Vectorized 5889 5912 23 2.7 374.4 1.0X
0268 Parquet Vectorized (Pushdown) 186 193 7 84.6 11.8 31.7X
0269 Native ORC Vectorized 5272 5291 18 3.0 335.2 1.1X
0270 Native ORC Vectorized (Pushdown) 156 183 36 100.9 9.9 37.8X
0271
0272 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0273 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0274 Select 10% decimal(9, 2) rows (value < 1572864): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0275 ------------------------------------------------------------------------------------------------------------------------
0276 Parquet Vectorized 7738 7804 111 2.0 492.0 1.0X
0277 Parquet Vectorized (Pushdown) 3172 3188 27 5.0 201.6 2.4X
0278 Native ORC Vectorized 7522 7528 4 2.1 478.2 1.0X
0279 Native ORC Vectorized (Pushdown) 3390 3433 35 4.6 215.5 2.3X
0280
0281 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0282 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0283 Select 50% decimal(9, 2) rows (value < 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0284 ------------------------------------------------------------------------------------------------------------------------
0285 Parquet Vectorized 13990 14000 9 1.1 889.4 1.0X
0286 Parquet Vectorized (Pushdown) 13251 13266 21 1.2 842.5 1.1X
0287 Native ORC Vectorized 14799 14817 14 1.1 940.9 0.9X
0288 Native ORC Vectorized (Pushdown) 14149 14195 64 1.1 899.6 1.0X
0289
0290 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0291 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0292 Select 90% decimal(9, 2) rows (value < 14155776): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0293 ------------------------------------------------------------------------------------------------------------------------
0294 Parquet Vectorized 15114 15165 44 1.0 960.9 1.0X
0295 Parquet Vectorized (Pushdown) 15182 15222 23 1.0 965.2 1.0X
0296 Native ORC Vectorized 16653 16683 19 0.9 1058.8 0.9X
0297 Native ORC Vectorized (Pushdown) 16730 16743 9 0.9 1063.7 0.9X
0298
0299 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0300 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0301 Select 1 decimal(18, 2) row (value = 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0302 ------------------------------------------------------------------------------------------------------------------------
0303 Parquet Vectorized 6112 6127 17 2.6 388.6 1.0X
0304 Parquet Vectorized (Pushdown) 186 190 3 84.7 11.8 32.9X
0305 Native ORC Vectorized 5292 5359 74 3.0 336.4 1.2X
0306 Native ORC Vectorized (Pushdown) 152 159 14 103.3 9.7 40.1X
0307
0308 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0309 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0310 Select 10% decimal(18, 2) rows (value < 1572864): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0311 ------------------------------------------------------------------------------------------------------------------------
0312 Parquet Vectorized 7119 7158 57 2.2 452.6 1.0X
0313 Parquet Vectorized (Pushdown) 1765 1784 13 8.9 112.2 4.0X
0314 Native ORC Vectorized 6389 6398 11 2.5 406.2 1.1X
0315 Native ORC Vectorized (Pushdown) 1732 1743 13 9.1 110.1 4.1X
0316
0317 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0318 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0319 Select 50% decimal(18, 2) rows (value < 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0320 ------------------------------------------------------------------------------------------------------------------------
0321 Parquet Vectorized 10996 11025 19 1.4 699.1 1.0X
0322 Parquet Vectorized (Pushdown) 8047 8074 16 2.0 511.6 1.4X
0323 Native ORC Vectorized 10620 10642 23 1.5 675.2 1.0X
0324 Native ORC Vectorized (Pushdown) 8086 8102 14 1.9 514.1 1.4X
0325
0326 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0327 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0328 Select 90% decimal(18, 2) rows (value < 14155776): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0329 ------------------------------------------------------------------------------------------------------------------------
0330 Parquet Vectorized 14800 14834 28 1.1 941.0 1.0X
0331 Parquet Vectorized (Pushdown) 14261 14268 7 1.1 906.7 1.0X
0332 Native ORC Vectorized 14832 14880 44 1.1 943.0 1.0X
0333 Native ORC Vectorized (Pushdown) 14402 14428 28 1.1 915.7 1.0X
0334
0335 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0336 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0337 Select 1 decimal(38, 2) row (value = 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0338 ------------------------------------------------------------------------------------------------------------------------
0339 Parquet Vectorized 8132 8178 36 1.9 517.0 1.0X
0340 Parquet Vectorized (Pushdown) 201 209 10 78.3 12.8 40.5X
0341 Native ORC Vectorized 5270 5290 16 3.0 335.0 1.5X
0342 Native ORC Vectorized (Pushdown) 149 153 2 105.2 9.5 54.4X
0343
0344 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0345 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0346 Select 10% decimal(38, 2) rows (value < 1572864): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0347 ------------------------------------------------------------------------------------------------------------------------
0348 Parquet Vectorized 9422 9465 50 1.7 599.1 1.0X
0349 Parquet Vectorized (Pushdown) 2271 2283 13 6.9 144.4 4.1X
0350 Native ORC Vectorized 6651 6662 10 2.4 422.9 1.4X
0351 Native ORC Vectorized (Pushdown) 2002 2016 17 7.9 127.3 4.7X
0352
0353 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0354 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0355 Select 50% decimal(38, 2) rows (value < 7864320): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0356 ------------------------------------------------------------------------------------------------------------------------
0357 Parquet Vectorized 14781 14814 37 1.1 939.7 1.0X
0358 Parquet Vectorized (Pushdown) 10675 10696 24 1.5 678.7 1.4X
0359 Native ORC Vectorized 11887 11983 101 1.3 755.8 1.2X
0360 Native ORC Vectorized (Pushdown) 9383 9396 11 1.7 596.5 1.6X
0361
0362 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0363 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0364 Select 90% decimal(38, 2) rows (value < 14155776): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0365 ------------------------------------------------------------------------------------------------------------------------
0366 Parquet Vectorized 19753 19777 28 0.8 1255.9 1.0X
0367 Parquet Vectorized (Pushdown) 19049 19089 49 0.8 1211.1 1.0X
0368 Native ORC Vectorized 17238 17247 7 0.9 1096.0 1.1X
0369 Native ORC Vectorized (Pushdown) 16780 16804 21 0.9 1066.9 1.2X
0370
0371
0372 ================================================================================================
0373 Pushdown benchmark for InSet -> InFilters
0374 ================================================================================================
0375
0376 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0377 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0378 InSet -> InFilters (values count: 5, distribution: 10): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0379 ------------------------------------------------------------------------------------------------------------------------
0380 Parquet Vectorized 11101 11144 74 1.4 705.8 1.0X
0381 Parquet Vectorized (Pushdown) 773 776 3 20.3 49.1 14.4X
0382 Native ORC Vectorized 6973 7001 28 2.3 443.3 1.6X
0383 Native ORC Vectorized (Pushdown) 445 451 5 35.4 28.3 25.0X
0384
0385 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0386 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0387 InSet -> InFilters (values count: 5, distribution: 50): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0388 ------------------------------------------------------------------------------------------------------------------------
0389 Parquet Vectorized 11098 11111 13 1.4 705.6 1.0X
0390 Parquet Vectorized (Pushdown) 775 778 4 20.3 49.2 14.3X
0391 Native ORC Vectorized 6980 6996 9 2.3 443.8 1.6X
0392 Native ORC Vectorized (Pushdown) 441 448 8 35.7 28.0 25.2X
0393
0394 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0395 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0396 InSet -> InFilters (values count: 5, distribution: 90): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0397 ------------------------------------------------------------------------------------------------------------------------
0398 Parquet Vectorized 11089 11118 26 1.4 705.0 1.0X
0399 Parquet Vectorized (Pushdown) 772 777 3 20.4 49.1 14.4X
0400 Native ORC Vectorized 6973 6985 9 2.3 443.3 1.6X
0401 Native ORC Vectorized (Pushdown) 446 448 3 35.3 28.3 24.9X
0402
0403 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0404 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0405 InSet -> InFilters (values count: 10, distribution: 10): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0406 ------------------------------------------------------------------------------------------------------------------------
0407 Parquet Vectorized 11113 11137 19 1.4 706.5 1.0X
0408 Parquet Vectorized (Pushdown) 802 807 5 19.6 51.0 13.9X
0409 Native ORC Vectorized 7034 7080 63 2.2 447.2 1.6X
0410 Native ORC Vectorized (Pushdown) 461 469 5 34.1 29.3 24.1X
0411
0412 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0413 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0414 InSet -> InFilters (values count: 10, distribution: 50): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0415 ------------------------------------------------------------------------------------------------------------------------
0416 Parquet Vectorized 11122 11134 16 1.4 707.1 1.0X
0417 Parquet Vectorized (Pushdown) 804 817 16 19.6 51.1 13.8X
0418 Native ORC Vectorized 7027 7037 10 2.2 446.8 1.6X
0419 Native ORC Vectorized (Pushdown) 463 470 5 34.0 29.4 24.0X
0420
0421 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0422 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0423 InSet -> InFilters (values count: 10, distribution: 90): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0424 ------------------------------------------------------------------------------------------------------------------------
0425 Parquet Vectorized 11097 11115 13 1.4 705.5 1.0X
0426 Parquet Vectorized (Pushdown) 804 810 6 19.6 51.1 13.8X
0427 Native ORC Vectorized 7010 7022 15 2.2 445.7 1.6X
0428 Native ORC Vectorized (Pushdown) 465 468 4 33.8 29.6 23.9X
0429
0430 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0431 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0432 InSet -> InFilters (values count: 50, distribution: 10): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0433 ------------------------------------------------------------------------------------------------------------------------
0434 Parquet Vectorized 11378 11387 7 1.4 723.4 1.0X
0435 Parquet Vectorized (Pushdown) 11640 11675 37 1.4 740.1 1.0X
0436 Native ORC Vectorized 7266 7284 24 2.2 462.0 1.6X
0437 Native ORC Vectorized (Pushdown) 612 624 12 25.7 38.9 18.6X
0438
0439 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0440 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0441 InSet -> InFilters (values count: 50, distribution: 50): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0442 ------------------------------------------------------------------------------------------------------------------------
0443 Parquet Vectorized 11411 11448 49 1.4 725.5 1.0X
0444 Parquet Vectorized (Pushdown) 11670 11692 20 1.3 741.9 1.0X
0445 Native ORC Vectorized 7284 7292 10 2.2 463.1 1.6X
0446 Native ORC Vectorized (Pushdown) 652 659 8 24.1 41.4 17.5X
0447
0448 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0449 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0450 InSet -> InFilters (values count: 50, distribution: 90): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0451 ------------------------------------------------------------------------------------------------------------------------
0452 Parquet Vectorized 11399 11447 71 1.4 724.7 1.0X
0453 Parquet Vectorized (Pushdown) 11659 11684 15 1.3 741.3 1.0X
0454 Native ORC Vectorized 7290 7301 10 2.2 463.5 1.6X
0455 Native ORC Vectorized (Pushdown) 655 700 77 24.0 41.7 17.4X
0456
0457 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0458 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0459 InSet -> InFilters (values count: 100, distribution: 10): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0460 ------------------------------------------------------------------------------------------------------------------------
0461 Parquet Vectorized 11398 11424 23 1.4 724.7 1.0X
0462 Parquet Vectorized (Pushdown) 11660 11775 100 1.3 741.3 1.0X
0463 Native ORC Vectorized 7292 7312 24 2.2 463.6 1.6X
0464 Native ORC Vectorized (Pushdown) 789 796 5 19.9 50.2 14.4X
0465
0466 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0467 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0468 InSet -> InFilters (values count: 100, distribution: 50): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0469 ------------------------------------------------------------------------------------------------------------------------
0470 Parquet Vectorized 11399 11462 55 1.4 724.7 1.0X
0471 Parquet Vectorized (Pushdown) 11648 11670 24 1.4 740.6 1.0X
0472 Native ORC Vectorized 7254 7265 8 2.2 461.2 1.6X
0473 Native ORC Vectorized (Pushdown) 851 857 5 18.5 54.1 13.4X
0474
0475 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0476 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0477 InSet -> InFilters (values count: 100, distribution: 90): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0478 ------------------------------------------------------------------------------------------------------------------------
0479 Parquet Vectorized 11383 11499 97 1.4 723.7 1.0X
0480 Parquet Vectorized (Pushdown) 11694 11731 22 1.3 743.5 1.0X
0481 Native ORC Vectorized 7244 7272 22 2.2 460.6 1.6X
0482 Native ORC Vectorized (Pushdown) 887 896 12 17.7 56.4 12.8X
0483
0484
0485 ================================================================================================
0486 Pushdown benchmark for tinyint
0487 ================================================================================================
0488
0489 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0490 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0491 Select 1 tinyint row (value = CAST(63 AS tinyint)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0492 ------------------------------------------------------------------------------------------------------------------------
0493 Parquet Vectorized 6301 6337 24 2.5 400.6 1.0X
0494 Parquet Vectorized (Pushdown) 254 260 4 61.9 16.2 24.8X
0495 Native ORC Vectorized 3257 3273 12 4.8 207.1 1.9X
0496 Native ORC Vectorized (Pushdown) 211 217 4 74.4 13.4 29.8X
0497
0498 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0499 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0500 Select 10% tinyint rows (value < CAST(12 AS tinyint)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0501 ------------------------------------------------------------------------------------------------------------------------
0502 Parquet Vectorized 7169 7219 46 2.2 455.8 1.0X
0503 Parquet Vectorized (Pushdown) 1665 1672 12 9.4 105.9 4.3X
0504 Native ORC Vectorized 4199 4208 12 3.7 267.0 1.7X
0505 Native ORC Vectorized (Pushdown) 1376 1394 30 11.4 87.5 5.2X
0506
0507 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0508 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0509 Select 50% tinyint rows (value < CAST(63 AS tinyint)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0510 ------------------------------------------------------------------------------------------------------------------------
0511 Parquet Vectorized 10703 10739 29 1.5 680.5 1.0X
0512 Parquet Vectorized (Pushdown) 7648 7671 20 2.1 486.3 1.4X
0513 Native ORC Vectorized 7815 7836 14 2.0 496.9 1.4X
0514 Native ORC Vectorized (Pushdown) 6289 6295 9 2.5 399.8 1.7X
0515
0516 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0517 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0518 Select 90% tinyint rows (value < CAST(114 AS tinyint)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0519 ------------------------------------------------------------------------------------------------------------------------
0520 Parquet Vectorized 14239 14284 35 1.1 905.3 1.0X
0521 Parquet Vectorized (Pushdown) 13733 13769 28 1.1 873.1 1.0X
0522 Native ORC Vectorized 11432 11481 32 1.4 726.8 1.2X
0523 Native ORC Vectorized (Pushdown) 11241 11254 11 1.4 714.7 1.3X
0524
0525
0526 ================================================================================================
0527 Pushdown benchmark for Timestamp
0528 ================================================================================================
0529
0530 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0531 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0532 Select 1 timestamp stored as INT96 row (value = CAST(7864320 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0533 ------------------------------------------------------------------------------------------------------------------------
0534 Parquet Vectorized 6805 6823 17 2.3 432.7 1.0X
0535 Parquet Vectorized (Pushdown) 6876 6892 11 2.3 437.2 1.0X
0536 Native ORC Vectorized 3186 3208 33 4.9 202.5 2.1X
0537 Native ORC Vectorized (Pushdown) 131 140 9 120.4 8.3 52.1X
0538
0539 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0540 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0541 Select 10% timestamp stored as INT96 rows (value < CAST(1572864 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0542 ------------------------------------------------------------------------------------------------------------------------
0543 Parquet Vectorized 7742 7765 21 2.0 492.2 1.0X
0544 Parquet Vectorized (Pushdown) 7798 7853 70 2.0 495.8 1.0X
0545 Native ORC Vectorized 4128 4138 8 3.8 262.4 1.9X
0546 Native ORC Vectorized (Pushdown) 1392 1402 17 11.3 88.5 5.6X
0547
0548 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0549 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0550 Select 50% timestamp stored as INT96 rows (value < CAST(7864320 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0551 ------------------------------------------------------------------------------------------------------------------------
0552 Parquet Vectorized 11354 11380 33 1.4 721.9 1.0X
0553 Parquet Vectorized (Pushdown) 11408 11449 36 1.4 725.3 1.0X
0554 Native ORC Vectorized 7752 7780 26 2.0 492.8 1.5X
0555 Native ORC Vectorized (Pushdown) 6233 6246 12 2.5 396.3 1.8X
0556
0557 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0558 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0559 Select 90% timestamp stored as INT96 rows (value < CAST(14155776 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0560 ------------------------------------------------------------------------------------------------------------------------
0561 Parquet Vectorized 14944 14997 49 1.1 950.1 1.0X
0562 Parquet Vectorized (Pushdown) 15066 15120 95 1.0 957.9 1.0X
0563 Native ORC Vectorized 11422 11487 45 1.4 726.2 1.3X
0564 Native ORC Vectorized (Pushdown) 11169 11211 30 1.4 710.1 1.3X
0565
0566 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0567 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0568 Select 1 timestamp stored as TIMESTAMP_MICROS row (value = CAST(7864320 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0569 ------------------------------------------------------------------------------------------------------------------------
0570 Parquet Vectorized 6047 6083 28 2.6 384.5 1.0X
0571 Parquet Vectorized (Pushdown) 188 192 3 83.5 12.0 32.1X
0572 Native ORC Vectorized 3169 3180 11 5.0 201.5 1.9X
0573 Native ORC Vectorized (Pushdown) 127 138 15 124.0 8.1 47.7X
0574
0575 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0576 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0577 Select 10% timestamp stored as TIMESTAMP_MICROS rows (value < CAST(1572864 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0578 ------------------------------------------------------------------------------------------------------------------------
0579 Parquet Vectorized 6967 7009 26 2.3 443.0 1.0X
0580 Parquet Vectorized (Pushdown) 1705 1711 7 9.2 108.4 4.1X
0581 Native ORC Vectorized 4092 4115 18 3.8 260.2 1.7X
0582 Native ORC Vectorized (Pushdown) 1389 1394 9 11.3 88.3 5.0X
0583
0584 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0585 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0586 Select 50% timestamp stored as TIMESTAMP_MICROS rows (value < CAST(7864320 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0587 ------------------------------------------------------------------------------------------------------------------------
0588 Parquet Vectorized 10658 10695 23 1.5 677.6 1.0X
0589 Parquet Vectorized (Pushdown) 7760 7792 35 2.0 493.4 1.4X
0590 Native ORC Vectorized 7780 7802 24 2.0 494.6 1.4X
0591 Native ORC Vectorized (Pushdown) 6241 6279 24 2.5 396.8 1.7X
0592
0593 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0594 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0595 Select 90% timestamp stored as TIMESTAMP_MICROS rows (value < CAST(14155776 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0596 ------------------------------------------------------------------------------------------------------------------------
0597 Parquet Vectorized 14209 14253 53 1.1 903.4 1.0X
0598 Parquet Vectorized (Pushdown) 13742 13764 15 1.1 873.7 1.0X
0599 Native ORC Vectorized 11437 11463 18 1.4 727.1 1.2X
0600 Native ORC Vectorized (Pushdown) 11172 11218 43 1.4 710.3 1.3X
0601
0602 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0603 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0604 Select 1 timestamp stored as TIMESTAMP_MILLIS row (value = CAST(7864320 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0605 ------------------------------------------------------------------------------------------------------------------------
0606 Parquet Vectorized 6124 6173 46 2.6 389.4 1.0X
0607 Parquet Vectorized (Pushdown) 187 189 3 84.2 11.9 32.8X
0608 Native ORC Vectorized 3161 3174 13 5.0 200.9 1.9X
0609 Native ORC Vectorized (Pushdown) 129 144 24 122.4 8.2 47.6X
0610
0611 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0612 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0613 Select 10% timestamp stored as TIMESTAMP_MILLIS rows (value < CAST(1572864 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0614 ------------------------------------------------------------------------------------------------------------------------
0615 Parquet Vectorized 7068 7094 23 2.2 449.4 1.0X
0616 Parquet Vectorized (Pushdown) 1724 1740 19 9.1 109.6 4.1X
0617 Native ORC Vectorized 4127 4137 12 3.8 262.4 1.7X
0618 Native ORC Vectorized (Pushdown) 1385 1393 10 11.4 88.1 5.1X
0619
0620 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0621 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0622 Select 50% timestamp stored as TIMESTAMP_MILLIS rows (value < CAST(7864320 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0623 ------------------------------------------------------------------------------------------------------------------------
0624 Parquet Vectorized 10767 10786 21 1.5 684.5 1.0X
0625 Parquet Vectorized (Pushdown) 7805 7820 13 2.0 496.2 1.4X
0626 Native ORC Vectorized 7714 7775 64 2.0 490.4 1.4X
0627 Native ORC Vectorized (Pushdown) 6247 6266 17 2.5 397.2 1.7X
0628
0629 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0630 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0631 Select 90% timestamp stored as TIMESTAMP_MILLIS rows (value < CAST(14155776 AS timestamp)): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0632 ------------------------------------------------------------------------------------------------------------------------
0633 Parquet Vectorized 14337 14392 34 1.1 911.5 1.0X
0634 Parquet Vectorized (Pushdown) 13774 13791 13 1.1 875.7 1.0X
0635 Native ORC Vectorized 11426 11448 16 1.4 726.4 1.3X
0636 Native ORC Vectorized (Pushdown) 11149 11181 27 1.4 708.8 1.3X
0637
0638
0639 ================================================================================================
0640 Pushdown benchmark with many filters
0641 ================================================================================================
0642
0643 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0644 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0645 Select 1 row with 1 filters: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0646 ------------------------------------------------------------------------------------------------------------------------
0647 Parquet Vectorized 509 514 6 0.0 509244147.0 1.0X
0648 Parquet Vectorized (Pushdown) 512 519 6 0.0 511810881.0 1.0X
0649 Native ORC Vectorized 488 495 8 0.0 488404846.0 1.0X
0650 Native ORC Vectorized (Pushdown) 489 500 16 0.0 489064429.0 1.0X
0651
0652 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0653 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0654 Select 1 row with 250 filters: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0655 ------------------------------------------------------------------------------------------------------------------------
0656 Parquet Vectorized 1704 1712 7 0.0 1703741457.0 1.0X
0657 Parquet Vectorized (Pushdown) 1782 1794 7 0.0 1781727704.0 1.0X
0658 Native ORC Vectorized 1668 1674 5 0.0 1668306343.0 1.0X
0659 Native ORC Vectorized (Pushdown) 1670 1679 7 0.0 1669592413.0 1.0X
0660
0661 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0662 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0663 Select 1 row with 500 filters: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0664 ------------------------------------------------------------------------------------------------------------------------
0665 Parquet Vectorized 5011 5044 25 0.0 5011180244.0 1.0X
0666 Parquet Vectorized (Pushdown) 5375 5397 17 0.0 5375351637.0 0.9X
0667 Native ORC Vectorized 4979 4992 12 0.0 4979326800.0 1.0X
0668 Native ORC Vectorized (Pushdown) 4979 5008 26 0.0 4978952429.0 1.0X
0669
0670