Thank you ,Yaqian, for the prompt response. I did not realize that these values were not added as dimensions, so your explanation makes sense.
Thanks Preeti ________________________________ From: Yaqian Zhang <[email protected]> Sent: Tuesday, June 16, 2020 4:06 AM To: [email protected] <[email protected]> Subject: Re: Query latency information not see in Kylin Metrics cube Hi Preeti: I believe you should understand kylin's precomputing features. Kylin does not save the table details. When you query the whole table, you can only see the details of the columns added as dimension. When you query the detailed values of metrics you want in KYLIN_SYSYTEM project, such as query latency, you will find that it is empty, because there is not included in the dimension of KYLIN_HIVE_METRICS_QUERY_QA, if you need it, you can add it to the dimension. In the dashboard, you can see AVG QUERY LATENCY, because there is sum(QUERY_TIME_COST) in measure of KYLIN_HIVE_METRICS_QUERY_QA, so the average value can be calculated from the pre calculation result of this measure. The table details are stored in hive, so you can query the details in hive. 在 2020年6月16日，09:56，Preeti Vipin <[email protected]<mailto:[email protected]>> 写道： Hi I have enabled Kylin dashboard on my cluster and it seems to work fine, I am able to get a lot of details I need from the dashboard page. However, for reporting to management on a regular basis, I need a little bit more control on the data. So, I am trying to connect PowerBI to the cubes, which I was able to do successfully. While in the process of going over the data I noticed that the data looks good in all the dashboard, but the KYLIN_HIVE_METRICS_QUERY_RPC_QA cube has the columns Call_Time, Count_Scan, Count_Return etcempty. <image.png> But I am assuming this data is there somewhere, because I see query latency info etc on the dashboard. And my understanding is it should be in the KYLIN_HIVE_METRICS_QUERY_RPC_QA cube. Even in the KYLIN_HIVE_METRICS_QUERY_QA I don't see query_time_cost etc, it is is empty., <image.png> And the raw data is there in HIVE. So why is not showing up when I query the cube in Kylin UI? Am I missing something here or looking at the wrong place? I am using Kylin 2.6.4 and I set up the system cube using the scripts in the documentation and am building the cubes every hour Here is the screenshot of the HIVE raw data, which has this information <image.png> Here is a screenshot of the dashboard where I see the query latency info,where is it getting this info from? <image.png> Any help/guidance is appreciated Thanks Preeti
