You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by " Kaige Liu (Jira)" <ji...@apache.org> on 2020/01/29 17:49:00 UTC
[jira] [Commented] (KYLIN-4079) Concurrent query requests using
Query API makes the query execution take too much time
[ https://issues.apache.org/jira/browse/KYLIN-4079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17026078#comment-17026078 ]
Kaige Liu commented on KYLIN-4079:
-----------------------------------
That makes sense. There will be always a concurrency threshold for every query engine. For kylin, It usually depends on your HBase cluster, the resources (cpu/mem) kylin server can get and the complexity of your queries.
This article shows kylin reaches 90 qps. [https://kyligence.io/blog/how-ciscos-big-data-team-improved-apache-kylins-high-concurrent-throughput-by-5x/]
And there is always more space to increate qps in kylin. If you can catch the bottleneck in your environment, and share more information with the community, that will be very great!
> Concurrent query requests using Query API makes the query execution take too much time
> --------------------------------------------------------------------------------------
>
> Key: KYLIN-4079
> URL: https://issues.apache.org/jira/browse/KYLIN-4079
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Reporter: Gladson Vas
> Priority: Blocker
> Attachments: NormalQueryExecution.jpg, NormalQueryExecution1.jpg, SlowQueryExecution.jpg, SlowQueryExecution1.jpg
>
>
> Hi,
> When 40 queries are executed on kylin parallelly (at once) the response time distribution is as below, with min, max and mean response time as 6557,7580 and 6887 ms respectively.
> Kylin doesn’t seem to handle parallel execution of queries.
> !SlowQueryExecution.jpg!
> !SlowQueryExecution1.jpg!
> But when 40 queries are executed over 40 seconds i.e one query executed per second the response time distribution is as below, with min, max and mean response time as 110,2820 and 248 ms respectively.
> This seems fine as the mean response time in less than a second.
>
> !NormalQueryExecution.jpg!
> !NormalQueryExecution1.jpg!
> There seems to be some problem when queries are fired in parallel to kylin.Please help.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)