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

["Kristine Hahn (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2070?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristine Hahn resolved DRILL-2070.
----------------------------------
    Resolution: Fixed

Docs revised and on the staging site for release soon: http://tshiran.github.io/drill/docs/drill-in-10-minutes/

> 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: Kristine Hahn
>             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)