Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
AWS re:Postre:Post

Updating data in governed tables

0

Are governed tables insert/append only? Is it possible to update data already in the table? https://aws.amazon.com/blogs/big-data/part-3-effective-data-lakes-using-aws-lake-formation-part-3-using-acid-transactions-on-governed-tables/ has a good example of inserting data, but it doesn't look possible to define a primary key to be able to dedupilcate data if you did another insert on the same row or a way to do an update.

Thanks

  • AWS-User-5606360
    hace 2 años

    I see that for update-table-objects the etag is required "The Amazon S3 ETag of the object. Returned by GetTableObjects for validation and used to identify changes to the underlying data." so does that help with updates? What about with compaction when that s3 file doesn't exist and was compacted

Temas
AnálisisAlmacenamiento
Etiquetas
Lagos de datosAWS Lake Formation
Idioma
English
AWS-User-5606360
preguntada hace 2 años1612 visualizaciones
2 Respuestas
0

Hi,

Lake Formation Governed Tables support object level ACID transactions. Record level transactions are not currently supported.

hope this helps

AWS
EXPERTO
Fabrizio@AWS
respondido hace 2 años
0

It appears that the development team is still working on the update table method to support appends on Governed Tables. They are targeting Q1 2022 to have this feature complete. So as of now, there is no method that you can use out of the box to do an update based on the primary key.

AWS-User-1287467
respondido hace 2 años

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