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? >> >> > > > >
