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
質問済み 2年前1842ビュー
2回答
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
エキスパート
回答済み 2年前
0

Thanks Fabrizio, I will study it.

Reyer
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ