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> > *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: Image removed by sender.] > > ---- Replied Message ---- > > From > > Rozov, Vlad<vro...@amazon.com.INVALID> <vro...@amazon.com.INVALID> > > Date > > 07/01/2025 23:26 > > To > > 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 > > > > >
