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