Can you pls. explain the issue in detail? Did you run query in "insight" section first? Its working fine there?
Regards, Manoj From: Kosmachev, Dmitry [mailto:dkosmac...@luxoft.com] Sent: Tuesday, May 29, 2018 3:47 PM To: user@kylin.apache.org Subject: Kylin performance Hi! We have a strange situation with Kylin performance. Sometimes queries to Kylin last hundreds and thousands seconds. Considering that our web portal runs several of these queries when user uses portal this performance issue leads to the situation when web portal stops working at all. Sometimes the same queries last several seconds (without using Kylin cache). We can't find any relations to HDFS or HBase performance. Are there any best practices to debug this situation and find the bottleneck? We don't understand if Kylin or HBase is the reason. By now we discovered that our biggest cube has 500 regions in HBase. We have default kylin.hbase.region.cut parameter and Kylin 2.1 version. I guess it's not normal situation to have hundrets of regions. Dmitry Kosmachev Senior Specialist T: +7 495 967 8030 Luxoft Moscow IT luxoft.com<https://secureweb.jpmchase.net/readonly/http:/www.luxoft.com/r/main/> <https://secureweb.jpmchase.net/readonly/http:/www.luxoft.com/r/signature-linkedin/><https://secureweb.jpmchase.net/readonly/http:/www.luxoft.com/r/signature-twitter/><https://secureweb.jpmchase.net/readonly/http:/www.luxoft.com/r/signature-youtube/><https://secureweb.jpmchase.net/readonly/http:/www.luxoft.com/r/signature-facebook/><https://secureweb.jpmchase.net/readonly/http:/www.luxoft.com/r/signature-google/> ________________________________ This e-mail and any attachment(s) are intended only for the recipient(s) named above and others who have been specifically authorized to receive them. They may contain confidential information. If you are not the intended recipient, please do not read this email or its attachment(s). Furthermore, you are hereby notified that any dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and then delete this e-mail and any attachment(s) or copies thereof from your system. Thank you. This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.