Volodymyr Vysotskyi created DRILL-6985:
------------------------------------------
Summary: Fix sqlline.bat issues on Windows
Key: DRILL-6985
URL: https://issues.apache.org/jira/browse/DRILL-6985
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.15.0
Environment: Windows 10
Reporter: Volodymyr Vysotskyi
Assignee: Volodymyr Vysotskyi
Fix For: 1.16.0
{{sqlline.bat}} fails for the next cases:
1. Specified file in the argument:
{noformat}
apache-drill-1.15.0\bin>sqlline.bat -u "jdbc:drill:zk=local" -f /tmp/q.sql
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Error: Could not find or load main class sqlline.SqlLine
{noformat}
2. Specified file path that contains spaces:
{noformat}
apache-drill-1.15.0\bin>sqlline.bat -u "jdbc:drill:zk=local" -f "/tmp/q q.sql"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
q.sql""=="test" was unexpected at this time.
{noformat}
3. Specified query in the argument:
{noformat}
apache-drill-1.15.0\bin>sqlline.bat -u "jdbc:drill:zk=local" -e "select * from
sys.version"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
* was unexpected at this time.
{noformat}
{noformat}
apache-drill-1.15.0\bin>sqlline.bat -u "jdbc:drill:zk=local" -q "select 'a'
from sys.version"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
'a' was unexpected at this time.
{noformat}
4. Specified custom config location:
{noformat}
apache-drill-1.15.0\bin>sqlline.bat -u "jdbc:drill:zk=local" --config=/tmp/conf
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Error: Could not find or load main class sqlline.SqlLine
{noformat}
5. Specified custom config location with spaces in the path:
{noformat}
apache-drill-1.15.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
--config="/tmp/conf test"
DRILL_ARGS - " -u jdbc:drill:zk=local"
test"" was unexpected at this time.
{noformat}
6. Sqlline was run from non-bin directory:
{noformat}
apache-drill-1.15.0>bin\sqlline.bat -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Error: Could not find or load main class sqlline.SqlLine
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
