You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2017/05/10 23:33:04 UTC
[jira] [Created] (DRILL-5503) Disabling exchanges results in
"Unable to allocate sv2 buffer" error within the managed external sort code
Rahul Challapalli created DRILL-5503:
----------------------------------------
Summary: Disabling exchanges results in "Unable to allocate sv2 buffer" error within the managed external sort code
Key: DRILL-5503
URL: https://issues.apache.org/jira/browse/DRILL-5503
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow
Affects Versions: 1.10.0
Reporter: Rahul Challapalli
Assignee: Paul Rogers
Setup :
{code}
git.commit.id.abbrev=1e0a14c
No of drillbits : 1
DRILL_MAX_DIRECT_MEMORY="32G"
DRILL_MAX_HEAP="4G"
{code}
The below successfully completes
{code}
ALTER SESSION SET `exec.sort.disable_managed` = false;
alter session set `planner.width.max_per_node` = 1;
alter session set `planner.memory.max_query_memory_per_node` = 62600000;
alter session set `planner.width.max_per_query` = 17;
select count(*) from (select * from dfs.`/drill/testdata/resource-manager/5kwidecolumns_500k.tbl` order by columns[0]) d where d.columns[0] = '4041054511';
+---------+
| EXPR$0 |
+---------+
| 0 |
+---------+
1 row selected (814.104 seconds)
{code}
However if I disable exchanges, I get the following error
{code}
alter session set `planner.disable_exchanges` = false;
select count(*) from (select * from dfs.`/drill/testdata/resource-manager/5kwidecolumns_500k.tbl` order by columns[0]) d where d.columns[0] = '4041054511';
+---------+
| EXPR$0 |
+---------+
| 0 |
+---------+
1 row selected (814.104 seconds)
{code}
I attached the profile and the log file. The data set used is too large to attach here.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)