Hi Arina,
I have also tried that but same error occurs. Please find by
drill-override.config
drill.exec: {
cluster-id: "drillbits1",
zk.connect: "localhost:2181",
udf.directory.root: "/D:/apache-drill-1.10.0/conf"
#udf.directory.root: "D:/apache-drill-1.10.0/conf",
#udf.directory.base: "D:/apache-drill-1.10.0/conf",
udf.directory.local:"udf",
#zk.root:"D:/apache-drill-1.10.0/conf"
}
The error which I got is as below
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Error: Failure in starting embedded Drillbit:
java.lang.IllegalStateException: Local udf directory
[C:\Users\mob140003207\AppData\Local\Temp;C:\Python27;\udf] must exist
(state=,code=0)
java.sql.SQLException: Failure in starting embedded Drillbit:
java.lang.IllegalStateException: Local udf directory
[C:\Users\mob140003207\AppData\Local\Temp;C:\Python27;\udf] must exist
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:131)
at
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
at
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.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(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java: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: java.lang.IllegalStateException: Local udf directory
[C:\Users\mob140003207\AppData\Local\Temp;C:\Python27;\udf] must exist
at
com.google.common.base.Preconditions.checkState(Preconditions.java:197)
at
org.apache.drill.exec.expr.fn.FunctionImplementationRegistry.getLocalUdfDir(FunctionImplementationRegistry.java:452)
at
org.apache.drill.exec.expr.fn.FunctionImplementationRegistry.<init>(FunctionImplementationRegistry.java:123)
at
org.apache.drill.exec.expr.fn.FunctionImplementationRegistry.<init>(FunctionImplementationRegistry.java:127)
at
org.apache.drill.exec.server.DrillbitContext.<init>(DrillbitContext.java:95)
at
org.apache.drill.exec.work.WorkManager.start(WorkManager.java:106)
at
org.apache.drill.exec.server.Drillbit.run(Drillbit.java:119)
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:122)
... 18 more
apache drill 1.10.0
"json ain't no thang"
0: jdbc:drill:zk=local> !quit
Thanks and Regards,
Vignesh K
On Tue, Apr 18, 2017 at 6:14 PM, Arina Yelchiyeva <
[email protected]> wrote:
> Hi Vignesh,
>
> In previous email thread David suggested to change:
> udf.directory.root: "/C:/Temp/"
> /C:/Temp/ is syntax that can be used on Windows [1].
>
> Can you please try this variant?
>
> [1] https://drill.apache.org/docs/dynamic-udfs/
>
> Kind regards
> Arina
>
>
> On Tue, Apr 18, 2017 at 3:04 PM, Vignesh Kalai <
> [email protected]> wrote:
>
> > Hi Team,
> > This is in continuation to the mail I sent yesterday I didn't know
> how
> > to reply to that. As Abhishek Girish stated I changed the udf local path
> > i.e.) udf.directory.local: "/udf"
> > But still the error occured
> >
> > * Caused by: java.lang.IllegalStateException: Local udf directory
> > [C:\Users\vignesh\AppData\Local\Temp;C:\Python27;\udf] must exist*
> >
> > The directory is writable. If feel the issue is the root directory is
> > somewhere else from the directory the apache drill bin is. I also tried
> > changing *udf.directory.root:* and *udf.directory.base:* to *C:\\apache
> > *but
> > that also did not solve the issue.
> >
> > Thanks and Regards,
> > Vignesh k
> >
>
