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> Reply-To: "dev@hive.apache.org" <dev@hive.apache.org> Date: Tuesday, July 1, 2025 at 8:34 AM To: dev <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. [Image removed by sender.] ---- 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
