cloud-fan commented on issue #26190: [SPARK-29532][SQL] simplify interval string parsing URL: https://github.com/apache/spark/pull/26190#issuecomment-545010826 The result before this change ``` [info] cast strings to intervals: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative [info] ------------------------------------------------------------------------------------------------------------------------ [info] string w/ interval 386 413 29 2.6 385.7 1.0X [info] string w/o interval 341 361 17 2.9 341.3 1.1X [info] 1 units w/ interval 4884 4912 26 0.2 4883.7 0.1X [info] 1 units w/o interval 4657 4663 8 0.2 4657.4 0.1X [info] 2 units w/ interval 5993 6012 17 0.2 5993.1 0.1X [info] 2 units w/o interval 5762 5788 24 0.2 5762.4 0.1X [info] 3 units w/ interval 6854 6867 15 0.1 6854.4 0.1X [info] 3 units w/o interval 6635 6737 172 0.2 6634.9 0.1X [info] 4 units w/ interval 7817 7834 15 0.1 7816.8 0.0X [info] 4 units w/o interval 7743 8071 295 0.1 7742.8 0.0X [info] 5 units w/ interval 8727 8747 21 0.1 8726.5 0.0X [info] 5 units w/o interval 8560 8587 36 0.1 8559.5 0.0X [info] 6 units w/ interval 9723 9735 18 0.1 9722.8 0.0X [info] 6 units w/o interval 9547 9563 26 0.1 9547.0 0.0X [info] 7 units w/ interval 10822 10831 9 0.1 10821.9 0.0X [info] 7 units w/o interval 10611 10648 63 0.1 10610.6 0.0X [info] 8 units w/ interval 11917 11976 60 0.1 11917.2 0.0X [info] 8 units w/o interval 11706 11721 18 0.1 11706.4 0.0X [info] 9 units w/ interval 13019 13035 14 0.1 13019.3 0.0X [info] 9 units w/o interval 12812 12828 14 0.1 12812.0 0.0X ``` The result after this change: ``` [info] cast strings to intervals: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative [info] ------------------------------------------------------------------------------------------------------------------------ [info] string w/ interval 407 409 3 2.5 407.3 1.0X [info] string w/o interval 346 359 15 2.9 346.1 1.2X [info] 1 units w/ interval 4763 4772 8 0.2 4763.1 0.1X [info] 1 units w/o interval 4540 4545 7 0.2 4540.3 0.1X [info] 2 units w/ interval 5727 5821 120 0.2 5726.9 0.1X [info] 2 units w/o interval 5488 5513 24 0.2 5488.1 0.1X [info] 3 units w/ interval 6615 6622 11 0.2 6615.1 0.1X [info] 3 units w/o interval 6416 6426 14 0.2 6415.7 0.1X [info] 4 units w/ interval 7509 7528 21 0.1 7509.2 0.1X [info] 4 units w/o interval 7315 7364 84 0.1 7315.0 0.1X [info] 5 units w/ interval 8408 8419 10 0.1 8408.4 0.0X [info] 5 units w/o interval 8218 8222 5 0.1 8218.0 0.0X [info] 6 units w/ interval 9304 9320 16 0.1 9303.9 0.0X [info] 6 units w/o interval 9166 9172 6 0.1 9166.4 0.0X [info] 7 units w/ interval 10326 10480 262 0.1 10326.1 0.0X [info] 7 units w/o interval 10130 10139 8 0.1 10130.3 0.0X [info] 8 units w/ interval 11418 11466 43 0.1 11418.4 0.0X [info] 8 units w/o interval 11170 11177 8 0.1 11170.3 0.0X [info] 9 units w/ interval 12533 12578 57 0.1 12533.3 0.0X [info] 9 units w/o interval 12236 12291 60 0.1 12235.7 0.0X ``` Seems no notable difference.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
