Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Combining Athena UDF with CTAS or UNLOAD statement

0

The limitations in the UDF mention that it won't work with the views. However there is no easy way to materialize the output of the UDF used SQL statement. Currently it does not seem to work with CTAS (technically a materialized view) OR even UNLOAD statement.

Is there any support planned or its a known limitation ? This is truly limiting for the customers when using different UDF connectors or their own UDFs written through lambda to materialize anything.

Topics
AnalyticsCompute
Tags
AnalyticsAWS LambdaAmazon Athena
Language
English

asked 9 months ago74 views

1 Answer
0

Hello.

As you may have already read, as stated in the documentation, you cannot use CTAS with Athena UDF.
Unfortunately, no roadmap has been announced for feature support, so it's unclear when this will be implemented.
https://docs.aws.amazon.com/athena/latest/ug/udf-considerations-limitations.html

If your AWS account has paid support, you may want to submit a feature request through support.
https://docs.aws.amazon.com/awssupport/latest/user/case-management.html

EXPERT

answered 9 months 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.

Relevant content