[ 
https://issues.apache.org/jira/browse/DRILL-4300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15111692#comment-15111692
 ] 

Victoria Markman commented on DRILL-4300:
-----------------------------------------

Duplicate of DRILL-4274

> 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)

Reply via email to