[KYLIN-4199] User Defined Function can't return type Date

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v2.6.3
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: hailin.huang
• Created: 18/Oct/19 10:47
• Updated: 18/Oct/19 10:52

Description

In my scene, I implement user defined fuction str_to_date to support client user use mysql dilect to query.
However when I execute query like this:

select str_to_date(dt) as dt,sum(pv) as pv from access_log group by str_to_date(dt);

Kylin throw execution Long can't covert Date.