[jira] [Commented] (KYLIN-5776) Support parameter type is string for timestampadd

2024-04-09 Thread ASF subversion and git services (Jira) 


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

ASF subversion and git services commented on KYLIN-5776:


Commit 5d781d1917ec261a95971086f8d8540afc8434fb in kylin's branch 
refs/heads/kylin5 from liang.huang
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=5d781d1917 ]

KYLIN-5776 Support parameter type is string for timestampadd function


> Support parameter type is string for timestampadd
> -
>
> Key: KYLIN-5776
> URL: https://issues.apache.org/jira/browse/KYLIN-5776
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0-beta
>
>




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

[jira] [Commented] (KYLIN-5776) Support parameter type is string for timestampadd

2024-04-08 Thread pengfei.zhan (Jira) 


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

pengfei.zhan commented on KYLIN-5776:
-

h1. Design

For the function timestampadd, calcite for kylin will transfer to datetime_plus 
to fold the constant, however, the calculation does not support string.  If the 
first parameter is year/day/month/quarter, the constant folding works but gives 
wrong result. In order to support this, add some functions to support string.

> Support parameter type is string for timestampadd
> -
>
> Key: KYLIN-5776
> URL: https://issues.apache.org/jira/browse/KYLIN-5776
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0-beta
>
>




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

[jira] [Commented] (KYLIN-5776) Support parameter type is string for timestampadd

2024-04-08 Thread pengfei.zhan (Jira) 


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

pengfei.zhan commented on KYLIN-5776:
-

At present, the following sql
{code:sql}
 
select trunc(TIMESTAMPADD(year, -1, date '2023-07-01'), 'MM') from ssb.lineorder
{code}
is supported by Kylin5. However, if the date was expressed with string, it is 
not supported yet.
{code:sql}
select trunc(TIMESTAMPADD(year, -1, '2023-07-01'), 'MM') from ssb.lineorder
{code}
 

> Support parameter type is string for timestampadd
> -
>
> Key: KYLIN-5776
> URL: https://issues.apache.org/jira/browse/KYLIN-5776
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0-beta
>
>




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