[DRILL-2070] 0.7 Embedded Mode on Windows

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.7.0
• Component/s: Documentation

Environment

Windows 8.1 x64 VM, 6GB RAM, 40GB HD, JDK 1.7.0_71

• Assignee: Kris Hahn
• Reporter: Brandon Newell
• Created: 26/Jan/15 18:21
• Updated: 12/Feb/16 18:31
• Resolved: 18/May/15 21:43

Description

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",

1. The following section is used by ZkPStoreProvider
   zk: { blobroot: "file:///var/log/drill" }

   ,

2. 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:

   Unknown macro: { batch.size }

   },
   }

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