[jira] [Commented] (KYLIN-1109) Date read issue by JDBC

["Dayue Gao (JIRA)" <ji...@apache.org>]

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

Dayue Gao commented on KYLIN-1109:
----------------------------------

User reported the sample problem today, didn't find the reason so far. Both kylin server and JDBC client process use GMT+8 timezone, web UI shows the correct answer, but JDBC driver returns incorrect one.

You can use the following query to reproduce it on sample cube:

{code:sql}
select part_dt, count(*) cnt from kylin_sales
where part_dt = date '2012-01-21' group by part_dt
{code}

Web UI returns "2012-01-21", but JDBC returns "2012-01-20".

> Date read issue by JDBC
> -----------------------
>
>                 Key: KYLIN-1109
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1109
>             Project: Kylin
>          Issue Type: Bug
>          Components: Driver - JDBC
>    Affects Versions: v1.1, v1.5.1
>         Environment: windows 7/eclipse mars
>            Reporter: IvanPeng
>              Labels: easyfix
>             Fix For: Future
>
>   Original Estimate: 12h
>  Remaining Estimate: 12h
>
> When i get date from kylin by jdbc driver, the date seems return a error date(shift one day)
> For example, 2015-09-26 display by  kylin api , but jdbc return  2015-09-25



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)