[
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)
