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.

  • 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?

  • I used syntax from official documentation :

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

Oleg L
質問済み 5ヶ月前189ビュー
1回答
0

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

profile pictureAWS
エキスパート
回答済み 5ヶ月前

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

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

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

関連するコンテンツ