[jira] [Commented] (DRILL-5700) nohup support for sqlline

["Kunal Khatua (JIRA)" <ji...@apache.org>]

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

Kunal Khatua commented on DRILL-5700:
-------------------------------------

[~arjun_kr] can you open a PR for this?

> nohup support for sqlline 
> --------------------------
>
>                 Key: DRILL-5700
>                 URL: https://issues.apache.org/jira/browse/DRILL-5700
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Client - CLI
>            Reporter: Arjun
>            Priority: Minor
>
> Sqlline script does support nohup mode for execution. On execution, it remains stopped until it is made fore ground.
> {code:java}
> [mapr@node1 ~]$ cat test.sql
> select * from sys.drillbits
> [mapr@node1 ~]$
> [mapr@node1 ~]$ nohup sqlline -u "jdbc:drill:" -n mapr -p mapr -f test.sql  &
> [1] 24019
> [mapr@node1 ~]$ nohup: ignoring input and appending output to `nohup.out'
> [1]+  Stopped                 nohup sqlline -u "jdbc:drill:zk=node1:5181" -n mapr -p mapr -f test.sql
> [mapr@node1 ~]$
> [mapr@node1 ~]$ fg
> nohup sqlline -u "jdbc:drill:zk=node1:5181" -n mapr -p mapr -f test.sql
> [mapr@node1 ~]$
> [mapr@node1 ~]$ cat nohup.out
> 0: jdbc:drill:zk=node1:5181> Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl
> output of ps: S
> 1/1          select * from sys.drillbits;
> +------------------+------------+---------------+------------+----------+----------+
> |     hostname     | user_port  | control_port  | data_port  | current  | version  |
> +------------------+------------+---------------+------------+----------+----------+
> | node1  | 31010      | 31011         | 31012      | true     | 1.10.0   |
> +------------------+------------+---------------+------------+----------+----------+
> 1 row selected (0.354 seconds)
> Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl
> apache drill 1.10.0
> "drill baby drill"
> [mapr@node1 ~]$
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)