[SPARK-28429] SQL Datetime util function being casted to double instead of timestamp

• Type: Sub-task
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 17/Jul/19 18:15
• Updated: 12/Dec/22 18:10

Description

In the code below, 'now()+'100 days' are casted to double and then an error is thrown:

CREATE TEMP VIEW v_window AS
SELECT i, min(i) over (order by i range between '1 day' preceding and '10 days' following) as min_i
FROM range(now(), now()+'100 days', '1 hour') i;

Error:

cannot resolve '(current_timestamp() + CAST('100 days' AS DOUBLE))' due to data type mismatch: differing      types in '(current_timestamp() + CAST('100 days' AS DOUBLE))' (timestamp and double).;

Issue Links

• links to: GitHub Pull Request #25190