[KYLIN-2264] Date error when use new streaming cube in Kylin1.6.0

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: v1.6.0
• Component/s: NRT Streaming, Web
• Environment: Debian 3.2.54-2 x86_64 GNU/Linux
• Assignee: Shao Feng Shi
• Reporter: Sheng Wang
• Created: 09/Dec/16 07:16
• Updated: 20/Aug/17 09:47
• Resolved: 20/Aug/17 09:47

Description

I installed Kylin1.6.0 and built streaming cube successgfully.But I found two problems which I didn't met in Kylin1.5.*.

First, segments' start/end time displayed on Kylin Web are earlier 8 hours than my PC date, but streaming cube's Last Build Time and Create Time
displayed on Kylin Web are same with my PC date. Maybe something wrong when Kylin Web transform the segments' start/end timestamp into date, but I'm not sure.

Second, I did sql query from streaming cube, but the records' time related columns like "HOUR_START" and "MINUTE_START" are all earlier 8 hours than my PC time. I found that these time related columns' timestamp from HBase are correct by remote debug, so I guess something wrong when Kylin server transform these timestamp into date.

By the way, I only changed the "kylin.rest.timezone=GM+8" in file "kylin.properties", and my PC date is same with my server date.