Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6985

Fix sqlline.bat issues on Windows and add drill-embedded.bat

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.15.0
    • Fix Version/s: 1.16.0
    • Component/s: None
    • Environment:

      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

            Activity

              People

              • Assignee:
                volodymyr Vova Vysotskyi
                Reporter:
                volodymyr Vova Vysotskyi
                Reviewer:
                Arina Ielchiieva
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: