Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[VL] Result mimatch when to_timestamp with fraction of seconds #8858

Open
NEUpanning opened this issue Feb 28, 2025 · 0 comments · May be fixed by facebookincubator/velox#12491
Open

[VL] Result mimatch when to_timestamp with fraction of seconds #8858

NEUpanning opened this issue Feb 28, 2025 · 0 comments · May be fixed by facebookincubator/velox#12491
Labels
bug Something isn't working triage

Comments

@NEUpanning
Copy link
Contributor

Backend

VL (Velox)

Bug description

spark result:

spark-sql (default)> set spark.sql.legacy.timeParserPolicy=legacy;
spark.sql.legacy.timeParserPolicy	legacy
spark-sql (default)> select to_timestamp('2025-02-25T03:07:22.2', "yyyy-MM-dd'T'HH:mm:ss.SSS");
2025-02-25 03:07:22.002

gluten result:

spark-sql (default)> set spark.sql.legacy.timeParserPolicy=legacy;
spark.sql.legacy.timeParserPolicy	legacy
spark-sql (default)> select to_timestamp('2025-02-25T03:07:22.2', "yyyy-MM-dd'T'HH:mm:ss.SSS");
2025-02-25 03:07:22.2

Spark version

None

Spark configurations

No response

System information

No response

Relevant logs


      		
    

      
  





        



            

              
            

        

      


      
    








      


  




  
  

              

  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment


  



  






  
                  




    

  


      
  

    Assignees
  



        

    No one assigned







      


  


  

    Labels
  



    

      

    bug

  Something isn't working
  

    triage









      

  

    

        

    Projects
  


        




    None yet




  



      


  

    
  

    Milestone
  


      No milestone





    
      
          
  

    

      

        
          

            
    

    Development
  




              
  
Successfully merging a pull request may close this issue.





    


  
          
      fix(function): Fix getTimestamp to parse fractional seconds correctly for Spark

    
      NEUpanning/velox
    





        
      

    

  


      

    

  
      

  

    

      1 participant
    

    

        
          @NEUpanning