Hi, could someone please give me an example in using a very simple UDF . From that simple UDF I could make it a more complex one, but I just need a very simple start in returning a substring from a database field.
I have 2 problems:
-
How to define a correct UDF in my query. My query now is:
USING EXTERNAL FUNCTION test(ID VARCHAR) RETURNS VARCHAR LAMBDA 'test'
select test(ID) FROM "BibleLinkDynDB"."default"."bible_link_statistics" limit 10;
ID is the database field.
-
How to use the input from the UDF in the lambda function. Based on the lambda template my function looks like this:
index.js
exports.handler = async (event) => {
let response = substring(event.arguments,1,10);
return response;
};
I know this is not correct. I don't now how to get and process the input string because I think event is an object.
If someone could please give me a hint or a simple example, then this beginner would be very grateful.
kind regards
Reyer