Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id B5E7C200BE8 for ; Fri, 9 Dec 2016 07:04:57 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id B479D160B27; Fri, 9 Dec 2016 06:04:57 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 0C6B1160B1F for ; Fri, 9 Dec 2016 07:04:56 +0100 (CET) Received: (qmail 99526 invoked by uid 500); 9 Dec 2016 06:04:56 -0000 Mailing-List: contact dev-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@kylin.apache.org Delivered-To: mailing list dev@kylin.apache.org Received: (qmail 99515 invoked by uid 99); 9 Dec 2016 06:04:56 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Dec 2016 06:04:56 +0000 Received: from mail-oi0-f53.google.com (mail-oi0-f53.google.com [209.85.218.53]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id C10B21A05A7 for ; Fri, 9 Dec 2016 06:04:55 +0000 (UTC) Received: by mail-oi0-f53.google.com with SMTP id v84so9061257oie.3 for ; Thu, 08 Dec 2016 22:04:55 -0800 (PST) X-Gm-Message-State: AKaTC01qjykg6mg3FUShNT/AHl9HzYL8Z4430OF+kAehCyt4jmxgnpGLBBRtoNg81vqsBU3Hrdrc1zBddNfx2g== X-Received: by 10.157.9.72 with SMTP id 66mr29018035otp.109.1481263495221; Thu, 08 Dec 2016 22:04:55 -0800 (PST) MIME-Version: 1.0 Received: by 10.202.212.211 with HTTP; Thu, 8 Dec 2016 22:04:34 -0800 (PST) In-Reply-To: <41563c32.68e7.158e2292435.Coremail.skyyws@163.com> References: <7228ea61.5ba6.158e1426b25.Coremail.skyyws@163.com> <41563c32.68e7.158e2292435.Coremail.skyyws@163.com> From: Billy Liu Date: Fri, 9 Dec 2016 14:04:34 +0800 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Re: Date error when query streaming cube To: dev Content-Type: multipart/alternative; boundary=94eb2c0448f4739cf105433388db archived-at: Fri, 09 Dec 2016 06:04:57 -0000 --94eb2c0448f4739cf105433388db Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable How about your server timezone? Is your server at the right time? Try run 'date' on your server. 2016-12-09 13:58 GMT+08:00 =E6=B1=AA=E8=83=9C : > I only changed "kylin.rest.timezone=3DGMT" to "kylin.rest.timezone=3DGM+8= " in > file "kylin.properties", and I don't know kylin.web.timezone, this > propertiey should be default. > > > > > On 12/9/2016 12:05=EF=BC=8C Billy Liuwrote=EF=BC=9A > > Thanks for the reporting. Could you provide more information? including > Kylin server timezone, kylin.web.timezone. > > 2016-12-09 9:46 GMT+08:00 =E6=B1=AA=E8=83=9C : > > > Sorry for that. I used JDBC and Kylin Web to test the sql query for > > streaming cube, but the records came from JDBC and Kylin Web are > incorrect. > > All of theses records' date are earlier than my PC date(8 hours). > > > > > > I found that records came from Kylin server are incorrected when I did > > query by remote debug. I guess something wrong when Kylin parsed messag= es > > from kafka, maybe the default time parser class didn't took the timezo= ne > > into consideration? I'm not sure. > > > > > > Another probelm is the segments' start/end time displayed on Kylin Web, > > also earlier than my PC date. I checked the cube's json data storaged i= n > > HBase, and I found that these segments' start/end timestamp(transfromed > in > > to date manually) are same with my PC date. If there any probelm when > Kylin > > web tranform the segments' timestamp into date in new streaming cube? > --94eb2c0448f4739cf105433388db--