kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ma Gang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-3434) Support prepare statement in Kylin server side
Date Fri, 29 Jun 2018 08:13:00 GMT
Ma Gang created KYLIN-3434:
------------------------------

             Summary: Support prepare statement in Kylin server side
                 Key: KYLIN-3434
                 URL: https://issues.apache.org/jira/browse/KYLIN-3434
             Project: Kylin
          Issue Type: Improvement
            Reporter: Ma Gang
            Assignee: Ma Gang


Kylin use calcite as sql engine, when a sql comes to Kylin server, it requires to be parsed,
optimized, code gen, and then query Kylin's cube storage, the previous 3 steps often take
50-150 ms to complete(depends on the complexity of the sql). If we support to cache the parsed
result in Kylin server, the 3 steps will be saved.

The idea is to cache calcite's PreparedStatement object and related OLAPContexts in the server
side, when the prepare request comes with the same sql, reuse the PreparedStatement to do
the execution. Since the PreparedStatement is not thread safe, so I planned to use ObjectPool
to cache the PreparedStatement.(use apache commons-pool lib)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message