[jira] [Commented] (DRILL-1378) Using CTRL-C to cancel a query and exit SQLLINE cancels query but causes SQLLINE shell to hang

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

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

Jacques Nadeau commented on DRILL-1378:
---------------------------------------

This is blocking some use cases.  Can you please get someone to review this and make sure it always works.  It seems like we need to update the commands so that prepare is part of the callback to ensure CTRL-C is handled here: https://github.com/julianhyde/sqlline/blob/master/src/main/java/sqlline/Commands.java

> Using CTRL-C to cancel a query and exit SQLLINE cancels query but causes SQLLINE shell to hang
> ----------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1378
>                 URL: https://issues.apache.org/jira/browse/DRILL-1378
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - CLI
>    Affects Versions: 0.4.0
>         Environment: MapR v3.1.1, RHEL 6.5
>            Reporter: Michael England
>            Assignee: Parth Chandra
>            Priority: Blocker
>              Labels: cancel, ctrl-c, hang, query, sqlline
>             Fix For: 0.9.0
>
>
> When running a query (in this case a Drill query over a large Hive table), pressing CTRL+C to cancel a query and exit the shell causes a cancellation message in sqlline.log but causes the SQLLINE shell to hang. CTRL-Z then needs to be pressed and the SQLLINE process needs to be killed manually. A CTRL+C keyboard interrupt should cancel the query and provide a new empty query line in the shell. A further CTRL-C keyboard press should exit the SQLLINE shell.
> sqlline.log cancellation entry:
> 2014-09-05 14:16:13,852 [SIGINT handler] DEBUG o.a.drill.exec.client.DrillClient - Cancelling query b0b36fa7-051e-484e-bb42-f57613401834
> 2014-09-05 14:16:13,858 [Client-1] DEBUG org.apache.drill.jdbc.DrillResultSet - Result arrived QueryResultBatch [header=query_state: CANCELED
> query_id {
>   part1: -5714100739066935218
>   part2: -4953126752676210636
> }
> is_last_chunk: true
> , data=null]



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