This shows an example a customer function using Dremio's internal APIs. The example has the signature example_concat_op(, <varchar) and returns a new varchar. It can be used by copying the built jar file into the Dremio jars directory.
Example Usage:
SELECT example_concat_op(name, kind) FROM sys.options