| ================================================================================================ |
| Rebasing dates/timestamps in Parquet datasource |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Save DATE to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1582, noop 23014 23014 0 4.3 230.1 1.0X |
| before 1582, noop 13628 13628 0 7.3 136.3 1.7X |
| after 1582, rebase EXCEPTION 36903 36903 0 2.7 369.0 0.6X |
| after 1582, rebase LEGACY 37741 37741 0 2.6 377.4 0.6X |
| after 1582, rebase CORRECTED 37113 37113 0 2.7 371.1 0.6X |
| before 1582, rebase LEGACY 27944 27944 0 3.6 279.4 0.8X |
| before 1582, rebase CORRECTED 27541 27541 0 3.6 275.4 0.8X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Load DATE from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1582, vec off, rebase EXCEPTION 15205 16290 1513 6.6 152.0 1.0X |
| after 1582, vec off, rebase LEGACY 14800 15152 388 6.8 148.0 1.0X |
| after 1582, vec off, rebase CORRECTED 15592 15745 158 6.4 155.9 1.0X |
| after 1582, vec on, rebase EXCEPTION 4438 4694 236 22.5 44.4 3.4X |
| after 1582, vec on, rebase LEGACY 4468 4585 130 22.4 44.7 3.4X |
| after 1582, vec on, rebase CORRECTED 4353 4513 139 23.0 43.5 3.5X |
| before 1582, vec off, rebase LEGACY 14607 14904 320 6.8 146.1 1.0X |
| before 1582, vec off, rebase CORRECTED 14282 14551 269 7.0 142.8 1.1X |
| before 1582, vec on, rebase LEGACY 5276 5378 97 19.0 52.8 2.9X |
| before 1582, vec on, rebase CORRECTED 4291 4418 147 23.3 42.9 3.5X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Save TIMESTAMP_INT96 to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, noop 3873 3873 0 25.8 38.7 1.0X |
| before 1900, noop 3935 3935 0 25.4 39.3 1.0X |
| after 1900, rebase EXCEPTION 24036 24036 0 4.2 240.4 0.2X |
| after 1900, rebase LEGACY 24804 24804 0 4.0 248.0 0.2X |
| after 1900, rebase CORRECTED 24212 24212 0 4.1 242.1 0.2X |
| before 1900, rebase LEGACY 28263 28263 0 3.5 282.6 0.1X |
| before 1900, rebase CORRECTED 24445 24445 0 4.1 244.5 0.2X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Load TIMESTAMP_INT96 from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, vec off, rebase EXCEPTION 18872 19403 678 5.3 188.7 1.0X |
| after 1900, vec off, rebase LEGACY 19228 19451 193 5.2 192.3 1.0X |
| after 1900, vec off, rebase CORRECTED 19047 19327 324 5.3 190.5 1.0X |
| after 1900, vec on, rebase EXCEPTION 6986 7025 49 14.3 69.9 2.7X |
| after 1900, vec on, rebase LEGACY 7456 7544 110 13.4 74.6 2.5X |
| after 1900, vec on, rebase CORRECTED 6892 7100 242 14.5 68.9 2.7X |
| before 1900, vec off, rebase LEGACY 22398 22756 547 4.5 224.0 0.8X |
| before 1900, vec off, rebase CORRECTED 19194 19479 248 5.2 191.9 1.0X |
| before 1900, vec on, rebase LEGACY 10888 11065 234 9.2 108.9 1.7X |
| before 1900, vec on, rebase CORRECTED 6830 6899 60 14.6 68.3 2.8X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Save TIMESTAMP_MICROS to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, noop 3729 3729 0 26.8 37.3 1.0X |
| before 1900, noop 3635 3635 0 27.5 36.4 1.0X |
| after 1900, rebase EXCEPTION 17891 17891 0 5.6 178.9 0.2X |
| after 1900, rebase LEGACY 16771 16771 0 6.0 167.7 0.2X |
| after 1900, rebase CORRECTED 17749 17749 0 5.6 177.5 0.2X |
| before 1900, rebase LEGACY 21395 21395 0 4.7 213.9 0.2X |
| before 1900, rebase CORRECTED 17452 17452 0 5.7 174.5 0.2X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Load TIMESTAMP_MICROS from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, vec off, rebase EXCEPTION 16526 17079 483 6.1 165.3 1.0X |
| after 1900, vec off, rebase LEGACY 16082 16406 354 6.2 160.8 1.0X |
| after 1900, vec off, rebase CORRECTED 16236 16439 210 6.2 162.4 1.0X |
| after 1900, vec on, rebase EXCEPTION 5789 5841 64 17.3 57.9 2.9X |
| after 1900, vec on, rebase LEGACY 5596 5743 212 17.9 56.0 3.0X |
| after 1900, vec on, rebase CORRECTED 5754 5843 78 17.4 57.5 2.9X |
| before 1900, vec off, rebase LEGACY 19298 19630 476 5.2 193.0 0.9X |
| before 1900, vec off, rebase CORRECTED 16074 16116 43 6.2 160.7 1.0X |
| before 1900, vec on, rebase LEGACY 8600 8896 394 11.6 86.0 1.9X |
| before 1900, vec on, rebase CORRECTED 5831 5976 130 17.1 58.3 2.8X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Save TIMESTAMP_MILLIS to parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, noop 3877 3877 0 25.8 38.8 1.0X |
| before 1900, noop 3710 3710 0 27.0 37.1 1.0X |
| after 1900, rebase EXCEPTION 16141 16141 0 6.2 161.4 0.2X |
| after 1900, rebase LEGACY 16501 16501 0 6.1 165.0 0.2X |
| after 1900, rebase CORRECTED 18796 18796 0 5.3 188.0 0.2X |
| before 1900, rebase LEGACY 22112 22112 0 4.5 221.1 0.2X |
| before 1900, rebase CORRECTED 20571 20571 0 4.9 205.7 0.2X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Load TIMESTAMP_MILLIS from parquet: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, vec off, rebase EXCEPTION 19486 19528 37 5.1 194.9 1.0X |
| after 1900, vec off, rebase LEGACY 19605 19721 143 5.1 196.0 1.0X |
| after 1900, vec off, rebase CORRECTED 19485 19703 219 5.1 194.9 1.0X |
| after 1900, vec on, rebase EXCEPTION 7012 7163 180 14.3 70.1 2.8X |
| after 1900, vec on, rebase LEGACY 7947 7974 24 12.6 79.5 2.5X |
| after 1900, vec on, rebase CORRECTED 7052 7119 58 14.2 70.5 2.8X |
| before 1900, vec off, rebase LEGACY 22448 22791 348 4.5 224.5 0.9X |
| before 1900, vec off, rebase CORRECTED 18681 19302 544 5.4 186.8 1.0X |
| before 1900, vec on, rebase LEGACY 10377 10755 502 9.6 103.8 1.9X |
| before 1900, vec on, rebase CORRECTED 6332 6480 129 15.8 63.3 3.1X |
| |
| |
| ================================================================================================ |
| Rebasing dates/timestamps in ORC datasource |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Save DATE to ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1582, noop 20113 20113 0 5.0 201.1 1.0X |
| before 1582, noop 12088 12088 0 8.3 120.9 1.7X |
| after 1582 26142 26142 0 3.8 261.4 0.8X |
| before 1582 19795 19795 0 5.1 198.0 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Load DATE from ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1582, vec off 9686 9870 189 10.3 96.9 1.0X |
| after 1582, vec on 4529 4596 110 22.1 45.3 2.1X |
| before 1582, vec off 9802 10135 386 10.2 98.0 1.0X |
| before 1582, vec on 5099 5251 161 19.6 51.0 1.9X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Save TIMESTAMP to ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, noop 3695 3695 0 27.1 36.9 1.0X |
| before 1900, noop 3756 3756 0 26.6 37.6 1.0X |
| after 1900 18907 18907 0 5.3 189.1 0.2X |
| before 1900 22424 22424 0 4.5 224.2 0.2X |
| |
| OpenJDK 64-Bit Server VM 11.0.13+8-LTS on Linux 5.11.0-1022-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Load TIMESTAMP from ORC: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| after 1900, vec off 11146 11420 459 9.0 111.5 1.0X |
| after 1900, vec on 5958 6094 135 16.8 59.6 1.9X |
| before 1900, vec off 14053 14183 175 7.1 140.5 0.8X |
| before 1900, vec on 8941 9161 229 11.2 89.4 1.2X |
| |
| |
