kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From praveen kumar <praveenec...@gmail.com>
Subject Re: Re: Reg:Doubt About Cube Planner
Date Fri, 11 May 2018 12:59:07 GMT
Hi Gang,

In System_Cube HIVE_METRICS_QUERY_PROD Cube  not Available.

System Cube only Available below mentioned Qube.

HIVE_METRICS_JOB_EXCEPTION_QA
HIVE_METRICS_JOB_QA
HIVE_METRICS_QUERY_CUBE_QA
HIVE_METRICS_QUERY_QA
HIVE_METRICS_QUERY_RPC_QA


On Thu, May 10, 2018 at 12:00 PM, Ma Gang <mg4work@163.com> wrote:

> Hi Kumar,
> The dashboard data is from system cube, not from jmx, you can run sql in
> 'KYLIN_SYSTEM' project to check whether the data has been collected
> correctly or not:
> "select KDAY_DATE, count(1) from HIVE_METRICS_QUERY_PROD where KDAY_DATE >
> '2018-05-01' group by KDAY_DATE order by KDAY_DATE desc"
>
> It may take hours for the dashboard to show query metrics(depends on how
> frequent you build the system cube), for how to setup system cube, you may
> refer: http://kylin.apache.org/docs23/howto/howto_setup_systemcube.html
>
> At 2018-05-09 21:59:31, "praveen kumar" <praveenece37@gmail.com> wrote:
>
> Hi ,
>
>    i attached dashboard image also kindly check it.
>
> On Wed, May 9, 2018 at 5:41 PM, praveen kumar <praveenece37@gmail.com>
> wrote:
>
>> Hi,
>>
>>           i tried to collect Query metrics so i followed below steps.
>>
>>           Below mentioned steps are done,but still in Kylin Dashboard
>> (Query count and other items are Zero)what i want to do ?
>>
>> i checked jmx also for query count and pass,fail count are correctly
>> showing but not record to kylin dashboard.
>>
>> what steps i missed kindly give me steps?
>>
>>    1. set following commands to setenv.sh
>>
>> export KYLIN_DEBUG_SETTINGS="-Dcom.sun.management.jmxremote
>> -Dcom.sun.management.jmxremote.authenticate=false
>> -Dcom.sun.management.jmxremote.ssl=false
>> -Dcom.sun.management.jmxremote.port=8008 -Djava.rmi.server.hostname=your
>> server IP -Dcom.sun.management.jmxremote.rmi.port=8008
>> -Dcom.sun.management.jmxremote.local.only=false"
>>
>> 2. restart kylin server
>> 3. test a query
>> 4. run jconsole on my local computer
>> 5. connect remote kylin server with ip:port
>> 6. click MBean button and find Hadoop-kylin-*** MBeans.
>>
>> Kindly Give me Steps to solve this problem?
>>
>>
>
>
>
>

Mime
View raw message