Hi Jim, I'm still not able to make this work. Do you have a sample .jar file with a small example that you are running?
Regards, -Stefan On Sun, Jul 19, 2015 at 6:46 PM, Ted Dunning <[email protected]> wrote: > > Sounds like a fine example, not because of sophistication but because it > deals with dates. > > Check the drill logs. It is likely that drill is grumpy about something > in your udf or packaging. > > Also, feel free to snitch the pom from the simple examples in order to get > the pieces assembled and packaged correctly. > > Sent from my iPhone > > > On Jul 19, 2015, at 11:25, Stefán Baxter <[email protected]> > wrote: > > > > Hi Jim, > > > > My UDF is currently so simple that I'm not sure you need it (or want it). > > > > It basically just rounds a timestamp value with ISO 8601 periods > > asRoundTimestamp(timestampvalue,'PT10M'). > > > > I would be more than happy to contribute to your project rather than > > building our own :). > > > > Is the repo public? > > > > Regards, > > -Stefan > > > > > > > >> On Sun, Jul 19, 2015 at 6:18 PM, Jim Bates <[email protected]> wrote: > >> > >> Maven will typically create a jar for class and a jar for source when > told > >> to do so. I just include the source files in the same jar as the class > >> files. There is a github example drill udf project we are working on to > >> include several examples to simplify the learning curve. If your > >> interested... I'd love to have you add your udf. > >> On Jul 19, 2015 12:59 PM, "Stefán Baxter" <[email protected]> > >> wrote: > >> > >>> Hi again, > >>> > >>> Going over the documentation once more I came across this: > >>> > >>> - Add the sources and classes JAR files to Drill’s classpath. > >>> > >>> I'm only including a standard .jar (with classes no sources) and I > wonder > >>> why this dependency is listed. > >>> > >>> Anyways, that it the next step. > >>> > >>> A sample .jar that works with the drill-config counterpart would be a > >>> welcome addition to the documentation. > >>> > >>> Regards, > >>> -Stefan > >>> > >>> > >>> On Sun, Jul 19, 2015 at 5:53 PM, Stefán Baxter < > >> [email protected]> > >>> wrote: > >>> > >>>> Hi Jim, > >>>> > >>>> Now I have added the file to the jar (both root and resources folder) > >> but > >>>> that does not seem to change anything. > >>>> > >>>> Any additional ideas? > >>>> > >>>> Regards, > >>>> -Stefan > >>>> > >>>> On Sun, Jul 19, 2015 at 5:40 PM, Stefán Baxter < > >>> [email protected]> > >>>> wrote: > >>>> > >>>>> NO! > >>>>> > >>>>> Thank you , will do that right now :) > >>>>> > >>>>> On Sun, Jul 19, 2015 at 5:38 PM, Jim Bates <[email protected]> > >> wrote: > >>>>> > >>>>>> Did you include a file drill-module.conf in your jar along with > >> source > >>>>>> files? > >>>>>> On Jul 19, 2015 12:20 PM, "Stefán Baxter" < > [email protected] > >>> > >>>>>> wrote: > >>>>>> > >>>>>>> Hi, > >>>>>>> > >>>>>>> I'm trying to deploy a UDF that I have written according to the > >>>>>>> documentation. > >>>>>>> > >>>>>>> I have also: > >>>>>>> > >>>>>>> 1. Copied the jar file > >>>>>>> to jars/3rdparty > >>>>>>> > >>>>>>> 2. Changed the config "conf/drill-override.conf" to include: > >>>>>>> drill.logical.function.package += > >> ["org.apache.drill.exec.expr.fn.impl","com.activitystream.drill.udfs"] > >>>>>>> > >>>>>>> 3. Rerun the Drillbit > >>>>>>> bin/drillbit.sh start > >>>>>>> > >>>>>>> The log shows no sign of the the UDF being loaded but if I use it > >> in > >>> a > >>>>>> SQL > >>>>>>> statement then this error is thrown: > >>>>>>> > >>>>>>> Error: PARSE ERROR: From line 1, column 184 to line 1, column 219: > >> No > >>>>>> match > >>>>>>> found for function signature asRoundTimeStamp(<ANY>, <CHARACTER>) > >>>>>>> > >>>>>>> > >>>>>>> The relevant part of the UDF source: > >>>>>>> > >>>>>>> package com.activitystream.drill.udfs; > >>>>>>> > >>>>>>> public class ASUserDefinedFunctions { > >>>>>>> > >>>>>>> @FunctionTemplate(name = "asRoundTimeStamp", scope = > >>>>>>> FunctionTemplate.FunctionScope.SIMPLE, nulls = > >>>>>>> FunctionTemplate.NullHandling.NULL_IF_NULL) > >>>>>>> > >>>>>>> public static class RoundTimeStamp implements DrillSimpleFunc > >>>>>>> > >>>>>>> > >>>>>>> Can anyone please assist? > >>>>>>> > >>>>>>> Regards, > >>>>>>> -Stefan > >> >
