[KYLIN-1987] kylin can't support date/time functions like TIMESTAMPADD、TIMESTAMPDIFF

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v1.5.3
• Component/s: Query Engine
• Labels: newbie
• Environment: kylin-1.5.3-cdh5.7
• Assignee: Unassigned
• Reporter: SF Wang
• Created: 31/Aug/16 07:34
• Updated: 27/May/20 13:55

Description

kylin can't support date/time functions like TIMESTAMPADD、TIMESTAMPDIFF

when I execute sql on sample table kylin_sales in kylin web cli, It reports error.
My sql :
select timestampadd(DAY, 1, cast(part_dt as timestamp)) from kylin_sales

Error message:
Encountered "(DAY" at line 1, column 20. Was expecting one of :"."... "("... ...