drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5227) Wrong time reported in the query profile for the external sort
Date Fri, 27 Jan 2017 03:58:25 GMT
Rahul Challapalli created DRILL-5227:
----------------------------------------

             Summary: Wrong time reported in the query profile for the external sort
                 Key: DRILL-5227
                 URL: https://issues.apache.org/jira/browse/DRILL-5227
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Relational Operators, Web Server
    Affects Versions: 1.10.0
            Reporter: Rahul Challapalli


git.commit.id.abbrev=2af709f

Data Set :
{code}
Size : ~18 GB
No Of Columns : 1
Column Width : 256 bytes
{code}

The below query took ~ 127 minutes. However the profile indicated that the External Sort itself
took 17h27m. Something is wrong.

{code}
alter session set `planner.width.max_per_node` = 1;
alter session set `planner.disable_exchanges` = true;
alter session set `planner.memory.max_query_memory_per_node` = 14106127360;
select * from (select * from dfs.`/drill/testdata/resource-manager/250wide.tbl` order by columns[0])d
where d.columns[0] = 'ljdfhwuehnoiueyf'
{code}

I attached the query profile. The data set and the logs are too large to attach to a jira



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

Mime
View raw message