We want to profile Hive managed tables in our Cloudera data lake. This is only possible if the Hive managed table is defined as non transactional. However to turn of that feature you need to rebuild the table. We had a discussion with our architecture team and they don't want to turn off this functionality.
The other option then is using Hive Warehouse Connector. It is known that this has some performance costs. But we want to test this anyway.
Is there any documentation on using this feature?