You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 柯 <12...@qq.com> on 2020/01/08 10:55:41 UTC
Kylin 2.6.3 Dashboard no data
Dear all:
kylin 2.6.3.
I have already set kylin dashboard by reference to this page http://kylin.apache.org/docs/tutorial/use_dashboard.html and build job of KYLIN_SYSTEM cube is successful every day. But the KYLIN_SYSTEM cubes are empty （cube size 0Kb, source records 0）. The Dashboard page only show "Total cube count" and "Avg cube expansion" and the other values is 0 or "No data".
I need help.I will be very grateful. Thanks for your watching!
回复： Kylin 2.6.3 Dashboard no data
Posted by 柯 <12...@qq.com>.
Hi AS:
Thank for your reply.I will check and adjust the configuration according to your suggestion.
Thank you very much!!
------------------ 原始邮件 ------------------
发件人: "AS"<allensu213@163.com>;
发送时间: 2020年1月8日(星期三) 晚上11:30
收件人: "user@kylin.apache.org"<user@kylin.apache.org>;
主题: Re: Kylin 2.6.3 Dashboard no data
Hi,
There are serveral points you need to check:
1. Make sure all the node(either all or query node) has these properties:
kylin.cube.cubeplanner.enabled=true kylin.server.query-metrics2-enabled=true kylin.metrics.reporter-query-enabled=true kylin.metrics.reporter-job-enabled=true kylin.metrics.monitor-enabled=true
Maybe the first one is not necessary. Refer to http://kylin.apache.org/docs/tutorial/use_cube_planner.html
I think those properties is used to permit kylin to collect query data.
2. Make sure your kylin user have the permission to write those hive tables about kylin system cube.
Sorry for my poor English. Hope those message could help you.
On 01/8/2020 19:53，Yaqian Zhang<Yaqian_Zhang@126.com> wrote：
Hi:
Is there any data in the corresponding hive table?
在 2020年1月8日，18:55，柯 <123033934@qq.com> 写道：
Dear all:
kylin 2.6.3.
I have already set kylin dashboard by reference to this page http://kylin.apache.org/docs/tutorial/use_dashboard.html and build job of KYLIN_SYSTEM cube is successful every day. But the KYLIN_SYSTEM cubes are empty （cube size 0Kb, source records 0）. The Dashboard page only show "Total cube count" and "Avg cube expansion" and the other values is 0 or "No data".
I need help.I will be very grateful. Thanks for your watching!
<71A1A16C@A17D4C50.2DB5155E.jpg>
<ECC76D38@CC7CD46D.2DB5155E.jpg>
<E577092F@71C0EC50.2DB5155E.jpg>
Re: Kylin 2.6.3 Dashboard no data
Posted by AS <al...@163.com>.
Hi,
There are serveral points you need to check:
1. Make sure all the node(either all or query node) has these properties:
|
kylin.cube.cubeplanner.enabled=true
kylin.server.query-metrics2-enabled=true
kylin.metrics.reporter-query-enabled=true
kylin.metrics.reporter-job-enabled=true
kylin.metrics.monitor-enabled=true
|
Maybe the first one is not necessary. Refer to http://kylin.apache.org/docs/tutorial/use_cube_planner.html
I think those properties is used to permit kylin to collect query data.
2. Make sure your kylin user have the permission to write those hive tables about kylin system cube.
Sorry for my poor English. Hope those message could help you.
On 01/8/2020 19:53，Yaqian Zhang<Ya...@126.com> wrote：
Hi:
Is there any data in the corresponding hive table?
在 2020年1月8日，18:55，柯 <12...@qq.com> 写道：
Dear all:
kylin 2.6.3.
I have already set kylin dashboard by reference to this page http://kylin.apache.org/docs/tutorial/use_dashboard.html and build job of KYLIN_SYSTEM cube is successful every day. But the KYLIN_SYSTEM cubes are empty （cube size 0Kb, source records 0）. The Dashboard page only show "Total cube count" and "Avg cube expansion" and the other values is 0 or "No data".
I need help.I will be very grateful. Thanks for your watching!
<71...@A17D4C50.2DB5155E.jpg>
<EC...@CC7CD46D.2DB5155E.jpg>
<E5...@71C0EC50.2DB5155E.jpg>
回复： Kylin 2.6.3 Dashboard no data
Posted by 柯 <12...@qq.com>.
Hi Zhang Yaqian:
Thank for your reply.I checked the hive table,the are both empty a total of five tables.
What do i need to modify the configuration to put data in the tables?
Thank you!!
------------------ 原始邮件 ------------------
发件人: "Yaqian Zhang"<Yaqian_Zhang@126.com>;
发送时间: 2020年1月8日(星期三) 晚上7:53
收件人: "user"<user@kylin.apache.org>;
主题: Re: Kylin 2.6.3 Dashboard no data
Hi:
Is there any data in the corresponding hive table?
在 2020年1月8日，18:55，柯 <123033934@qq.com> 写道：
Dear all:
kylin 2.6.3.
I have already set kylin dashboard by reference to this page http://kylin.apache.org/docs/tutorial/use_dashboard.html and build job of KYLIN_SYSTEM cube is successful every day. But the KYLIN_SYSTEM cubes are empty （cube size 0Kb, source records 0）. The Dashboard page only show "Total cube count" and "Avg cube expansion" and the other values is 0 or "No data".
I need help.I will be very grateful. Thanks for your watching!
<71A1A16C@A17D4C50.2DB5155E.jpg>
<ECC76D38@CC7CD46D.2DB5155E.jpg>
<E577092F@71C0EC50.2DB5155E.jpg>
Re: Kylin 2.6.3 Dashboard no data
Posted by Yaqian Zhang <Ya...@126.com>.
Hi:
Is there any data in the corresponding hive table?
> 在 2020年1月8日，18:55，柯 <12...@qq.com> 写道：
>
> Dear all:
> kylin 2.6.3.
> I have already set kylin dashboard by reference to this page http://kylin.apache.org/docs/tutorial/use_dashboard.html <http://kylin.apache.org/docs/tutorial/use_dashboard.html> and build job of KYLIN_SYSTEM cube is successful every day. But the KYLIN_SYSTEM cubes are empty （cube size 0Kb, source records 0）. The Dashboard page only show "Total cube count" and "Avg cube expansion" and the other values is 0 or "No data".
> I need help.I will be very grateful. Thanks for your watching!
>
> <71...@A17D4C50.2DB5155E.jpg>
>
> <EC...@CC7CD46D.2DB5155E.jpg>
>
> <E5...@71C0EC50.2DB5155E.jpg>
>