[
https://issues.apache.org/jira/browse/DRILL-5101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15938880#comment-15938880
]
Gopi Kumar commented on DRILL-5101:
-----------------------------------
Here is a (somewhat hacky) workaround to run on Drill 1.9 or 1.10 embedded on
Windows 2012 or 2016 if you are an admin account and facing this error. Run
these commands before the first time you are running sqlline.bat.
mkdir %userprofile%\drill
mkdir %userprofile%\drill\udf
mkdir %userprofile%\drill\udf\registry
mkdir %userprofile%\drill\udf\tmp
mkdir %userprofile%\drill\udf\staging
takeown /R /F %userprofile%\drill
Basically, precreate the udf directories and recursively reset file and folder
owner to yourself instead of builtin\Administrators. (Note: I did not test any
UDF features in Drill itself after this. Just trying to use the standard
querying functionality).
> Provide boot-time option to disable the Dynamic UDF feature
> -----------------------------------------------------------
>
> Key: DRILL-5101
> URL: https://issues.apache.org/jira/browse/DRILL-5101
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.9.0
> Reporter: Paul Rogers
> Assignee: Arina Ielchiieva
> Priority: Minor
>
> A Windows user on the mailing list could not start an embedded Drillbit
> because the Dynamic UDF feature tried to create a directory on the user's
> protected Users folder:
> {code}
> Error: Failure in starting embedded Drillbit:
> org.apache.drill.common.exceptions
> .DrillRuntimeException: Error during udf area creation
> [/C:/Users/ivy.chan/drill
> /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/ivy.chan/drill/udf/registry] on file system [file:///]
> at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
> Impl.java:128)
> at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
> lJdbc41Factory.java:70)
> at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
> va:69)
> {code}
> The fastest workaround (since this was an embedded Drillbit) would be to
> disable the Dynamic UDF feature. Unfortunately, the only option to do so is a
> runtime option that requires that the Drillbit be started. That creates a
> vicious circle: we can't start the Drillbit unless we disable Dynamic UDFs,
> but we can't disable them unless we start the Drillbit.
> The workaround might be to change the root directory, which is why this bug
> is marked minor.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
