| ================================================================================================ |
| datetime +/- interval |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| datetime +/- interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date + interval(m) 976 985 8 10.2 97.6 1.0X |
| date + interval(m, d) 995 1005 10 10.1 99.5 1.0X |
| date + interval(m, d, ms) 3730 3736 8 2.7 373.0 0.3X |
| date - interval(m) 966 970 4 10.4 96.6 1.0X |
| date - interval(m, d) 978 994 26 10.2 97.8 1.0X |
| date - interval(m, d, ms) 3761 3773 17 2.7 376.1 0.3X |
| timestamp + interval(m) 1897 1919 30 5.3 189.7 0.5X |
| timestamp + interval(m, d) 1952 1954 4 5.1 195.2 0.5X |
| timestamp + interval(m, d, ms) 2181 2182 3 4.6 218.1 0.4X |
| timestamp - interval(m) 1946 1946 1 5.1 194.6 0.5X |
| timestamp - interval(m, d) 2018 2022 5 5.0 201.8 0.5X |
| timestamp - interval(m, d, ms) 2181 2185 6 4.6 218.1 0.4X |
| |
| |
| ================================================================================================ |
| Extract components |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| cast to timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| cast to timestamp wholestage off 195 198 4 51.3 19.5 1.0X |
| cast to timestamp wholestage on 208 215 7 48.0 20.8 0.9X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| year of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| year of timestamp wholestage off 775 783 11 12.9 77.5 1.0X |
| year of timestamp wholestage on 775 780 5 12.9 77.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| quarter of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| quarter of timestamp wholestage off 793 794 2 12.6 79.3 1.0X |
| quarter of timestamp wholestage on 803 807 5 12.5 80.3 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| month of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| month of timestamp wholestage off 771 773 3 13.0 77.1 1.0X |
| month of timestamp wholestage on 780 784 3 12.8 78.0 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| weekofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| weekofyear of timestamp wholestage off 1135 1141 8 8.8 113.5 1.0X |
| weekofyear of timestamp wholestage on 1240 1242 1 8.1 124.0 0.9X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| day of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| day of timestamp wholestage off 766 775 13 13.1 76.6 1.0X |
| day of timestamp wholestage on 778 790 16 12.8 77.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| dayofyear of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| dayofyear of timestamp wholestage off 806 807 2 12.4 80.6 1.0X |
| dayofyear of timestamp wholestage on 819 823 6 12.2 81.9 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| dayofmonth of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| dayofmonth of timestamp wholestage off 780 786 8 12.8 78.0 1.0X |
| dayofmonth of timestamp wholestage on 782 787 7 12.8 78.2 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| dayofweek of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| dayofweek of timestamp wholestage off 914 916 2 10.9 91.4 1.0X |
| dayofweek of timestamp wholestage on 924 930 7 10.8 92.4 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| weekday of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| weekday of timestamp wholestage off 877 880 5 11.4 87.7 1.0X |
| weekday of timestamp wholestage on 892 894 3 11.2 89.2 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| hour of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| hour of timestamp wholestage off 605 607 2 16.5 60.5 1.0X |
| hour of timestamp wholestage on 625 627 2 16.0 62.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| minute of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| minute of timestamp wholestage off 604 606 2 16.6 60.4 1.0X |
| minute of timestamp wholestage on 625 631 11 16.0 62.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| second of timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| second of timestamp wholestage off 605 608 4 16.5 60.5 1.0X |
| second of timestamp wholestage on 624 627 3 16.0 62.4 1.0X |
| |
| |
| ================================================================================================ |
| Current date and time |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| current_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| current_date wholestage off 182 183 1 54.8 18.2 1.0X |
| current_date wholestage on 220 228 12 45.5 22.0 0.8X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| current_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| current_timestamp wholestage off 192 195 4 52.0 19.2 1.0X |
| current_timestamp wholestage on 217 249 42 46.1 21.7 0.9X |
| |
| |
| ================================================================================================ |
| Date arithmetic |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| cast to date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| cast to date wholestage off 666 668 2 15.0 66.6 1.0X |
| cast to date wholestage on 678 684 5 14.7 67.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| last_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| last_day wholestage off 782 783 1 12.8 78.2 1.0X |
| last_day wholestage on 787 789 2 12.7 78.7 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| next_day: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| next_day wholestage off 699 700 1 14.3 69.9 1.0X |
| next_day wholestage on 704 708 3 14.2 70.4 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_add: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_add wholestage off 651 651 1 15.4 65.1 1.0X |
| date_add wholestage on 657 669 19 15.2 65.7 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_sub: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_sub wholestage off 650 651 2 15.4 65.0 1.0X |
| date_sub wholestage on 658 663 4 15.2 65.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| add_months: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| add_months wholestage off 923 925 2 10.8 92.3 1.0X |
| add_months wholestage on 934 939 6 10.7 93.4 1.0X |
| |
| |
| ================================================================================================ |
| Formatting dates |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| format date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| format date wholestage off 3458 3482 34 2.9 345.8 1.0X |
| format date wholestage on 3353 3362 10 3.0 335.3 1.0X |
| |
| |
| ================================================================================================ |
| Formatting timestamps |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| from_unixtime: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| from_unixtime wholestage off 3487 3514 38 2.9 348.7 1.0X |
| from_unixtime wholestage on 3425 3441 18 2.9 342.5 1.0X |
| |
| |
| ================================================================================================ |
| Convert timestamps |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| from_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| from_utc_timestamp wholestage off 734 736 3 13.6 73.4 1.0X |
| from_utc_timestamp wholestage on 841 851 14 11.9 84.1 0.9X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| to_utc_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| to_utc_timestamp wholestage off 1115 1115 0 9.0 111.5 1.0X |
| to_utc_timestamp wholestage on 1147 1155 13 8.7 114.7 1.0X |
| |
| |
| ================================================================================================ |
| Intervals |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| cast interval: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| cast interval wholestage off 220 222 2 45.5 22.0 1.0X |
| cast interval wholestage on 219 223 3 45.6 21.9 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| datediff: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| datediff wholestage off 1116 1117 1 9.0 111.6 1.0X |
| datediff wholestage on 1165 1173 7 8.6 116.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| months_between: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| months_between wholestage off 3358 3359 1 3.0 335.8 1.0X |
| months_between wholestage on 3361 3371 18 3.0 336.1 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| window: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| window wholestage off 419 428 13 2.4 419.3 1.0X |
| window wholestage on 643 661 16 1.6 642.7 0.7X |
| |
| |
| ================================================================================================ |
| Truncation |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc YEAR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc YEAR wholestage off 1752 1763 15 5.7 175.2 1.0X |
| date_trunc YEAR wholestage on 1726 1730 4 5.8 172.6 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc YYYY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc YYYY wholestage off 1774 1777 3 5.6 177.4 1.0X |
| date_trunc YYYY wholestage on 1727 1730 3 5.8 172.7 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc YY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc YY wholestage off 1756 1764 12 5.7 175.6 1.0X |
| date_trunc YY wholestage on 1723 1729 4 5.8 172.3 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc MON: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc MON wholestage off 1735 1736 1 5.8 173.5 1.0X |
| date_trunc MON wholestage on 1758 1760 2 5.7 175.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc MONTH: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc MONTH wholestage off 1741 1743 3 5.7 174.1 1.0X |
| date_trunc MONTH wholestage on 1759 1772 21 5.7 175.9 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc MM: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc MM wholestage off 1729 1731 3 5.8 172.9 1.0X |
| date_trunc MM wholestage on 1758 1762 4 5.7 175.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc DAY: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc DAY wholestage off 1348 1348 0 7.4 134.8 1.0X |
| date_trunc DAY wholestage on 1308 1313 5 7.6 130.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc DD: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc DD wholestage off 1348 1351 4 7.4 134.8 1.0X |
| date_trunc DD wholestage on 1307 1308 1 7.7 130.7 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc HOUR: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc HOUR wholestage off 1327 1334 9 7.5 132.7 1.0X |
| date_trunc HOUR wholestage on 1280 1281 2 7.8 128.0 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc MINUTE: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc MINUTE wholestage off 1348 1349 1 7.4 134.8 1.0X |
| date_trunc MINUTE wholestage on 1305 1310 7 7.7 130.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc SECOND: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc SECOND wholestage off 325 326 1 30.7 32.5 1.0X |
| date_trunc SECOND wholestage on 276 278 2 36.2 27.6 1.2X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc WEEK: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc WEEK wholestage off 1616 1632 23 6.2 161.6 1.0X |
| date_trunc WEEK wholestage on 1625 1629 7 6.2 162.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| date_trunc QUARTER: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| date_trunc QUARTER wholestage off 2073 2073 1 4.8 207.3 1.0X |
| date_trunc QUARTER wholestage on 2077 2094 24 4.8 207.7 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| trunc year: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| trunc year wholestage off 933 937 5 10.7 93.3 1.0X |
| trunc year wholestage on 898 903 5 11.1 89.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| trunc yyyy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| trunc yyyy wholestage off 932 934 3 10.7 93.2 1.0X |
| trunc yyyy wholestage on 901 909 10 11.1 90.1 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| trunc yy: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| trunc yy wholestage off 938 942 6 10.7 93.8 1.0X |
| trunc yy wholestage on 897 898 1 11.1 89.7 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| trunc mon: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| trunc mon wholestage off 906 913 9 11.0 90.6 1.0X |
| trunc mon wholestage on 883 893 15 11.3 88.3 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| trunc month: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| trunc month wholestage off 907 907 1 11.0 90.7 1.0X |
| trunc month wholestage on 883 884 1 11.3 88.3 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| trunc mm: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| trunc mm wholestage off 904 908 6 11.1 90.4 1.0X |
| trunc mm wholestage on 881 893 21 11.4 88.1 1.0X |
| |
| |
| ================================================================================================ |
| Parsing |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| to timestamp str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| to timestamp str wholestage off 106 107 2 9.4 106.1 1.0X |
| to timestamp str wholestage on 99 100 1 10.1 98.8 1.1X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| to_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| to_timestamp wholestage off 737 737 0 1.4 736.8 1.0X |
| to_timestamp wholestage on 747 748 1 1.3 746.6 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| to_unix_timestamp: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| to_unix_timestamp wholestage off 750 762 16 1.3 750.3 1.0X |
| to_unix_timestamp wholestage on 758 760 2 1.3 758.0 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| to date str: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| to date str wholestage off 134 136 4 7.5 133.7 1.0X |
| to date str wholestage on 130 131 1 7.7 129.6 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| to_date: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| to_date wholestage off 647 649 2 1.5 647.3 1.0X |
| to_date wholestage on 632 634 1 1.6 632.3 1.0X |
| |
| |
| ================================================================================================ |
| Conversion from/to external types |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| To/from Java's date-time: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| From java.sql.Date 281 283 2 17.8 56.3 1.0X |
| From java.time.LocalDate 242 244 2 20.6 48.5 1.2X |
| Collect java.sql.Date 1221 1342 111 4.1 244.1 0.2X |
| Collect java.time.LocalDate 964 1080 105 5.2 192.9 0.3X |
| From java.sql.Timestamp 227 231 7 22.1 45.3 1.2X |
| From java.time.Instant 183 187 5 27.3 36.6 1.5X |
| Collect longs 891 983 84 5.6 178.3 0.3X |
| Collect java.sql.Timestamp 944 1202 225 5.3 188.8 0.3X |
| Collect java.time.Instant 966 1046 126 5.2 193.2 0.3X |
| java.sql.Date to Hive string 3882 4034 137 1.3 776.3 0.1X |
| java.time.LocalDate to Hive string 3308 3348 67 1.5 661.7 0.1X |
| java.sql.Timestamp to Hive string 6361 6505 149 0.8 1272.2 0.0X |
| java.time.Instant to Hive string 5138 5301 170 1.0 1027.6 0.1X |
| |
| |
