Hi Jun, 1.6 is quite an old version. I did a quick test in Apache Kylin 2.3.1 and the issue is no longer there.
[cid:2a57adc5-118c-42e7-8cf1-c58133ad32f8] Thanks, Silas ________________________________ 发件人: jun <[email protected]> 发送时间: 2018年5月15日 15:56 收件人: [email protected] 主题: timestampadd has some error kylin-1.6.0 version 1. SQL: select part_dt, timestampadd(MONTH, 1, PART_DT) from KYLIN_SALES result: 2012-01-01, 2012-01-01 MONTH result not correct; 2. SQL: select part_dt, timestampadd(DAY, 1, PART_DT) from KYLIN_SALES result: 2012-01-01, 2012-01-02 DAY result corrcet I found that DAY, HOUR, MINUTE correct, but MONTH and YEAR not work. -- Sent from: http://apache-kylin.74782.x6.nabble.com/
