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