HIVE_WRITER_CLOSE_ERROR when running Amazon Clean Rooms Workshop

0

When running the Workshop for Clean Rooms, In Step 2 using Athena Query Editor there is a step to insert data into SocialCo Data, when doing that I get the following error. HIVE_WRITER_CLOSE_ERROR: Error committing write to Hive. If a data manifest file was generated at 's3://aws-clean-rooms-workshop-594178365182/Unsaved/2023/10/03/4d8debf5-414c-486d-b778-5b29f6498bf9-manifest.csv', you may need to manually clean the data from locations specified in the manifest. Athena will not delete data in your account. This query ran against the "unicorn_rentals_database" database, unless qualified by the query. Query Id: 4d8debf5-414c-486d-b778-5b29f6498bf9

AWS
asked 7 months ago198 views
1 Answer
0
Accepted Answer

I was able to fix the error. For the second table creation I missed replacing the S3 bucket name with the actual bucket name that was created.

AWS
answered 7 months ago
profile pictureAWS
EXPERT
reviewed 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions