[SPARK-29663] Support sum with interval type values

• Type: Sub-task
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Kent Yao 2
• Created: 30/Oct/19 16:19
• Updated: 21/Apr/20 00:25

Description

postgres=# SELECT i, Sum(cast(v as interval)) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) FROM (VALUES(1,'1 sec'),(2,'2 sec'),(3,NULL),(4,NULL)) t(i,v); 
i | sum ---+---------- 
1 | 00:00:03 
2 | 00:00:02
3 | 
4 | 
(4 rows)

Issue Links

• links to: GitHub Pull Request #26325
• links to: GitHub Pull Request #27619