hi vipul, what version are you using? before https://issues.apache.org/jira/browse/KYLIN-740 we did spot some critical performance issues caused by many IN clauses, if you could help to provide a CPU/heap analysis(on your hbase's region server) it would be easier to address the problem.
On Mon, Sep 21, 2015 at 10:42 PM, vipul jhawar <[email protected]> wrote: > Hi > > Have noticed a pattern that which caused the co processor to spike the > regionserver cpu to 100% over time. > If we end up issuing a query thru kylin which may involve a scanning a lot > of data assuming multiple days with multiple filters for many dimensions in > which case it has to scan a large number of rows and if it doesnt return in > the required rpc timeout then the client does get an error message with the > exception, but on the regionserver we see no end to processing and it > ultimately hogs the regionserver. > > Are there any configs on the coprocessor which can be configured to say > that if the processing is not completed in N time, then simply timeout as > that way we can look at the queries later but avoid cpu spike as it makes > the cluster unusable. > > Thanks > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
