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

Redshift LISTAGG function has stopped working

0

Listagg function in all my pipelines stopped working this morning. Pipelines were written months ago. The same error everywhere

ERROR: function LISTAGG(character varying, "unknown") does not exist Hint: No function matches the given name and argument types. You may need to add explicit type casts.

  • Jon Roberts EXPERT
    4 months ago

    Can you provide a small example of the SQL you are executing? The second parameter to the function should be the delimiter but that isn't working here. Are you concatenating two strings together for the delimiter?

  • Oleg L
    4 months ago

    I used syntax from official documentation :

    select product_id, "LISTAGG"(category, ', ') categories from {table_name} group by product_id

Topics
Analytics
Tags
Amazon Redshift
Language
English
Oleg L
asked 4 months ago174 views
1 Answer
0

I can't reproduce your error message with your provided SQL. You should open a support ticket to have this investigated.

profile pictureAWS
EXPERT
Jon Roberts
answered 4 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.

Guidelines for Answering Questions

Relevant content