# Hive ACID and transactional tables' support in Presto

DevFeed: [Hive ACID and transactional tables' support in Presto](<https://devfeed.tech/articles/hive-acid-and-transactional-tables-support-in-presto-8638.md>)

Original publisher: [Read original article](<https://trino.io/blog/2020/06/01/hive-acid.html>)

Author: Shubham Tagra, Qubole

Published: 2020-06-01T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [compliance](<https://devfeed.tech/tags/compliance.md>), [concepts](<https://devfeed.tech/tags/concepts.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [feature](<https://devfeed.tech/tags/feature.md>), [integration](<https://devfeed.tech/tags/integration.md>), [performance](<https://devfeed.tech/tags/performance.md>), [spark](<https://devfeed.tech/tags/spark.md>), [support](<https://devfeed.tech/tags/support.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [update](<https://devfeed.tech/tags/update.md>)

## AI overview

Presto 331 adds read support for Hive ACID transactional tables using a Hive 3 Metastore Server. The article explains ACID semantics, configuration requirements, limitations on writing tables, and the integration's performance and future plans.

## Source excerpt

Hive ACID and transactional tables are supported in Presto since the 331 release. Hive ACID support is an important step towards GDPR/CCPA compliance, and also towards Hive 3 support as certain distributions of Hive 3 create transactional tables by default. In this blog post we cover the concepts of Hive ACID and transactional tables along with the changes done in Presto to support them. We also cover the performance tests on this integration and look at the future plans for this feature.