If you think there is something wrong between different versions, new test cases on the timezone issue should be added. Then we could guarantee the regression test. Patch or PR is welcomed.
2018-02-04 21:42 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > Hi Shaofeng, > > Thank you for reply, but a little strange is that when I use in previous > version 2.1.0 and not encounter this problem. > I will check it later. > > Thanks again > > > ________________________________ > 发件人: ShaoFeng Shi <shaofeng...@apache.org> > 发送时间: 2018年2月4日 21:03 > 收件人: dev > 主题: Re: Timezone offset with java.sql.Date with kylin jdbc > > Check whether this can help: > http://apache-kylin.74782.x6.nabble.com/JDBC-query-result-Date-column-get-wrong-value-td5370.html > > 2018-02-04 19:29 GMT+08:00 张 佑铖 <edouard...@hotmail.com>: > >> Hi kylin team, >> >> Single problem, column with type Date values '2018-02-02' in hive. Query >> in kylin sight is okay return value with '2018-02-02'. >> But when I used jdbc it returns '2018-02-01'. >> >> Apparently it is a problem with timezone. >> 1. Check the configuration first >> kylin.web.timezone=GMT+8 >> user.timezone = Asia/Shanghai >> seems no problem >> 2. Check client >> GMT+8 >> I also add code "System.setProperty("user.timezone","GMT +08");" to >> enforce the same timezone with server >> 3. Follow the code >> after request query, I check the content of response, still '2018-02-02' >> after convert resultset, value is still '2018-02-02' >> and finally rs.getDate("") >> >> public Date getDate(Calendar calendar) throws SQLException { >> Date date = (Date)this.getObject(); >> if (date == null) { >> return null; >> } else { >> if (calendar != null) { >> long v = date.getTime(); >> v -= (long)calendar.getTimeZone().getOffset(v); >> date = new Date(v); >> } >> >> return date; >> } >> } >> >> localCalendar of cource with timezone GMT+8, so after the calculation of >> offset '2018-02-02' turn out to be '2018-02-01' >> >> So I am confused, according to the above if I set locale to UTC I will get >> the right value, but it is unreasonable. >> >> Is there any configuration or some params for jdbc url I missed? >> >> One thing should be mentioned, server of kylin was set UTC before, I >> changed locale to Asia/Shanghai and restart kylin, refresh the cube. I >> don't know if that has impact? >> >> >> Thank you >> >> >> >> >> > > > -- > Best regards, > > Shaofeng Shi 史少锋
