Hi Gang,
i checked Data from System Cube tables.In hive side all records
are available.but when i build system cube segment wise means the total
records not updated.
*(Updated Total records from Full Cube Build System Cube)*
Ex:
in hive side update
HIVE_METRICS_QUERY_CUBE_QA
records per date =23 records
In kylin(After segment wise build)
HIVE_METRICS_QUERY_CUBE_QA
records per date =15records
remaining records not updated in kylin
Why remaining records not updated?
On Fri, May 11, 2018 at 6:29 PM, praveen kumar <[email protected]>
wrote:
> 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 <[email protected]> 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" <[email protected]> wrote:
>>
>> Hi ,
>>
>> i attached dashboard image also kindly check it.
>>
>> On Wed, May 9, 2018 at 5:41 PM, praveen kumar <[email protected]>
>> 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?
>>>
>>>
>>
>>
>>
>>
>
>
