[jira] [Commented] (KYLIN-5721) The input parameters of some date functions support string format

["Hongrong Cao (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-5721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17786687#comment-17786687 ] 

Hongrong Cao commented on KYLIN-5721:
-------------------------------------

h2. Dev design


timestampdiff, timestampadd are spark built-in functions implemented in KE, as long as you add implicit conversion, you can automatically convert to string;
By changing the checker of the timestampadd/diff functions in calcite, the requirement of checking the parameters is relaxed to allow date strings to be passed;
MINUTE, SECOND, HOUR, EXTRACT do not support constant queries, so they are not supported for the time being.

> The input parameters of some date functions support string format
> -----------------------------------------------------------------
>
>                 Key: KYLIN-5721
>                 URL: https://issues.apache.org/jira/browse/KYLIN-5721
>             Project: Kylin
>          Issue Type: Improvement
>    Affects Versions: 5.0-beta
>            Reporter: Hongrong Cao
>            Assignee: Hongrong Cao
>            Priority: Critical
>             Fix For: 5.0.0
>
>
> date_trunc
> date_trunc
> minute
> date_trunc
> extract
> These functions hopefully also implement date strings as arguments.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)