There are many limitations to insert/update/delete transactions.
- Updating values of bucketing columns are not allowed.
- The file format should be in ORC format.
- Tables should be bucketed.
There are many limitations. To get to know all the flaws, go through this link.
To overcome this, you need to set some properties:
- set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
- set hive.enforce.bucketing=true;
- set hive.exec.dynamic.partition.mode=nonstrict