[jira] [Updated] (IGNITE-9480) SQL: Introduce H2 LocalResult factory

["Nikolay Izhikov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nikolay Izhikov updated IGNITE-9480:
------------------------------------
    Labels: h2-limitation  (was: )

> SQL: Introduce H2 LocalResult factory
> -------------------------------------
>
>                 Key: IGNITE-9480
>                 URL: https://issues.apache.org/jira/browse/IGNITE-9480
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 2.6
>            Reporter: Taras Ledkov
>            Priority: Major
>              Labels: h2-limitation
>             Fix For: 2.8
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> H2 collects query result at the instance of `LocalResult` for queries results that not be gathered lazy. This causes an OOME error on large result sets.
> We have to introduce way to use our own implementation of the query result's container.
> Suggestion fix:
> - H2 simple refactoring: make `LocalResult` interface and H2 default implementation `LocalResultImpl`
> - Add H2 configurable `LocalResultFactory` to setup custom implementation of the `LocalResult.
> - Create Ignite implementation of `LocalResultFactory` & `LocalResult` to track allocated memory, swap results to external storage etc.
> H2 issue: [#1405|https://github.com/h2database/h2database/issues/1405#issuecomment-417631253]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)