Help in creating the most simple Athena UDF

0

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:

  1. 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.

  2. 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

Reyer
asked 2 years ago1812 views
2 Answers
0

Have you looked at this workshop lab on using Athena UDF?

It shows you how to deploy an Athena UDF handler with the Serverless Application Repository and then add a function to it.

AWS
EXPERT
answered 2 years ago
0

Thanks Fabrizio, I will study it.

Reyer
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions