Developing a Simple Function

The section presents a brief overview of developing a simple function. The tutorial in the next section covers how to create a simple function in more depth.

To develop a simple function, you need to create a class within a Java package that implements Drill’s simple interface into the program, and include the required information for the function type. Your function must use data types that Drill supports. Keep the following requirements in mind:

  • Annotate all data that a UDF uses.
  • Fully qualify class references.

Complete the following steps to develop a simple function using Drill’s simple function interface:

  1. Create a Maven project and add the following dependency:

  2. Create a class that implements the DrillSimpleFunc interface and identify the scope as FunctionScope.SIMPLE.


    @FunctionTemplate(name = "myaddints", scope = FunctionScope.SIMPLE, nulls = NullHandling.NULL_IF_NULL)
      public static class IntIntAdd implements DrillSimpleFunc {
  3. Provide the variables used in the code in the Param and Output bit holders.


    @Param IntHolder in1;
    @Param IntHolder in2;
    @Output IntHolder out;
  4. Add the code that performs operations for the function in the eval() method.


    public void setup() {
    public void eval() {
      out.value = in1.value + in2.value;
  5. Use the maven-source-plugin to compile the sources and classes JAR files. Verify that an empty drill-module.conf is included in the resources folder.
    Drill searches this module during classpath scanning. If the file is not included in the resources folder, you can add it to the JAR file or add it to etc/drill/conf.