kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From praveen kumar <praveenec...@gmail.com>
Subject Re: [jira] [Commented] (KYLIN-3351) Cube Planner not working in apche kylin 2.3.0(open Source)
Date Fri, 11 May 2018 13:12:57 GMT
Hi  Chuqian
i optimized my Cube but not Display  Last optimized time in Cub planner tab
Page.
i referred below page
Kindly tell me any configuration or steps to follow?

User is able to get to know the last optimized time of the cube in Cube
Planner tab page.
http://kylin.apache.org/docs23/howto/howto_use_cube_planner.html




On Thu, May 10, 2018 at 9:05 AM, Chuqian Yu (JIRA) <jira@apache.org> wrote:

>
>     [ https://issues.apache.org/jira/browse/KYLIN-3351?page=
> com.atlassian.jira.plugin.system.issuetabpanels:comment-
> tabpanel&focusedCommentId=16469877#comment-16469877 ]
>
> Chuqian Yu commented on KYLIN-3351:
> -----------------------------------
>
> System cube uses HIVE table as data source, so you should use HiveSink  to
> store all these metrics. Try this way:
>
> 1. add  configs to kylin.properties
>
> ```
>
> kylin.server.query-metrics2-enabled=true
> kylin.metrics.reporter-query-enabled=true
> kylin.metrics.reporter-job-enabled=true
> kylin.metrics.monitor-enabled=true
>
> ```
>
>
>
> 2. Use hivesink in ./tomcat/webapps/kylin/WEB-INF/classes/kylinMetrics.xml
> {code:java}
> // code placeholder
> <!--
> Licensed under the Apache License, Version 2.0 (the "License");
> you may not use this file except in compliance with the License.
> You may obtain a copy of the License at
>
> http://www.apache.org/licenses/LICENSE-2.0
>
> Unless required by applicable law or agreed to in writing, software
> distributed under the License is distributed on an "AS IS" BASIS,
> WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
> See the License for the specific language governing permissions and
> limitations under the License. See accompanying LICENSE file.
> -->
>
> <beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns="http://www.springframework.org/schema/beans"
> xsi:schemaLocation="http://www.springframework.org/schema/beans
> http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">
>
> <description>Kylin Metrics Related Configuration</description>
>
> <bean id="instantReservoir" class="org.apache.kylin.metrics.lib.impl.
> InstantReservoir"/>
>
> <bean id="blockingReservoir" class="org.apache.kylin.metrics.lib.impl.
> BlockingReservoir">
> <constructor-arg index="0">
> <value>10</value>
> </constructor-arg>
> <constructor-arg index="1">
> <value>10</value>
> </constructor-arg>
> <constructor-arg index="2">
> <value>10</value>
> </constructor-arg>
> </bean>
>
> <bean id="hiveSink" class="org.apache.kylin.metrics.lib.impl.hive.
> HiveSink"/>
>
> <bean id="kafkaSink" class="org.apache.kylin.metrics.lib.impl.kafka.
> KafkaSink"/>
>
> <bean id="initMetricsManager" class="org.springframework.
> beans.factory.config.MethodInvokingFactoryBean">
> <property name="targetClass" value="org.apache.kylin.
> metrics.MetricsManager"/>
> <property name="targetMethod" value="initMetricsManager"/>
> <property name="arguments">
> <list>
> <ref bean="hiveSink"/>
> <map key-type="org.apache.kylin.metrics.lib.ActiveReservoir"
> value-type="java.util.List">
> <entry key-ref="blockingReservoir">
> <list>
> <bean class="org.apache.kylin.common.util.Pair">
> <property name="first"
> value="org.apache.kylin.metrics.lib.impl.hive.HiveReservoirReporter"/>
> <property name="second">
> <props>
> </props>
> </property>
> </bean>
> </list>
> </entry>
> </map>
> </list>
> </property>
> </bean>
>
> </beans>
> {code}
> 3. restart kylin
>
> 4. test a query
>
> 5. update system cube
>
>
>
>
>
> > 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)
>

Mime
View raw message