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달 전190회 조회
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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠