Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-4079

Concurrent query requests using Query API makes the query execution take too much time

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Not A Problem
    • None
    • None
    • Query Engine
    • None

    Description

      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.

                      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.

       

                      There seems to be some problem when queries are fired in parallel to kylin.Please help.

       

      Attachments

        1. NormalQueryExecution1.jpg
          20 kB
          Gladson Vas
        2. NormalQueryExecution.jpg
          9 kB
          Gladson Vas
        3. SlowQueryExecution1.jpg
          21 kB
          Gladson Vas
        4. SlowQueryExecution.jpg
          12 kB
          Gladson Vas

        Activity

          People

            Unassigned Unassigned
            gladson.vas Gladson Vas
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: