[jira] [Updated] (DRILL-4300) Query fails with "DrillRuntimeException: Failed to pre-allocate memory for SV"

["Abhishek Girish (JIRA)" <ji...@apache.org>]

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

Abhishek Girish updated DRILL-4300:
-----------------------------------
    Attachment: drillbit.log.txt

> Query fails with "DrillRuntimeException: Failed to pre-allocate memory for SV"
> ------------------------------------------------------------------------------
>
>                 Key: DRILL-4300
>                 URL: https://issues.apache.org/jira/browse/DRILL-4300
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.5.0
>         Environment: Commit ID: 3d0b4b02521f12e3871d6060c8f9bfce73b218a0
>            Reporter: Abhishek Girish
>         Attachments: drillbit.log.txt
>
>
> The following query fails when other queries were running concurrently:
> {code}
> alter session set `planner.enable_hashjoin` = false;
> select ws1.* from widestrings ws1 INNER JOIN (select str_var_null_empty from widestrings where str_var_null_empty is not null and length(str_var_null_empty) <> 0 )ws2 on ws1.str_empty=ws2.str_var_null_empty where ws1.str_empty is not null and length(ws1.str_empty) <> 0;
> alter session set `planner.enable_hashjoin` = true;
> {code}
> Error:
> {code}
> [#2157] Query failed: 
> oadd.org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: DrillRuntimeException: Failed to pre-allocate memory for SV. Existing recordCount*4 = 0, incoming batch recordCount*4 = 3348
> {code}
> Log attached. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)