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

질문됨 2년 전104회 조회
답변 없음

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

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

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

관련 콘텐츠