Abhishek Girish created DRILL-4300:
--------------------------------------

             Summary: 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