Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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 EXPERTO
    hace 5 meses

    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
    hace 5 meses

    I used syntax from official documentation :

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

Temas
Análisis
Etiquetas
Amazon Redshift
Idioma
English
Oleg L
preguntada hace 5 meses190 visualizaciones
1 Respuesta
0

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

profile pictureAWS
EXPERTO
Jon Roberts
respondido hace 5 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante