MaxGekk opened a new pull request #28091: [WIP][SQL] Optimize fromJavaDate() 
and toJavaDate()
URL: https://github.com/apache/spark/pull/28091
 
 
   ### What changes were proposed in this pull request?
   
   
   ### Why are the changes needed?
   Before:
   ```
   Save dates to ORC:                        Best Time(ms)   Avg Time(ms)   
Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
   
------------------------------------------------------------------------------------------------------------------------
   after 1582, noop                                   8410           8410       
    0         11.9          84.1       1.0X
   before 1582, noop                                  8408           8408       
    0         11.9          84.1       1.0X
   after 1582                                        15507          15507       
    0          6.4         155.1       0.5X
   before 1582                                       15099          15099       
    0          6.6         151.0       0.6X
   
   Load dates from ORC:                      Best Time(ms)   Avg Time(ms)   
Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
   
------------------------------------------------------------------------------------------------------------------------
   after 1582, vec off                               26858          27479       
  727          3.7         268.6       1.0X
   ```
   
   After:
   ```
   Save dates to ORC:                        Best Time(ms)   Avg Time(ms)   
Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
   
------------------------------------------------------------------------------------------------------------------------
   after 1582, noop                                   7518           7518       
    0         13.3          75.2       1.0X
   before 1582, noop                                  7292           7292       
    0         13.7          72.9       1.0X
   after 1582                                        13286          13286       
    0          7.5         132.9       0.6X
   before 1582                                       16213          16213       
    0          6.2         162.1       0.5X
   
   Java HotSpot(TM) 64-Bit Server VM 1.8.0_231-b11 on Mac OS X 10.15.3
   Intel(R) Core(TM) i7-4850HQ CPU @ 2.30GHz
   Load dates from ORC:                      Best Time(ms)   Avg Time(ms)   
Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
   
------------------------------------------------------------------------------------------------------------------------
   after 1582, vec off                               17867          17918       
   65          5.6         178.7       1.0X
   ```
   
   ### Does this PR introduce any user-facing change?
   <!--
   If yes, please clarify the previous behavior and the change this PR proposes 
- provide the console output, description and/or an example to show the 
behavior difference if possible.
   If no, write 'No'.
   -->
   
   
   ### How was this patch tested?
   <!--
   If tests were added, say they were added here. Please make sure to add some 
test cases that check the changes thoroughly including negative and positive 
cases if possible.
   If it was tested in a way different from regular unit tests, please clarify 
how you tested step by step, ideally copy and paste-able, so that other 
reviewers can test and check, and descendants can verify in the future.
   If tests were not added, please describe why they were not added and/or why 
it was difficult to add.
   -->
   

----------------------------------------------------------------
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]

Reply via email to