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.
---- Replied Message ---- | From | Rozov, Vlad<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
