Page History

// UDF Development

public static class NamedArgumentsTableFunction extends TableFunction<Object> {

    // Method overloads with different parameter sets

    // Example usage: SELECT * FROM TABLE(my_table_function(in1 => 'value1', in2 => 'value2'))
    @FunctionHint(
           input = {@DataTypeHint("STRING"), @DataTypeHint("STRING NOT NULL")},
           output = @DataTypeHint("STRING"),
           arguments = {
                @ArgumentHint(name = "in1"),
                @ArgumentHint(name = "in2")
            })
    public void eval(String arg1, String arg2) {
       collect(arg1 + ", " + arg2);
    }


     // Example usage: SELECT * FROM TABLE(my_table_function(in1 => 'value1', in2 => 'value2', in3 => 'value3'))
     @FunctionHint(
           input = {@DataTypeHint("STRING"), @DataTypeHint("STRING NOT NULL")},
           output = @DataTypeHint("STRING"),
           arguments = {
                @ArgumentHint(name = "in1"),
                @ArgumentHint(name = "in2"),
				@ArgumentHint(name = "in3")
            })
    public void eval(String arg1, String arg2, String arg3) {
       collect(arg1 + ", " + arg2 + "," + arg3);
    } 
}  



// Call Procedure Development

public static class NamedArgumentsProcedure implements Procedure {




   // Method overloads with different parameter sets

   // Example usage: CALL myNamedProcedure(in1 => 'value1', d => 100)

   @ProcedureHint(
           input = {@DataTypeHint("STRING"), @DataTypeHint("INT")},=
           output = @DataTypeHint("STRING"),              
           arguments = {
                @ArgumentHint(name = "in1"),
                @ArgumentHint(name = "in2")
            })
       public String[] call(ProcedureContext procedureContext, String arg1, Integer arg2) {

       return new String[]{arg1 + ", " + arg2};

   }


   // Example usage: CALL myNamedProcedure(in1 => 100, in2 => 200)

   @ProcedureHint(
           input = {@DataTypeHint("INT"), @DataTypeHint("INT")},
           output = @DataTypeHint("STRING"),              
           arguments = {
                @ArgumentHint(name = "in1"),
                @ArgumentHint(name = "in2")})
       public String[] call(ProcedureContext procedureContext, Integer arg1, Integer arg2, Integer arg3) {
       return new String[]{arg1 + ", " + arg2};
   }

}

// UDF Development

public static class NamedArgumentsTableFunction extends TableFunction<Object> {

   // Example usage: SELECT * FROM TABLE(my_table_function(in1 => 'value1', in2 => 'value2'))

   // Example usage: SELECT * FROM TABLE(my_table_function(in1 => 'value1', in2 => 'value2', in3 => 'value3'))

   @FunctionHint(

           input = {@DataTypeHint("STRING"), @DataTypeHint(value = "STRING"), @DataTypeHint(value = "STRING")},
           output = @DataTypeHint("STRING"),             
           arguments = {
                @ArgumentHint(name = "in1", isOptional = true),
                @ArgumentHint(name = "in2", isOptional = true)
                @ArgumentHint(name = "in3", isOptional = true)})      
    public void eval(String arg1, String arg2, String arg3) {
       collect(arg1 + ", " + arg2 + "," + arg3);
   }

}


// Call Procedure Development

public static class NamedArgumentsProcedure implements Procedure {




   // Example usage: CALL myNamedProcedure(in1 => 'value1', in2 => 'value2')

   // Example usage: CALL myNamedProcedure(in1 => 'value1', in2 => 'value2', in3 => 'value3')

   @ProcedureHint(
           input = {@DataTypeHint(value = "STRING"), @DataTypeHint(value = "STRING"), @DataTypeHint(value = "STRING")},
           output = @DataTypeHint("STRING"),             
		   arguments = {
                @ArgumentHint(name = "in1", isOptional = false),
                @ArgumentHint(name = "in2", isOptional = true)
                @ArgumentHint(name = "in3", isOptional = true)})       
   public String[] call(ProcedureContext procedureContext, String arg1, String arg2, String arg3) {
       return new String[]{arg1 + ", " + arg2 + "," + arg3};
   }
}