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