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 D1ABF200B8D for ; Fri, 9 Sep 2016 07:48:16 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id D0078160AD0; Fri, 9 Sep 2016 05:48:16 +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 A216E160AAD for ; Fri, 9 Sep 2016 07:48:15 +0200 (CEST) Received: (qmail 4510 invoked by uid 500); 9 Sep 2016 05:48:14 -0000 Mailing-List: contact user-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@kylin.apache.org Delivered-To: mailing list user@kylin.apache.org Received: (qmail 4499 invoked by uid 99); 9 Sep 2016 05:48:14 -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 Sep 2016 05:48:14 +0000 Received: from mail-yw0-f178.google.com (mail-yw0-f178.google.com [209.85.161.178]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 0CE671A00D6 for ; Fri, 9 Sep 2016 05:48:14 +0000 (UTC) Received: by mail-yw0-f178.google.com with SMTP id g192so42208928ywh.1 for ; Thu, 08 Sep 2016 22:48:13 -0700 (PDT) X-Gm-Message-State: AE9vXwPLLMpM4NRUMm+zNNOs3CFK+BcVhNlxwnXIzcUr3TZmunZ1bQZr0xZMENyUVn/Rto9/hALhefr5JknBCA== X-Received: by 10.13.214.199 with SMTP id y190mr1507846ywd.0.1473400093215; Thu, 08 Sep 2016 22:48:13 -0700 (PDT) MIME-Version: 1.0 Received: by 10.13.219.145 with HTTP; Thu, 8 Sep 2016 22:47:32 -0700 (PDT) In-Reply-To: References: From: ShaoFeng Shi Date: Fri, 9 Sep 2016 13:47:32 +0800 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Empty Cube To: user Content-Type: multipart/alternative; boundary=94eb2c0766c62b127a053c0cb1e8 archived-at: Fri, 09 Sep 2016 05:48:17 -0000 --94eb2c0766c62b127a053c0cb1e8 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Niasari, During the query time, Kylin will not touch Hive, all queries will go to HBase, so you still get results on kylin_cal_dt; If you also want to remove that also in Kylin, please disable and then drop the cube. For the empty cube, it is possible and allowed in Kylin; Thinking that an user uses incremental build, and for a time period there is no source data, so empty cube is expected. Of course you can configure Kylin to let it report error when there is no source record, see: https://issues.apache.org/jira/browse/KYLIN-1752 For the empty cube issue, I guess there is some thing wrong, making no data be built into cube. If you want to get remote debug or support, please contact me offline. 2016-09-07 5:17 GMT+08:00 Niasari, Mehrdad : > The range is up to 2015 and that=E2=80=99s not the problem. > > > > The only query that doesn=E2=80=99t return zero/empty result is from tabl= e > kylin_cal_dt. When I delete this table from hive, still the result is not > empty and Kylin doesn=E2=80=99t complain! Where does Kylin bring the data= of this > table even when it=E2=80=99s not on hive? > > Also I checked the cube itself on Hbase and it=E2=80=99s empty. Any other > suggestion? Can it be because of some wrong configuration in connecting > Kylin to Hive/Hbase? If that=E2=80=99s the case why it can create the cub= e > successfully? > > > > Also I have a question regarding uuid. What is this for? > > I=E2=80=99m asking this cause I cannot fully understand that why you have= used a > fixed value in sample cube json files (for example for kylin_sales_cube > uuid is: =E2=80=9C2fbca32a-a33e-4b69-83dd-0bb8b1f8c53b=E2=80=9D). How com= e it doesn=E2=80=99t > conflict if you run the sample cube multiple times? > > > > Thanks, > > Mehrdad > > > > *From:* ShaoFeng Shi [mailto:shaofengshi@apache.org] > *Sent:* 2016, September, 01 9:01 PM > > *To:* user > *Subject:* Re: Empty Cube > > > > ok; The table "kylin_sales" contains data for 2012 and 2013, so need make > sure the build range covers these years; please have a check and I guess = it > is some minor mistake; BTW, empty cube will return zero since it doesn't > have data. > > > > 2016-09-02 1:34 GMT+08:00 Niasari, Mehrdad : > > Thanks for the reply. > > > > There is no error in the log. Also I checked the hive tables and they are > not empty; I can run any query on them using Hue and work well. > > > > Also the size of cube in the cubes section in 0.00KB! But even with an > empty cube the result of queries on the tables should not be empty/zero, > right? > > Any other suggestion how to debug it? > > > > Thanks, > > Mehrdad > > > > *From:* ShaoFeng Shi [mailto:shaofengshi@apache.org] > *Sent:* 2016, August, 31 9:04 PM > *To:* user > *Subject:* Re: Empty Cube > > > > Hi Mehrdad, > > > > When you run the query, is there any error reported in the logs/kylin.log= ? > > > > If no error, please check whether the source hive table has data, you can > do this easily in hive, by running HQL "select * from default.kylin_sales > limit 100"; it is very likely that the "sample.sh" failed to upload the > file; if it is this case, you may need manually import the data files > (sample_cube/data) to hive; > > > > 2016-09-01 4:06 GMT+08:00 Niasari, Mehrdad : > > Hi All, > > > > When I run the sample cube of Kylin the result is empty, i.e. the cube is > computed successfully, the status is ready but nothing is in the cube and > every query gets zero. > > Do you have any suggestion what can cause the problem? > > How should I debug it? > > > > Thanks, > > Mehrdad > > > > > > _______________________________________________________________________ > > If you received this email in error, please advise the sender (by return > email or otherwise) immediately. You have consented to receive the attach= ed > electronically at the above-noted email address; please retain a copy of > this confirmation for future reference. > > Si vous recevez ce courriel par erreur, veuillez en aviser l'exp=C3=A9dit= eur > imm=C3=A9diatement, par retour de courriel ou par un autre moyen. Vous av= ez > accept=C3=A9 de recevoir le(s) document(s) ci-joint(s) par voie =C3=A9lec= tronique =C3=A0 > l'adresse courriel indiqu=C3=A9e ci-dessus; veuillez conserver une copie = de > cette confirmation pour les fins de reference future. > > > > > > -- > > Best regards, > > > > Shaofeng Shi > > > > _______________________________________________________________________ > > If you received this email in error, please advise the sender (by return > email or otherwise) immediately. You have consented to receive the attach= ed > electronically at the above-noted email address; please retain a copy of > this confirmation for future reference. > > Si vous recevez ce courriel par erreur, veuillez en aviser l'exp=C3=A9dit= eur > imm=C3=A9diatement, par retour de courriel ou par un autre moyen. Vous av= ez > accept=C3=A9 de recevoir le(s) document(s) ci-joint(s) par voie =C3=A9lec= tronique =C3=A0 > l'adresse courriel indiqu=C3=A9e ci-dessus; veuillez conserver une copie = de > cette confirmation pour les fins de reference future. > > > > > > -- > > Best regards, > > > > Shaofeng Shi > > > > _______________________________________________________________________ > > If you received this email in error, please advise the sender (by return > email or otherwise) immediately. You have consented to receive the attach= ed > electronically at the above-noted email address; please retain a copy of > this confirmation for future reference. > > Si vous recevez ce courriel par erreur, veuillez en aviser l'exp=C3=A9dit= eur > imm=C3=A9diatement, par retour de courriel ou par un autre moyen. Vous av= ez > accept=C3=A9 de recevoir le(s) document(s) ci-joint(s) par voie =C3=A9lec= tronique =C3=A0 > l'adresse courriel indiqu=C3=A9e ci-dessus; veuillez conserver une copie = de > cette confirmation pour les fins de reference future. > > --=20 Best regards, Shaofeng Shi --94eb2c0766c62b127a053c0cb1e8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Niasari,

During the query time, Kyli= n will not touch Hive, all queries will go to HBase, so you still get resul= ts on kylin_cal_dt; If you also want to remove that also in Kylin, please d= isable and then drop the cube.

For the empty cube,= it is possible and allowed in Kylin; Thinking that an user uses incrementa= l build, and for a time period there is no source data, so empty cube is ex= pected. Of course you can configure Kylin to let it report error when there= is no source record, see:=C2=A0https://issues.apache.org/jira/browse/KYLIN-1752

For the empty cube issue, I guess there is some thing = wrong, making no data be built into cube. If you want to get remote debug o= r support, please contact me offline.



2016-09-07 5:= 17 GMT+08:00 Niasari, Mehrdad <mehrdad.niasari@rbc.com>:

The range is up to 2015 a= nd that=E2=80=99s not the problem.

=C2=A0

The only query that doesn= =E2=80=99t return zero/empty result is from table kylin_cal_dt. When I dele= te this table from hive, still the result is not empty and Kylin doesn=E2=80=99t complain! Where does Kylin bring the data of this table ev= en when it=E2=80=99s not on hive?

Also I checked the cube i= tself on Hbase and it=E2=80=99s empty. Any other suggestion? Can it be beca= use of some wrong configuration in connecting Kylin to Hive/Hbase? If that=E2=80=99s the case why it can create the cube successfully?=

=C2=A0

Also I have a question re= garding uuid. What is this for?

I=E2=80=99m asking this c= ause I cannot fully understand that why you have used a fixed value in samp= le cube json files (for example for kylin_sales_cube uuid is: =E2=80=9C2fbc= a32a-a33e-4b69-83dd-0bb8b1f8c53b=E2=80=9D). How come it doesn=E2=80=99t conflict if you run the sample cube multiple t= imes?

=C2=A0

Thanks,

Mehrdad

=C2=A0

From: ShaoFeng= Shi [mailto:sh= aofengshi@apache.org]
Sent: 2016, September, 01 9:01 PM

<= br> To: user
Subject: Re: Empty Cube

=C2=A0

ok; The table "kylin_sales" contains data = for 2012 and 2013, so need make sure the build range covers these years; pl= ease have a check and I guess it is some minor mistake; BTW, empty cube wil= l return zero since it doesn't have data.

=C2=A0

2016-09-02 1:34 GMT+08:00 Niasari, Mehrdad <mehrdad.niasari@rbc= .com>:

Thanks for the reply.

=C2=A0

There is no error in the = log. Also I checked the hive tables and they are not empty; I can run any query on them using Hue and work well.

=C2=A0

Also the size of cube in = the cubes section in 0.00KB! But even with an empty cube the result of quer= ies on the tables should not be empty/zero, right?

Any other suggestion how = to debug it?

=C2=A0

Thanks,<= /u>

Mehrdad<= /u>

=C2=A0

From: ShaoFeng= Shi [mailto:sh= aofengshi@apache.org]
Sent: 2016, August, 31 9:04 PM
To: user
Subject: Re: Empty Cube

=C2=A0

Hi Mehrdad,

=C2=A0

When you run the query, is there any error reported = in the logs/kylin.log?

=C2=A0

If no error, please check whether the source hive ta= ble has data, you can do this easily in hive, by running HQL "select *= from default.kylin_sales limit 100"; it is very likely that the "sample.sh" failed to upload the file; if it is this ca= se, you may need manually import the data files =C2=A0(sample_cube/data) to= hive;=C2=A0

=C2=A0

2016-09-01 4:06 GMT+08:00 Niasari, Mehrdad <mehrdad.niasari@rbc= .com>:

Hi All,

=C2=A0

When I run the sample cube of Kylin the= result is empty, i.e. the cube is computed successfully, the status is ready but nothing is in the cube and every query gets zero.<= u>

Do you have any suggestion what can cau= se the problem?

How should I debug it?=

=C2=A0

Thanks,

Mehrdad

=C2=A0

=C2=A0

___________________________________= ____________________________________

If you received this email in error, ple= ase advise the sender (by return email or otherwise) immediately. You have = consented to receive the attached electronically at the above-noted email a= ddress; please retain a copy of this confirmation for future reference.

Si vous recevez ce courriel par erreur, = veuillez en aviser l'exp=C3=A9diteur imm=C3=A9diatement, par retour de = courriel ou par un autre moyen. Vous avez accept=C3=A9 de recevoir le(s) do= cument(s) ci-joint(s) par voie =C3=A9lectronique =C3=A0 l'adresse courriel indiqu=C3=A9e ci-dessus; veuillez conserver une copie de cette co= nfirmation pour les fins de reference future.



=C2=A0

--

Best regards,

=C2=A0

Shaofeng Shi

=C2=A0

___________________________________= ____________________________________

If you received this email in error, ple= ase advise the sender (by return email or otherwise) immediately. You have = consented to receive the attached electronically at the above-noted email a= ddress; please retain a copy of this confirmation for future reference.

Si vous recevez ce courriel par erreur, = veuillez en aviser l'exp=C3=A9diteur imm=C3=A9diatement, par retour de = courriel ou par un autre moyen. Vous avez accept=C3=A9 de recevoir le(s) do= cument(s) ci-joint(s) par voie =C3=A9lectronique =C3=A0 l'adresse courriel indiqu=C3=A9e ci-dessus; veuillez conserver une copie de cette co= nfirmation pour les fins de reference future.



=C2=A0

--

Best regards,

=C2=A0

Shaofeng Shi

=C2=A0

_____________________________________= __________________________________

If you received this email in error, pleas= e advise the sender (by return email or otherwise) immediately. You have co= nsented to receive the attached electronically at the above-noted email add= ress; please retain a copy of this confirmation for future reference.

Si vous recevez ce courriel par erreur, ve= uillez en aviser l'exp=C3=A9diteur imm=C3=A9diatement, par retour de co= urriel ou par un autre moyen. Vous avez accept=C3=A9 de recevoir le(s) docu= ment(s) ci-joint(s) par voie =C3=A9lectronique =C3=A0 l'adresse courrie= l indiqu=C3=A9e ci-dessus; veuillez conserver une copie de cette confirmati= on pour les fins de reference future.




--
Be= st regards,

Shaofeng Shi

--94eb2c0766c62b127a053c0cb1e8--