[ https://issues.apache.org/jira/browse/DRILL-2070?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra reassigned DRILL-2070: ------------------------------------ Assignee: Bridget Bevens (was: Jacques Nadeau) Hi Bridget can you add the workarounds mentioned here to the doc for Drill on Windows. > 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: 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: Bridget Bevens > 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)