Hi Charles,
1. drill-module.conf: should be the following:
*drill.classpath.scanning.packages
+= "org.apache.drill.contrib.function"*
2. when I have built the jars and tried to register functions, I got the
following error: org.apache.drill.common.exceptions.DrillRuntimeException:
Unexpected class load failure while attempting to load Function Registry
(com.maxmind.geoip2.DatabaseReader), so I have copied two jars into
<drill>/jars
folder: maxmind-db-1.2.1.jar and geoip2-2.8.0.jar and function seems to
work fine (well, could not read DB but it's expected since you have
hard-coded your local path in your function code: java.io.File database =
new
java.io.File("/Users/cgivre/OneDrive/github/drillworkshop/GeoLite2/GeoLite2-City.mmdb");).
I guess these jars should be present in drill classpath at startup despite
the the way you register functions (dynamic or not).
0: jdbc:drill:zk=local> create function using jar
'drill-geoip-functions-1.0.jar';
+----+---------+
| ok | summary |
+----+---------+
| true | The following UDFs in jar drill-geoip-functions-1.0.jar have been
registered:
[getcountryname(VARCHAR-OPTIONAL), getcityname(VARCHAR-REQUIRED)] |
+----+---------+
1 row selected (1.083 seconds)
0: jdbc:drill:zk=local> select getCityName('A') from sys.version;
IOException encountered: Could not read MaxMind DBIOException encountered:
Could not read MaxMind DB+----------+
| EXPR$0 |
+----------+
| Unknown |
+----------+
Kind regards
Arina
On Sun, Jan 29, 2017 at 2:41 AM, Charles Givre <[email protected]> wrote:
> HI Arina,
> I’m still getting weird errors.
>
> Here’s my UDF: https://github.com/cgivre/drill-geoip-functions <
> https://github.com/cgivre/drill-geoip-functions>
>
> I build it using: mvn clean package -DskipTests and it builds fine. I
> copy the .jar files it creates to <drill>/jars/3rdparty, but when I try to
> execute a query, I get:
>
> Query Failed: An Error Occurred
> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR:
> From line 1, column 19 to line 1, column 42: No match found for function
> signature getCityName() SQL Query null [Error Id:
> deb83448-db82-4351-b95d-f183c25efb0b
> on charless-mbp-2.fios-router.home:31010]
>
> Would you mind taking a quick look at my code? I have a feeling this is
> something simple and obvious, like a wrong path somewhere. I’ve written
> other UDFs before and gotten them to work, so I’m a little stuck.
> Thanks,
> — Charles
>
>
>
> > On Jan 28, 2017, at 08:22, Arina Yelchiyeva <[email protected]>
> wrote:
> >
> > Hi Charles,
> >
> > drill-module.conf file should be placed in src/main/resources folder.
> > Example:
> > https://github.com/arina-ielchiieva/drillUDF/blob/
> master/src/main/resources/drill-module.conf
> >
> >
> > Kind regards
> > Arina
> >
> > On Fri, Jan 27, 2017 at 10:50 PM, Charles Givre <[email protected]>
> wrote:
> >
> >> I’m having some trouble registering a UDF I wrote. The UDF was working
> in
> >> previous versions of Drill and now Drill doesn’t seem to recognize it.
> >> When I try to register it I get the following error:
> >>
> >> : jdbc:drill:zk=local> create function using jar
> >> 'drill-geoip-functions-1.0.jar';
> >> +--------+--------------------------------------------------
> -------------+
> >> | ok | summary
> |
> >> +--------+--------------------------------------------------
> -------------+
> >> | false | Jar drill-geoip-functions-1.0.jar does not contain
> functions |
> >> +--------+--------------------------------------------------
> -------------+
> >>
> >> I do have a drill-module.conf file and here are the contents:
> >> drill.classpath.scanning.packages += "org.apache.drill.contrib.
> function"
> >> I tried moving this file around and I put a copy in the /src folder as
> >> well as the /src/main folder to no avail. Any suggestions?
> >> Thanks,
> >> — Charles
> >>
> >>
> >>
> >>
> >>
> >>
>
>
