[ https://issues.apache.org/jira/browse/DRILL-6985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bridget Bevens updated DRILL-6985: ---------------------------------- Labels: doc-complete ready-to-commit (was: doc-impacting ready-to-commit) > Fix sqlline.bat issues on Windows and add drill-embedded.bat > ------------------------------------------------------------ > > Key: DRILL-6985 > URL: https://issues.apache.org/jira/browse/DRILL-6985 > Project: Apache Drill > Issue Type: Improvement > Affects Versions: 1.15.0 > Environment: Windows 10 > Reporter: Volodymyr Vysotskyi > Assignee: Volodymyr Vysotskyi > Priority: Major > Labels: doc-complete, 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/ > Other issues covered in this Jira: > {{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)