[
https://issues.apache.org/jira/browse/DRILL-7401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-7401:
------------------------------------
Description:
Upgrade to SqlLine 1.9 once it is released
(https://github.com/julianhyde/sqlline/issues/350).
*TODO:*
1. Add SqlLine properties:
{{connectInteractionMode: useNPTogetherOrEmpty}} - supports connection mehanism
used in SqlLine 1.17 and earlier:
a. if user and password are not indicated, connects without them (user and
password are set t empty string): {{./drill-embedded}}
b. if user is indicated, asks for password in interactive mode:
{{./drill-embedded -n "user1"}}
c. if user is indicated as empty string, behaives like in point a (user and
password are set t empty string): {{./drill-embedded -n ""}}
d. if user and password are indicated, connects using provided input
{{./drill-embedded -n "user1" -p ''123"}}
{{showLineNumbers: true}} - adds line numbers when query is more than one line:
{noformat}
apache drill> select
2..semicolon> *
3..semicolon> from
4..semicolon> sys.version;
{noformat}
2. Remove nohup support code from sqlline.sh since it is not needed any more
(nohup support wroks without flag):
{code}
To add nohup support for SQLline script
if [[ ( ! $(ps -o stat= -p $$) =~ "+" ) && ! ( -p /dev/stdin ) ]]; then
export SQLLINE_JAVA_OPTS="$SQLLINE_JAVA_OPTS
-Djline.terminal=jline.UnsupportedTerminal"
fi
{code}
3. Add {{-Dorg.jline.terminal.dumb=true}} to avoid JLine terminal warning when
submitting query in sqlline.sh to execute via {{-e}} or {{-f}}:
{noformat}
Oct 11, 2019 2:14:45 PM org.jline.utils.Log logr
WARNING: Unable to create a system terminal, creating a dumb terminal (enable
debug logging for more information)
{noformat}
4. Remove unneeded echo commands in sqlline.bat during start up:
{noformat}
drill-embedded.bat
DRILL_ARGS - " -u jdbc:drill:zk=local -n user1 -p ppp"
Calculating HADOOP_CLASSPATH ...
HBASE_HOME not detected...
Calculating Drill classpath...
Apache Drill 1.17.0-SNAPSHOT
"Data is the new oil. Ready to Drill some?"
apache drill>
{noformat}
was:
Upgrade to SqlLine 1.9 once it is released
(https://github.com/julianhyde/sqlline/issues/350).
*TODO:*
1. Add SqlLine properties:
{{connectInteractionMode: useNPTogetherOrEmpty}} - supports connection mehanism
used in SqlLine 1.17 and earlier:
a. if user and password are not indicated, connects without them (user and
password are set t empty string): {{./drill-embedded}}
b. if user is indicated, asks for password in interactive mode:
{{./drill-embedded -n "user1"}}
c. if user is indicated as empty string, behaives like in point a (user and
password are set t empty string): {{./drill-embedded -n ""}}
d. if user and password are indicated, connects using provided input
{{./drill-embedded -n "user1 -p ''123"}}
{{showLineNumbers: true}} - adds line numbers when query is more than one line:
{noformat}
apache drill> select
2..semicolon> *
3..semicolon> from
4..semicolon> sys.version;
{noformat}
2. Remove nohup support code from sqlline.sh since it is not needed any more
(nohup support wroks without flag):
{code}
To add nohup support for SQLline script
if [[ ( ! $(ps -o stat= -p $$) =~ "+" ) && ! ( -p /dev/stdin ) ]]; then
export SQLLINE_JAVA_OPTS="$SQLLINE_JAVA_OPTS
-Djline.terminal=jline.UnsupportedTerminal"
fi
{code}
3. Add {{-Dorg.jline.terminal.dumb=true}} to avoid JLine terminal warning when
submitting query in sqlline.sh to execute via {{-e}} or {{-f}}:
{noformat}
Oct 11, 2019 2:14:45 PM org.jline.utils.Log logr
WARNING: Unable to create a system terminal, creating a dumb terminal (enable
debug logging for more information)
{noformat}
4. Remove unneeded echo commands in sqlline.bat during start up:
{noformat}
drill-embedded.bat
DRILL_ARGS - " -u jdbc:drill:zk=local -n user1 -p ppp"
Calculating HADOOP_CLASSPATH ...
HBASE_HOME not detected...
Calculating Drill classpath...
Apache Drill 1.17.0-SNAPSHOT
"Data is the new oil. Ready to Drill some?"
apache drill>
{noformat}
> Sqlline 1.9 upgrade
> -------------------
>
> Key: DRILL-7401
> URL: https://issues.apache.org/jira/browse/DRILL-7401
> Project: Apache Drill
> Issue Type: Task
> Reporter: Arina Ielchiieva
> Assignee: Arina Ielchiieva
> Priority: Major
> Fix For: 1.17.0
>
>
> Upgrade to SqlLine 1.9 once it is released
> (https://github.com/julianhyde/sqlline/issues/350).
> *TODO:*
> 1. Add SqlLine properties:
> {{connectInteractionMode: useNPTogetherOrEmpty}} - supports connection
> mehanism used in SqlLine 1.17 and earlier:
> a. if user and password are not indicated, connects without them (user and
> password are set t empty string): {{./drill-embedded}}
> b. if user is indicated, asks for password in interactive mode:
> {{./drill-embedded -n "user1"}}
> c. if user is indicated as empty string, behaives like in point a (user and
> password are set t empty string): {{./drill-embedded -n ""}}
> d. if user and password are indicated, connects using provided input
> {{./drill-embedded -n "user1" -p ''123"}}
> {{showLineNumbers: true}} - adds line numbers when query is more than one
> line:
> {noformat}
> apache drill> select
> 2..semicolon> *
> 3..semicolon> from
> 4..semicolon> sys.version;
> {noformat}
> 2. Remove nohup support code from sqlline.sh since it is not needed any more
> (nohup support wroks without flag):
> {code}
> To add nohup support for SQLline script
> if [[ ( ! $(ps -o stat= -p $$) =~ "+" ) && ! ( -p /dev/stdin ) ]]; then
> export SQLLINE_JAVA_OPTS="$SQLLINE_JAVA_OPTS
> -Djline.terminal=jline.UnsupportedTerminal"
> fi
> {code}
> 3. Add {{-Dorg.jline.terminal.dumb=true}} to avoid JLine terminal warning
> when submitting query in sqlline.sh to execute via {{-e}} or {{-f}}:
> {noformat}
> Oct 11, 2019 2:14:45 PM org.jline.utils.Log logr
> WARNING: Unable to create a system terminal, creating a dumb terminal (enable
> debug logging for more information)
> {noformat}
> 4. Remove unneeded echo commands in sqlline.bat during start up:
> {noformat}
> drill-embedded.bat
> DRILL_ARGS - " -u jdbc:drill:zk=local -n user1 -p ppp"
> Calculating HADOOP_CLASSPATH ...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Apache Drill 1.17.0-SNAPSHOT
> "Data is the new oil. Ready to Drill some?"
> apache drill>
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
