Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.15.0
-
None
-
Windows 10
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/
Other issues covered in this Jira:
sqlline.bat fails for the next cases:
1. Specified file in the argument:
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
2. Specified file path that contains spaces:
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.
3. Specified query in the argument:
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.
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.
4. Specified custom config location:
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
5. Specified custom config location with spaces in the path:
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.
6. Sqlline was run from non-bin directory:
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
Attachments
Issue Links
- contains
-
DRILL-6972 Error: Could not find or load main class sqlline.SqlLine
-
- Resolved
-
- links to