drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2993) SQLLine hangs when we cancel a query in the middle of displaying results
Date Sun, 10 May 2015 21:50:59 GMT

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

Daniel Barclay (Drill) commented on DRILL-2993:

Investigation notes: 

Reproducible with large (100 MB) CVS file of 100-byte lines (10 or so columns).

Is because throttling isn't disabled when query is canceled (so throttled messages from canceled
query aren't send and apparently block server-to-client messages for later (hanging) queries).

Fix:  Disable throttling when query canceled/closed. 

Might be only partial fix--throttling one query's results shouldn't block another query's
results _if_ Drill intends to support having multiple queries in progress at the same time
(multiple Statements/ResultSets open with interspersed results access (single-threaded)).

> SQLLine hangs when we cancel a query in the middle of displaying results
> ------------------------------------------------------------------------
>                 Key: DRILL-2993
>                 URL: https://issues.apache.org/jira/browse/DRILL-2993
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>            Reporter: Rahul Challapalli
>            Assignee: Daniel Barclay (Drill)
> git.commit.id.abbrev=8c706e6
> The data set contains 1 million records. I cancelled the below query after displaying
around ~400,000 records. All subsequent queries fail
> {code}
> 0: jdbc:drill:schema=dfs_eea>select * from `mobile.json`;
> .....
> .....
> Cancel after displaying 400,000 records
> 0: jdbc:drill:schema=dfs_eea>use dfs.drillTestDir;
> ....
> This hangs indefinitely
> {code}
> Since the data is large, I did not attach it.

This message was sent by Atlassian JIRA

View raw message