Hive CLI vs HUE

Hi,

We have built a 6 node cluster in our office for POC. There they have given the user credentials to login to HUE.(writh hue administrator privileges). i created the transactional(ACID) table it got created but after insert when i delete the records it is throwing error “sematic exception : 10294 - attempt to update or delete using transaction manager that doesnt support these operations”.

But when i logged in with HIVE CLI with OS level user, and logged into the same db and insert records into the same table created from hue. Here i can able to delete and update the records which were inserted from HIVE CLI. but still not able to delete or update the data which was inserted thru HUE.

(Also i am unable to delete/update the records which were loaded from CLI thru Hue).

But i didnt face this issue in Cloudxlab. So could you please help me how to sync or how exactly it has been implemented in cloudxlab.

Thank you for the support.