Cannot Update Glue Partition Names Populating table overwrites Partition names

1

I have a database that I have been working with and I am trying to add a new table through Glue.

I have been able to create the table and populate data, but I cannot update the partition names in the table and are stuck with partition_0.

You should be able to edit the table by using the actions button, but when I click "edit table" nothing happens in this or any other table that I have previously setup.

Things I have tried:

  1. edit the table in the glue console
  2. manually update the partition name ALTER TABLE missing_trips partition (partition_0) RENAME TO PARTITION (agency) produces an unknown error
  3. Create the table with Athena and then populate. I am able to create the table, and then populate that table with a crawler, but when I do so it reverts the partition name to partition_0

#2 error: [ErrorCategory:USER_ERROR, ErrorCode:UNKNOWN_ERROR] Query Id: 61c7b446-16c7-4459-94fd-f097dc15835a

preguntada hace 2 años104 visualizaciones
No hay respuestas

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