0001 ================================================================================================
0002 Rebasing dates/timestamps in Parquet datasource
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0006 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0007 Save DATE to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 after 1582, noop 23567 23567 0 4.2 235.7 1.0X
0010 before 1582, noop 10570 10570 0 9.5 105.7 2.2X
0011 after 1582, rebase off 35335 35335 0 2.8 353.3 0.7X
0012 after 1582, rebase on 35645 35645 0 2.8 356.5 0.7X
0013 before 1582, rebase off 21824 21824 0 4.6 218.2 1.1X
0014 before 1582, rebase on 22532 22532 0 4.4 225.3 1.0X
0015
0016 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0017 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0018 Load DATE from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0019 ------------------------------------------------------------------------------------------------------------------------
0020 after 1582, vec off, rebase off 13194 13266 81 7.6 131.9 1.0X
0021 after 1582, vec off, rebase on 13402 13466 89 7.5 134.0 1.0X
0022 after 1582, vec on, rebase off 3627 3657 29 27.6 36.3 3.6X
0023 after 1582, vec on, rebase on 3818 3839 26 26.2 38.2 3.5X
0024 before 1582, vec off, rebase off 13075 13146 115 7.6 130.7 1.0X
0025 before 1582, vec off, rebase on 13794 13804 13 7.2 137.9 1.0X
0026 before 1582, vec on, rebase off 3655 3675 21 27.4 36.6 3.6X
0027 before 1582, vec on, rebase on 4579 4634 72 21.8 45.8 2.9X
0028
0029 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0030 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0031 Save TIMESTAMP_INT96 to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0032 ------------------------------------------------------------------------------------------------------------------------
0033 after 1900, noop 2671 2671 0 37.4 26.7 1.0X
0034 before 1900, noop 2685 2685 0 37.2 26.8 1.0X
0035 after 1900, rebase off 23899 23899 0 4.2 239.0 0.1X
0036 after 1900, rebase on 24030 24030 0 4.2 240.3 0.1X
0037 before 1900, rebase off 30178 30178 0 3.3 301.8 0.1X
0038 before 1900, rebase on 30127 30127 0 3.3 301.3 0.1X
0039
0040 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0041 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0042 Load TIMESTAMP_INT96 from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0043 ------------------------------------------------------------------------------------------------------------------------
0044 after 1900, vec off, rebase off 16613 16685 75 6.0 166.1 1.0X
0045 after 1900, vec off, rebase on 16487 16541 47 6.1 164.9 1.0X
0046 after 1900, vec on, rebase off 8840 8870 49 11.3 88.4 1.9X
0047 after 1900, vec on, rebase on 8795 8813 20 11.4 87.9 1.9X
0048 before 1900, vec off, rebase off 20400 20441 62 4.9 204.0 0.8X
0049 before 1900, vec off, rebase on 20430 20481 60 4.9 204.3 0.8X
0050 before 1900, vec on, rebase off 12211 12290 73 8.2 122.1 1.4X
0051 before 1900, vec on, rebase on 12231 12321 95 8.2 122.3 1.4X
0052
0053 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0054 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0055 Save TIMESTAMP_MICROS to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0056 ------------------------------------------------------------------------------------------------------------------------
0057 after 1900, noop 2836 2836 0 35.3 28.4 1.0X
0058 before 1900, noop 2812 2812 0 35.6 28.1 1.0X
0059 after 1900, rebase off 15976 15976 0 6.3 159.8 0.2X
0060 after 1900, rebase on 16197 16197 0 6.2 162.0 0.2X
0061 before 1900, rebase off 16140 16140 0 6.2 161.4 0.2X
0062 before 1900, rebase on 20410 20410 0 4.9 204.1 0.1X
0063
0064 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0065 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0066 Load TIMESTAMP_MICROS from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0067 ------------------------------------------------------------------------------------------------------------------------
0068 after 1900, vec off, rebase off 15297 15324 40 6.5 153.0 1.0X
0069 after 1900, vec off, rebase on 15771 15832 59 6.3 157.7 1.0X
0070 after 1900, vec on, rebase off 4922 4949 32 20.3 49.2 3.1X
0071 after 1900, vec on, rebase on 5392 5411 17 18.5 53.9 2.8X
0072 before 1900, vec off, rebase off 15227 15385 141 6.6 152.3 1.0X
0073 before 1900, vec off, rebase on 19611 19658 41 5.1 196.1 0.8X
0074 before 1900, vec on, rebase off 4965 5013 54 20.1 49.6 3.1X
0075 before 1900, vec on, rebase on 9847 9873 43 10.2 98.5 1.6X
0076
0077 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0078 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0079 Save TIMESTAMP_MILLIS to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0080 ------------------------------------------------------------------------------------------------------------------------
0081 after 1900, noop 2818 2818 0 35.5 28.2 1.0X
0082 before 1900, noop 2805 2805 0 35.6 28.1 1.0X
0083 after 1900, rebase off 15182 15182 0 6.6 151.8 0.2X
0084 after 1900, rebase on 15614 15614 0 6.4 156.1 0.2X
0085 before 1900, rebase off 15404 15404 0 6.5 154.0 0.2X
0086 before 1900, rebase on 19747 19747 0 5.1 197.5 0.1X
0087
0088 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0089 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0090 Load TIMESTAMP_MILLIS from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0091 ------------------------------------------------------------------------------------------------------------------------
0092 after 1900, vec off, rebase off 15622 15649 24 6.4 156.2 1.0X
0093 after 1900, vec off, rebase on 15572 15677 119 6.4 155.7 1.0X
0094 after 1900, vec on, rebase off 6345 6358 15 15.8 63.5 2.5X
0095 after 1900, vec on, rebase on 6780 6834 92 14.8 67.8 2.3X
0096 before 1900, vec off, rebase off 15540 15584 38 6.4 155.4 1.0X
0097 before 1900, vec off, rebase on 19590 19653 55 5.1 195.9 0.8X
0098 before 1900, vec on, rebase off 6374 6381 10 15.7 63.7 2.5X
0099 before 1900, vec on, rebase on 10530 10544 25 9.5 105.3 1.5X
0100
0101
0102 ================================================================================================
0103 Rebasing dates/timestamps in ORC datasource
0104 ================================================================================================
0105
0106 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0107 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0108 Save DATE to ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0109 ------------------------------------------------------------------------------------------------------------------------
0110 after 1582, noop 23825 23825 0 4.2 238.2 1.0X
0111 before 1582, noop 10501 10501 0 9.5 105.0 2.3X
0112 after 1582 32134 32134 0 3.1 321.3 0.7X
0113 before 1582 19947 19947 0 5.0 199.5 1.2X
0114
0115 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0116 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0117 Load DATE from ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0118 ------------------------------------------------------------------------------------------------------------------------
0119 after 1582, vec off 10034 10056 22 10.0 100.3 1.0X
0120 after 1582, vec on 3664 3698 30 27.3 36.6 2.7X
0121 before 1582, vec off 10472 10502 30 9.5 104.7 1.0X
0122 before 1582, vec on 4052 4098 42 24.7 40.5 2.5X
0123
0124 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0125 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0126 Save TIMESTAMP to ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0127 ------------------------------------------------------------------------------------------------------------------------
0128 after 1900, noop 2812 2812 0 35.6 28.1 1.0X
0129 before 1900, noop 2801 2801 0 35.7 28.0 1.0X
0130 after 1900 18290 18290 0 5.5 182.9 0.2X
0131 before 1900 22344 22344 0 4.5 223.4 0.1X
0132
0133 OpenJDK 64-Bit Server VM 1.8.0_252-8u252-b09-1~18.04-b09 on Linux 4.15.0-1063-aws
0134 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0135 Load TIMESTAMP from ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0136 ------------------------------------------------------------------------------------------------------------------------
0137 after 1900, vec off 11257 11279 32 8.9 112.6 1.0X
0138 after 1900, vec on 5296 5310 15 18.9 53.0 2.1X
0139 before 1900, vec off 14700 14758 72 6.8 147.0 0.8X
0140 before 1900, vec on 8576 8665 150 11.7 85.8 1.3X
0141
0142