[SPARK-29540] Thrift in some cases can't parse string to date

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL, Tests
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 22/Oct/19 01:37
• Updated: 01/Dec/19 21:41
• Resolved: 01/Dec/19 21:41

Description

I'm porting tests from PostgreSQL window.sql but anything related to casting a string to datetime seems to fail on Thrift. For instance, the following does not work:

CREATE TABLE empsalary (                                                                                                                
    depname string,                                                                                                                     
    empno integer,                                                                                                                      
    salary int,                                                                                                                         
    enroll_date date                                                                                                                    
) USING parquet;  
INSERT INTO empsalary VALUES ('develop', 10, 5200, '2007-08-01');

Issue Links

• links to: GitHub Pull Request #26208