How to enable ACID properties in Hive without Ambari ?
Are you running an HDP cluster not managed by Ambari? I don't think its simply toggling a property from OFF to ON in the hive-site.xml or any related file because in the background it enables many other properties.
You will really need to do a deep analysis to achieve your goal.
In general i wouldn't recommend to turn on ACID transaction because it has a lot of open issue. We had problems with lock manager, compactors and others.
I want to load data incrementally in Hive. As per Hortonworks recommendation ACID needs to be turn on. Is there any way to load data incrementally without turning it on.
If you cannot get to ambari or don't have enough RAM, don't try to run ACID. it takes some extra RAM.
search the /etc/hive/conf tables for Transaction manager, concurrency, acid, tx
I am able to resolve the issue by changing virtualbox network settings. Changed network setting from NAT to Bridge
Then opened to Ambari using IPaddressOfSandbox:8080. Then Turned On ACID property.
@Vinit Mahiwal You can alternatively modify below configs (/etc/hive/conf) on the host where Hiveserver2 is running (and restart HS2)
| 'hive.support.concurrency': 'true',|
+ . (To disable authorization add below params)