Hive transactions not working

#1

Hi I am unable to do Hive transactions. I am getting FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

Below are my table details.

Table Type: MANAGED_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE true
numFiles 2
numRows 2
rawDataSize 194
totalSize 648
transactional true
transient_lastDdlTime 1483410999

Storage Information

SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
Compressed: No
Num Buckets: 4
Bucket Columns: [i]
Sort Columns: []
Storage Desc Params:
serialization.format 1

Also, I have set hive.txn.manager to org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;.
What am I missing here? Thanks

0 Likes

#2

You need to bucket the table.

Here is the video which explain it in detail with demo

0 Likes