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)