[HIVE-22012] Support timestamp type + string type

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: Parser
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 20/Jul/19 03:02
• Updated: 20/Jul/19 03:03

Description

hive> select current_timestamp() + '100 days';
FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments ''100 days'': No matching method for class org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPDTIPlus with (timestamp, string)
hive>

postgres=# explain verbose select now() + '100 days', '100 days' + now();
                                QUERY PLAN
--------------------------------------------------------------------------
 Result  (cost=0.00..0.02 rows=1 width=16)
   Output: (now() + '100 days'::interval), (now() + '100 days'::interval)
(2 rows)

Issue Links

• is related to: HIVE-20385 Date: date + int fails to add days