Please check the below link [1], it might the permission problem. [1] https://stackoverflow.com/questions/44154856/error-starting-apache-drill-in-embedded-mode-on-windows-10
Kind regards Arina On Wed, Dec 20, 2017 at 9:22 AM, Kiranmai Dandaboin <[email protected]> wrote: > > Hi Team, > > I am facing the following issue while trying to install 1.11.0 version in > my local, Can you please help me on this..And also i want to know how i can > integrate this with other tools. > > Appreciate the promt response. > > > C:\Users\IBM_ADMIN>cd ../../ICEDQ/apache-drill-1.11.0 > > C:\ICEDQ\apache-drill-1.11.0>cd bin > > C:\ICEDQ\apache-drill-1.11.0\bin>sqlline.bat -u "jdbc:drill:zk=local" > DRILL_ARGS - " -u jdbc:drill:zk=local" > HADOOP_HOME not detected... > HBASE_HOME not detected... > Calculating Drill classpath... > Error: Failure in starting embedded Drillbit: > org.apache.drill.common.exceptions > .DrillRuntimeException: Error during udf area creation > [/C:/Users/IBM_ADMIN/dril > l/udf/registry] on file system [file:///] (state=,code=0) > java.sql.SQLException: Failure in starting embedded Drillbit: > org.apache.drill.c > ommon.exceptions.DrillRuntimeException: Error during udf area creation > [/C:/User > s/IBM_ADMIN/drill/udf/registry] on file system [file:///] > at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init> > (DrillConnection > Impl.java:132) > at org.apache.drill.jdbc.impl.DrillJdbc41Factory. > newDrillConnection > (Dril > lJdbc41Factory.java:72) > at org.apache.drill.jdbc.impl.DrillFactory.newConnection > (DrillFactory.ja > va:69) > at org.apache.calcite.avatica.UnregisteredDriver.connect > (UnregisteredDri > ver.java:143) > at org.apache.drill.jdbc.Driver.connect(Driver.java:72) > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167) > at sqlline.DatabaseConnection.getConnection > (DatabaseConnection.java:213) > > at sqlline.Commands.connect(Commands.java:1083) > at sqlline.Commands.connect(Commands.java:1015) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke > (NativeMethodAccessorImpl. > java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke > (DelegatingMethodAcces > sorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at sqlline.ReflectiveCommandHandler.execute > (ReflectiveCommandHandler.jav > a:36) > at sqlline.SqlLine.dispatch(SqlLine.java:742) > at sqlline.SqlLine.initArgs(SqlLine.java:528) > at sqlline.SqlLine.begin(SqlLine.java:596) > at sqlline.SqlLine.start(SqlLine.java:375) > at sqlline.SqlLine.main(SqlLine.java:268) > Caused by: org.apache.drill.common.exceptions.DrillRuntimeException: Error > durin > g udf area creation [/C:/Users/IBM_ADMIN/drill/udf/registry] on file > system > [fil > e:///] > at org.apache.drill.common.exceptions.DrillRuntimeException.format > (Drill > RuntimeException.java:49) > at > org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.createA > rea(RemoteFunctionRegistry.java:269) > at > org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.prepare > Areas(RemoteFunctionRegistry.java:226) > at > org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.init(Re > moteFunctionRegistry.java:105) > at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:138) > at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init> > (DrillConnection > Impl.java:123) > ... 18 more > Caused by: java.lang.IllegalStateException: Area > [/C:/Users/IBM_ADMIN/drill/udf/ > registry] must be writable and executable for application user > at com.google.common.base.Preconditions.checkState > (Preconditions.java:19 > 7) > at > org.apache.drill.exec.expr.fn.registry.RemoteFunctionRegistry.createA > rea(RemoteFunctionRegistry.java:255) > ... 22 more > apache drill 1.11.0 > "what ever the mind of man can conceive and believe, drill can query" > > Thanks, > D.Kiranmai. >
