From user-return-3250-archive-asf-public=cust-asf.ponee.io@kylin.apache.org Mon May 7 09:34:22 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 86AE3180648 for ; Mon, 7 May 2018 09:34:21 +0200 (CEST) Received: (qmail 39587 invoked by uid 500); 7 May 2018 07:34:20 -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 39576 invoked by uid 99); 7 May 2018 07:34:20 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 May 2018 07:34:20 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 97F331A2B51 for ; Mon, 7 May 2018 07:34:19 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.129 X-Spam-Level: ** X-Spam-Status: No, score=2.129 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id k7_eWOJjMOAd for ; Mon, 7 May 2018 07:34:18 +0000 (UTC) Received: from mail-ot0-f171.google.com (mail-ot0-f171.google.com [74.125.82.171]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 31B405F485 for ; Mon, 7 May 2018 07:34:17 +0000 (UTC) Received: by mail-ot0-f171.google.com with SMTP id n1-v6so30938039otf.7 for ; Mon, 07 May 2018 00:34:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=aYdG5Wn1uRh7jjxhjHBchBWMWGPWXb3NkJCITOXAeDE=; b=odGwCGOMAsanbIYRCQ+WU0BgJPpjLrVP/+P3OmlXR9lO4qK/cfTkoWJx+VHtkFcm9w mJxkHVrIctOe+0GMjfuUmRiriFPff+PWGoFXk4hFYIfafnVnJm0vBx75eQV6cXJ4rTQX YVxtwU0LhR0mSqd8g9ZTEzsRV8jhO2YEJvUbwaZyYM3HdtUxhWHrA9EINkmjhInYiOPA CkOYItawW1c68RYzELsc123tXWS3snsjTjHXDs45WZ8iOyqZn2OZrnfnQyrCq+qK6s9x 6FkIz/SQlpXe+HosMt4x1jD7QvP9sr1Wie/ARXH78EBR6Wx70kaVLQxe7eeTDgJRY2++ Va1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=aYdG5Wn1uRh7jjxhjHBchBWMWGPWXb3NkJCITOXAeDE=; b=clo64FSv7mpULZ64/UNFB1XqFK2dtffHmZuYHSMMW24/aZy0tDdl7SU2YcL1llu6BW OEwJ6h4+EFbmLOyLR2eYxy3Hc/Z3MfaHhs3CxaAXVz7DXvKPs50tN+P6Am8IT9faTuWR AGYOpXjbHfRTe3t27zmiiDTwm6rWo6TWVsQWJmaZSmHRme/4Zsm8xLV6hflgXMoAuf+U fBgKu95fAqqkq7g/1YiJ85MlqzyTT8En2PQeeL5ac4W92tBoxb4pm7xdXVqs5g7tndzv 7rl7SUof+md2m4zRn3qgi9++Ir7fzDJiRYDU0L9kIt67Z/+cRI76gKAHveduB4aatzTj 3l1w== X-Gm-Message-State: ALQs6tDiLJit0+BTq1EWpsgvWqBzawWMVb4MH+qUWYl2nD15/OMkGC1W iJQdfUkK8BSEBOdtbFCE5v2YVkZzMgNUVpMCWdQ= X-Google-Smtp-Source: AB8JxZo5a9ii33aCRifBLEom53I0WZoZxEP6VnDKZZTBT26Z0FsaoS6XbeAkNg5VWpxcYFu2Rj97u9eA8GLQC6uhUBI= X-Received: by 2002:a9d:2511:: with SMTP id k17-v6mr8191724otb.129.1525678454144; Mon, 07 May 2018 00:34:14 -0700 (PDT) MIME-Version: 1.0 Received: by 10.201.47.71 with HTTP; Mon, 7 May 2018 00:34:13 -0700 (PDT) In-Reply-To: References: From: praveen kumar Date: Mon, 7 May 2018 13:04:13 +0530 Message-ID: Subject: Re: [jira] [Commented] (KYLIN-3351) Cube Planner not working in apche kylin 2.3.0(open Source) To: user@kylin.apache.org Content-Type: multipart/alternative; boundary="0000000000004d02c5056b98b238" --0000000000004d02c5056b98b238 Content-Type: text/plain; charset="UTF-8" Hi Team, Could you Response my last questions? i was builded System Cubes 3 -matrix cubes 2-job cubes are came with zero records, and also enabled recommend buttons and other items in Cube planner tab. i was hit queries to my Cube regularly but Cube planner could not reflected like Color changes and other items i struck on that kindly response me and guide me On Fri, May 4, 2018 at 1:19 PM, praveen kumar wrote: > Hi Zhong, > > i builded System Cubes but Source records is zero. > whether i want to do any Data level? > > Can you please Guide me? > > Regards > Praveen. G > > > > > > > On Wed, May 2, 2018 at 1:34 PM, Zhong Yanghong (JIRA) > wrote: > >> >> [ https://issues.apache.org/jira/browse/KYLIN-3351?page=com.at >> lassian.jira.plugin.system.issuetabpanels:comment-tabpanel& >> focusedCommentId=16460678#comment-16460678 ] >> >> Zhong Yanghong commented on KYLIN-3351: >> --------------------------------------- >> >> Hi [~praveenece], have you build system cubes to collect query metrics? >> >> > Cube Planner not working in apche kylin 2.3.0(open Source) >> > ---------------------------------------------------------- >> > >> > Key: KYLIN-3351 >> > URL: https://issues.apache.org/jira/browse/KYLIN-3351 >> > Project: Kylin >> > Issue Type: Task >> > Reporter: praveenece >> > Priority: Major >> > >> > Hi Team >> > i want test Cube planner in apache-kylin(2.3.0),So i created cube >> with segment, and i hit query to cube many times more than thousands but >> the cube planner there is no change in cuboid level like color changing and >> not get COUNT in exactly row count and other items.can u please guide me. >> > Note: >> > Could u tell me? >> > Cube Planner Working only old Cube (like 3 month before) or new Cube >> also. >> > Configuration(kylin.Properties) >> > kylin.cube.cubeplanner.enabled=true >> > Kylin Version=2.3.0(SINGLE NODE) >> > MyCube creation =10days before >> > I referred: http://kylin.apache.org/docs23 >> /howto/howto_use_cube_planner.html >> > >> >> >> >> -- >> This message was sent by Atlassian JIRA >> (v7.6.3#76005) >> > > --0000000000004d02c5056b98b238 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Team,

=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0Could you Response my last questions?
i was builded = System Cubes 3 -matrix cubes 2-job cubes are came with zero records, and al= so=C2=A0 enabled recommend buttons and other items in Cube planner tab.
i was hit=C2=A0 queries to my Cube regularly but Cube planner could = not reflected like Color changes and other items

i= struck on that kindly response me and guide me=C2=A0

<= div>



=
On Fri, May 4, 2018 at 1:19 PM, praveen kumar <praveenece37@gmail.com> wrote:
Hi Zhong,

=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 i builded System Cubes but Source recor= ds is zero.=C2=A0
whether i want to do any Data level?
=
Can you please Guide me?

Regards
Praveen. G




<= /div>


On Wed, May 2, 2018 at 1:34= PM, Zhong Yanghong (JIRA) <jira@apache.org> wrote:
=

=C2=A0 =C2=A0 [ https://issues.apache.org/jira/browse/KYLIN-3351?page=3Dco= m.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&am= p;focusedCommentId=3D16460678#comment-16460678 ]

Zhong Yanghong commented on KYLIN-3351:
---------------------------------------

Hi [~praveenece], have you build system cubes to collect query metrics?

> Cube Planner not working in apche kylin 2.3.0(open Source)
> ----------------------------------------------------------
>
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Key: KYLI= N-3351
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0URL: https://issues.apache.org/jira/browse/KYLIN-3351
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Project: Kylin
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Issue Type: Task
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Reporter: praveenece
>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Priority: Major
>
> Hi Team=C2=A0
> =C2=A0 =C2=A0i want test Cube planner in apache-kylin(2.3.0),So i crea= ted cube with segment, and i hit query to cube many times more than thousan= ds but the cube planner there is no change in cuboid level like color chang= ing and not get COUNT in exactly row count and other items.can u please gui= de me.
> Note:
> Could u tell me?
> Cube Planner Working only old Cube (like 3 month before) or new Cube a= lso.
> Configuration(kylin.Properties)
> kylin.cube.cubeplanner.enabled=3Dtrue
> Kylin Version=3D2.3.0(SINGLE=C2=A0 NODE)
> MyCube creation =3D10days before=C2=A0
> I referred: http://kylin.apache= .org/docs23/howto/howto_use_cube_planner.html
> =C2=A0



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


--0000000000004d02c5056b98b238--