0 votes
in Big Data | Hadoop by
Limitations in Hive Transactions

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

Related questions

0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
...