[
https://issues.apache.org/jira/browse/DRILL-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15879394#comment-15879394
]
ASF GitHub Bot commented on DRILL-5290:
---------------------------------------
GitHub user ppadma opened a pull request:
https://github.com/apache/drill/pull/757
DRILL-5290: Provide an option to build operator table once for built-…
…in static functions and reuse it across queries.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/ppadma/drill DRILL-5290
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/757.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #757
----
commit 67ae503b0b820cd9f40ae3ef8d703e9135f90a74
Author: Padma Penumarthy <[email protected]>
Date: 2017-02-22T18:31:01Z
DRILL-5290: Provide an option to build operator table once for built-in
static functions and reuse it across queries.
----
> Provide an option to build operator table once for built-in static functions
> and reuse it across queries.
> ---------------------------------------------------------------------------------------------------------
>
> Key: DRILL-5290
> URL: https://issues.apache.org/jira/browse/DRILL-5290
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.9.0
> Reporter: Padma Penumarthy
> Assignee: Padma Penumarthy
> Fix For: 1.10
>
>
> Currently, DrillOperatorTable which contains standard SQL operators and
> functions and Drill User Defined Functions (UDFs) (built-in and dynamic) gets
> built for each query as part of creating QueryContext. This is an expensive
> operation ( ~30 msec to build) and allocates ~2M on heap for each query. For
> high throughput, concurrent low latency operational queries, we quickly run
> out of heap memory, causing JVM hangs. Build operator table once during
> startup for static built-in functions and save in DrillbitContext, so we can
> reuse it across queries.
> Provide an system/session option to not use dynamic UDFs so we can use the
> operator table saved in DrillbitContext and avoid building each time.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
