[
https://issues.apache.org/jira/browse/DRILL-6985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-6985:
------------------------------------
Description:
*For documentation*
{{drill-embedded.bat}} was added as handy script to Start Drill on Windows
without passing any params.
Please updated the following section:
https://drill.apache.org/docs/starting-drill-on-windows/
{{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}
was:
{{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}
> 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
> Priority: Major
> Labels: doc-impacting, ready-to-commit
> Fix For: 1.16.0
>
>
> *For documentation*
> {{drill-embedded.bat}} was added as handy script to Start Drill on Windows
> without passing any params.
> Please updated the following section:
> https://drill.apache.org/docs/starting-drill-on-windows/
> {{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)
