wenxue lin created KYLIN-2952:
---------------------------------

             Summary: dynamic cube build for time(statTime and endTime)
                 Key: KYLIN-2952
                 URL: https://issues.apache.org/jira/browse/KYLIN-2952
             Project: Kylin
          Issue Type: Improvement
          Components: REST Service
    Affects Versions: v1.6.0
         Environment: linux
            Reporter: wenxue lin
            Assignee: Zhong,Jason
            Priority: Minor


ex => curl -X PUT -u "ADMIN:KYLIN" -H 
"Content-Type:application/json;charset=utf-8" -d 
'{"startTime":1508601600000,"endTime":1508688000000,"buildType":"BUILD"}' 
http://host:port/kylin/api/cubes/bi_dispatch_waiting_service_cube/rebuild

desc :
 rest api param is startTime:1508601600000(2017-10-22) and 
endTime:1508688000000(2017-10-23), but the actual time of building the cube is 
1 day ahead of schedule (actually 8 hours ahead of schedule) 
=》【2017-10-21~2017-10-22】,But using kylinUI build without question, the actual 
view kylin source, found that is because the kylin on the server side source 
code for configuration of GMT rather than use the timezone of fixed GMT + 8, 
and front-end UI will according to the configuration of the timezone is 
transformed to the time of the page to add GMT + 8 time, then the back-end to 
GMT + 8 time in into GMT time, so the kylinUI cube build time without error, 
and using restAPI build cube time not making timezone 8 hours is not accurate 
time difference problem。

*for code:*

kylinProperties.js
this.getTimeZone = function () {
    if (!this.timezone) {
      this.timezone = this.getProperty("kylin.rest.timezone").trim();
    }
    return this.timezone;
}


org.apache.kylin.cube.CubeSegment
public static String makeSegmentName(long startDate, long endDate, long 
startOffset, long endOffset) {
    if (startOffset != 0 || endOffset != 0) {
        if (startOffset == 0 && (endOffset == 0 || endOffset == 
Long.MAX_VALUE)) {
            return "FULL_BUILD";
        }

        return startOffset + "_" + endOffset;
    }

    // using time
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
    dateFormat.setTimeZone(TimeZone.getTimeZone("GMT"));
    return dateFormat.format(startDate) + "_" + dateFormat.format(endDate);
}


org.apache.kylin.common.util.DateFormat:
public static FastDateFormat getDateFormat(String datePattern) {
    FastDateFormat r = formatMap.get(datePattern);
    if (r == null) {
        r = FastDateFormat.getInstance(datePattern, 
TimeZone.getTimeZone("GMT")); // NOTE: this must be GMT to calculate epoch date 
correctly
        formatMap.put(datePattern, r);
    }
    return r;
}




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to