yaooqinn commented on issue #26314: [SPARK-29371][SQL] Support interval field values with fractional parts URL: https://github.com/apache/spark/pull/26314#issuecomment-548256563 ## Before ```scala [info] Java HotSpot(TM) 64-Bit Server VM 1.8.0_65-b17 on Mac OS X 10.14.6 [info] Intel(R) Core(TM) i5-5287U CPU @ 2.90GHz [info] cast strings to intervals: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative [info] ------------------------------------------------------------------------------------------------------------------------ [info] prepare string w/ interval 493 566 77 2.0 493.0 1.0X [info] prepare string w/o interval 410 437 32 2.4 410.0 1.2X [info] 1 units w/ interval 5237 5340 122 0.2 5236.6 0.1X [info] 1 units w/o interval 5063 5136 123 0.2 5062.6 0.1X [info] 2 units w/ interval 6964 6993 28 0.1 6964.0 0.1X [info] 2 units w/o interval 6638 6665 38 0.2 6637.6 0.1X [info] 3 units w/ interval 8344 8444 88 0.1 8343.9 0.1X [info] 3 units w/o interval 7877 8034 166 0.1 7876.8 0.1X [info] 4 units w/ interval 9306 9420 100 0.1 9305.7 0.1X [info] 4 units w/o interval 8363 8635 239 0.1 8363.0 0.1X [info] 5 units w/ interval 10037 10340 301 0.1 10036.6 0.0X [info] 5 units w/o interval 10071 10136 107 0.1 10071.5 0.0X [info] 6 units w/ interval 10818 11524 612 0.1 10818.5 0.0X [info] 6 units w/o interval 10726 11289 490 0.1 10725.8 0.0X [info] 7 units w/ interval 11498 11573 104 0.1 11498.1 0.0X [info] 7 units w/o interval 11292 11311 28 0.1 11292.1 0.0X [info] 8 units w/ interval 12792 12928 189 0.1 12792.4 0.0X [info] 8 units w/o interval 12387 12399 12 0.1 12386.6 0.0X [info] 9 units w/ interval 14307 14541 394 0.1 14307.5 0.0X [info] 9 units w/o interval 13986 14015 49 0.1 13985.5 0.0X ``` ## AFTER ```scala [info] Java HotSpot(TM) 64-Bit Server VM 1.8.0_65-b17 on Mac OS X 10.14.6 [info] Intel(R) Core(TM) i5-5287U CPU @ 2.90GHz [info] cast strings to intervals: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative [info] ------------------------------------------------------------------------------------------------------------------------ [info] prepare string w/ interval 643 726 108 1.6 643.0 1.0X [info] prepare string w/o interval 468 501 35 2.1 468.4 1.4X [info] 1 units w/ interval 5045 8939 NaN 0.2 5044.8 0.1X [info] 1 units w/o interval 5591 5819 379 0.2 5590.6 0.1X [info] 2 units w/ interval 6462 6938 765 0.2 6461.9 0.1X [info] 2 units w/o interval 6022 6149 147 0.2 6021.7 0.1X [info] 3 units w/ interval 7223 7319 90 0.1 7223.2 0.1X [info] 3 units w/o interval 6972 7081 152 0.1 6972.3 0.1X [info] 4 units w/ interval 8180 8333 262 0.1 8179.8 0.1X [info] 4 units w/o interval 7817 7877 94 0.1 7817.5 0.1X [info] 5 units w/ interval 9171 9201 29 0.1 9170.6 0.1X [info] 5 units w/o interval 9119 9567 684 0.1 9118.7 0.1X [info] 6 units w/ interval 10255 10538 488 0.1 10255.2 0.1X [info] 6 units w/o interval 10122 10604 543 0.1 10121.9 0.1X [info] 7 units w/ interval 12154 12334 222 0.1 12153.5 0.1X [info] 7 units w/o interval 11352 11359 10 0.1 11352.1 0.1X [info] 8 units w/ interval 12774 12778 6 0.1 12774.2 0.1X [info] 8 units w/o interval 12627 12891 408 0.1 12627.2 0.1X [info] 9 units w/ interval 14087 14209 184 0.1 14087.5 0.0X [info] 9 units w/o interval 13856 14043 310 0.1 13855.9 0.0X ```
---------------------------------------------------------------- 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]
