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

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Engine
    • Labels:
      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. NormalQueryExecution.jpg
          9 kB
          Gladson Vas
        2. NormalQueryExecution1.jpg
          20 kB
          Gladson Vas
        3. SlowQueryExecution.jpg
          12 kB
          Gladson Vas
        4. SlowQueryExecution1.jpg
          21 kB
          Gladson Vas

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              gladson.vas Gladson Vas
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: