Can I use select query in aws redshift python udf function

Question

How I can execute a select query in AWS Redshift UDF using plpythonu like oracle function with select into class in function like below.

CREATE OR REPLACE FUNCTION udf(id varchar(50))
RETURNS VARCHAR(50) 
STABLE
AS $$
   result = plpy.execute("SELECT count(*) FROM abc")
   return result
$$ LANGUAGE plpythonu;

when I run above function i got following error.

ERROR: XX000: NameError: global name 'plpy' is not defined. Please look at svl_udf_log for more information

Tran Tuyen · Accepted Answer · 2016-07-19 08:33:48Z

1

It's available on Postgresql (https://www.postgresql.org/docs/9.2/static/plpython-database.html).

At present, Amazon Redshift is not supported.

Same question like yours on this url: https://blogs.aws.amazon.com/bigdata/post/Tx1IHV1G67CY53T/Introduction-to-Python-UDFs-in-Amazon-Redshift

python aws amazon-redshift

edited Jul 19, 2016 at 8:33

answered Jul 19, 2016 at 8:07

Tran Tuyen

394 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Karl Gjertsen Over a year ago

Welcome to SO. It is better to place a full answer here instead of links. If the link stops working, the answer is lost.

Tran Tuyen Over a year ago

Thanks for your comment

Collectives™ on Stack Overflow

Can I use select query in aws redshift python udf function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related