I understand that all TXN tables must be MANAGED, but my (follow up) question is whether MANAGED tables are required to be ACID tables (can I create a MANAGED table that is not ACID?) and if this is the case what is the difference between MANAGED and ACID tables? My original question is whether documentation correctly states that MANAGED is the default.
Thank you, Vlad From: Simhadri G <simhadri...@gmail.com> Reply-To: "dev@hive.apache.org" <dev@hive.apache.org> Date: Tuesday, July 1, 2025 at 9:28 AM To: dev <dev@hive.apache.org> Subject: RE: [EXTERNAL] MANAGED or EXTERNAL? In hive 4, All trasactional tables (acid and insert only tables) are managed tables. JIRA : https://issues.apache.org/jira/browse/HIVE-13175 Documented here: https://cwiki.apache.org/confluence/plugins/servlet/mobile?contentId=40509723#HiveTransactions-ACIDandTransactionsinHive Quoting from Documentation: "External tables cannot be made ACID tables since the changes on external tables are beyond the control of the compactor (HIVE-13175<https://issues.apache.org/jira/browse/HIVE-13175>)." On Tue, Jul 1, 2025, 9:21 PM Rozov, Vlad <vro...@amazon.com.invalid> wrote: Are you saying that ACID == MANAGED? Is it documented? I agree that by default tables should not be TXN enabled and this is the existing default (“transactional”=“false”). If that also means that default is now EXTERNAL, should it be properly documented? How that impacts ALTER? If I create a table with default properties and then enable TXN, will it become MANGED? Thank you, Vlad From: lisoda <lis...@yeah.net<mailto:lis...@yeah.net>> Reply-To: "dev@hive.apache.org<mailto:dev@hive.apache.org>" <dev@hive.apache.org<mailto:dev@hive.apache.org>> Date: Tuesday, July 1, 2025 at 8:34 AM To: dev <dev@hive.apache.org<mailto:dev@hive.apache.org>> Subject: RE: [EXTERNAL] MANAGED or EXTERNAL? In general, I believe that the default behavior of Hive creating non-ACID tables is a good one. Many users are migrating from Hive 1, 2, and 3, and third-party engines like Trino can currently only create and read non-ACID tables. Additionally, Iceberg tables are also non-ACID（not hive acid table）. Since the number of use cases for non-ACID tables is greater than that of ACID tables, it is reasonable to default to creating non-ACID tables and only create ACID tables when users explicitly specify the properties. Error! Filename not specified. ---- Replied Message ---- From Rozov, Vlad<vro...@amazon.com.INVALID><mailto:vro...@amazon.com.INVALID> Date 07/01/2025 23:26 To dev@hive.apache.org<mailto:dev@hive.apache.org> Cc Subject MANAGED or EXTERNAL? Hi All, According to the documentation [1] Hive should create MANAGED tables by default. Is this still the case? I see that by default (unless “transactional”=“true”) Hive 4.1 creates EXTERNAL tables. Thank you, Vlad [1] https://hive.apache.org/docs/latest/languagemanual-ddl_27362034/#managed-and-external-tables
