Hi I have a question about how to reconcile the following hive two features going forward:
* original files in MM tables (HIVE-19258, fixed in hive 3.1.0, 4.0.0) * the separation of transactional tables from non transactional tables (HIVE-22342, HIVE-22189, fixed in hive 4.0.0). If I understand things correctly, original files come up when I start with a non-transactional table, add data to it, then later alter that table to make it transactional insert-ony. The second feature makes it such that non-transactional tables are considered external and are not allowed "within the managed warehouse root dir". Wouldn't that make it such that a non-transactional table cannot be converted into a mm table? If that's the case, then you can't create original files, right? what am I missing? Gabriel Balan P.S. I played around a bit in CDP7.0.3: create table foo (a int) location '/a/b/c' tblproperties ("transactional"="false"); --ok alter table foo set tblproperties ("transactional"="true", "transactional_properties"="insert_only"); --Unable to alter table. default.foo cannot be declared transactional because it's an external table create table bar(a int) location '/a/b/d' tblproperties ("transactional"="true", "transactional_properties"="insert_only"); --ok insert into table bar values (123); -- Unable to alter table. A managed table's location needs to be under the hive warehouse root alter table bar set tblproperties ("transactional"="false", "transactional_properties"="--"); --Cannot convert an ACID table to non-ACID -- The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.