[jira] [Created] (DRILL-2070) 0.7 Embedded Mode on Windows

["Brandon Newell (JIRA)" <ji...@apache.org>]

Brandon Newell created DRILL-2070:
-------------------------------------

             Summary: 0.7 Embedded Mode on Windows
                 Key: DRILL-2070
                 URL: https://issues.apache.org/jira/browse/DRILL-2070
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - CLI, Client - JDBC, Documentation
    Affects Versions: 0.7.0
         Environment: Windows 8.1 x64 VM, 6GB RAM, 40GB HD, JDK 1.7.0_71
            Reporter: Brandon Newell
            Assignee: Jacques Nadeau
             Fix For: 0.7.0


Can't launch Drill due to it being unable to start the Drillbit in embedded mode.

I've verified this on my Windows 8.1 x64 VM.  Tried inline command as well as !connect from sqlline shell.

C:\Users\admin>echo %JAVA_HOME%
C:\Program Files\Java\jdk1.7.0_71
c:\drill\bin>sqlline.bat -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
Calculating HADOOP_CLASSPATH ...
HBASE_HOME not detected...
Calculating Drill classpath...
Error: Failure while attempting to start Drillbit in embedded mode. (state=,code=0)
sqlline version 1.1.6
0: jdbc:drill:zk=local> show databases;
No current connection
0: jdbc:drill:zk=local> !connect jdbc:drill:zk=local
Enter username for jdbc:drill:zk=local: admin
Enter password for jdbc:drill:zk=local: *****
Error: Failure while attempting to start Drillbit in embedded mode. (state=,code=0)
1: jdbc:drill:zk=local>

I updated my drill-override.conf with the following and am able to perform all operations.

drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "localhost:2181",
    sys.store.provider: {
    class: "org.apache.drill.exec.store.sys.zk.ZkPStoreProvider",
    # The following section is used by ZkPStoreProvider
    zk: {
      blobroot: "file:///var/log/drill"
    },
    # The following section is only required by LocalPStoreProvider
    local: {
      path: "C:\\drill\\tmp",
      write: true
    }
  }
  trace: {
    directory: "C:\\drill\\tmp\\drill-trace",
    filesystem: "file:///"
  },
  tmp: {
    directories: ["C:\\drill\\tmp"],
    filesystem: "drill-local:///"
  },
  sort: {
    purge.threshold : 100,
    external: {
      batch.size : 4000,
      spill: {
        batch.size : 4000,
        group.size : 100,
        threshold : 200,
        directories : [ "C:\\drill\\tmp\\spill" ],
        fs : "file:///"
      }
    }
  },
}

This fix was recommended here:  https://issues.apache.org/jira/browse/DRILL-1907

Also, to execute the sqlline.bat on windows you must put quotes around the arguments, otherwise errors.  Please update docs:

c:\drill\bin>sqlline.bat -u "jdbc:drill:zk=local"

https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+on+Windows




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)