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 <[email protected]> Reply-To: "[email protected]" <[email protected]> Date: Tuesday, July 1, 2025 at 8:34 AM To: dev <[email protected]> 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. [Image removed by sender.] ---- Replied Message ---- From Rozov, Vlad<[email protected]><mailto:[email protected]> Date 07/01/2025 23:26 To [email protected]<mailto:[email protected]> 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
