Issue with using nohup on sqlline - DRILL
Problem:
Following is a normal way of query execution in DRILL:
[mapr@vm52-146 ~]$ sqlline -u "jdbc:drill:" -n <user> -p <password> --run=test.drill 1/1 show schemas; +---------------------+ | SCHEMA_NAME | +---------------------+ | INFORMATION_SCHEMA | | cp.default | | dfs.default | | dfs.root | | dfs.tmp | | sys | +---------------------+ 6 rows selected (1.773 seconds) Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl apache drill 1.10.0 "a drill is a terrible thing to waste"
Or, the same can be executed as a script:
[mapr@vm52-146 ~]$ nano test.sh [mapr@vm52-146 ~]$ cat test.sh sqlline -u "jdbc:drill:" -n <user> -p <password> --run=test.drill > /tmp/result.txt [mapr@vm52-146 ~]$ chmod +x test.sh [mapr@vm52-146 ~]$ sh test.sh 1/1 show schemas; 6 rows selected (0.957 seconds) Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl apache drill 1.10.0 "a little sql for your nosql" [mapr@vm52-146 ~]$ cat /tmp/result.txt +---------------------+ | SCHEMA_NAME | +---------------------+ | INFORMATION_SCHEMA | | cp.default | | dfs.default | | dfs.root | | dfs.tmp | | sys | +---------------------+
However, above methods do not return result if executed with nohup.
[mapr@vm52-146 ~]$ nohup ./test.sh & [4] 24554 [mapr@vm52-146 ~]$ nohup: ignoring input and appending output to `nohup.out' [4]+ Stopped nohup ./test.sh [mapr@vm52-146 ~]$ cat /tmp/result.txt [mapr@vm52-146 ~]$
Solution:
Add “-Djline.terminal=jline.UnsupportedTerminal” property in SQLLINE_JAVA_OPTS inside drill-env.sh
No comments:
Post a Comment