drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "tmx (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2070) 0.7 Embedded Mode on Windows
Date Fri, 12 Feb 2016 18:32:18 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15145015#comment-15145015
] 

tmx commented on DRILL-2070:
----------------------------

the above description is formatted poorly for JIRA:

>From original
{code}
drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "localhost:2181",
  tmp: {
    directories: ["c:/drill/tmp/drill"],
    filesystem: "drill-local:///"
  }
  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/drill",
      write: true
    }
  }
}
{code}

> 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)

Mime
View raw message