[SPARK-29684] Support divide/multiply for interval types

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Kent Yao 2
• Created: 31/Oct/19 10:13
• Updated: 01/Dec/19 22:29
• Resolved: 01/Dec/19 22:29

Description

postgres=# select interval '1 year 2 month' / 2.123456789111;
           ?column?
------------------------------
 6 mons 17 days 18:58:36.3072
(1 row)postgres=# select interval '1 year 2 month' * 2.123456789;
               ?column?
--------------------------------------
 2 years 5 mons 21 days 20:26:39.9264
(1 row)

Issue Links

• duplicates: SPARK-29387 Support `*` and `/` operators for intervals
• links to: GitHub Pull Request #26345