Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5700

nohup support for sqlline

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 1.14.0
    • Client - CLI

    Description

      Sqlline script does support nohup mode for execution. On execution, it remains stopped until it is made fore ground.

      [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 ~]$
      

      Attachments

        Issue Links

          Activity

            People

              arjun_kr Arjun
              arjun_kr Arjun
              Timothy Farkas Timothy Farkas
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: