I am not able to delete or update in hive table .
create table testTableNew(id int ,name string ) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES('transactional'='true');
insert into table testTableNew values('101','syri');
select * from testtablenew;
delete from testTableNew where id = '101';
set name = praveen
where id = 101;
I have added few properties in hive-site.xml also :
After restart the Hive service also same error i am facing.
Quick Start VM - 5.8 and Hive version - 1.1.0.
Please guide me to sort this issue.
try again now
Thanks for the reply Saranvisa,
I already increased this configuration for some other reason,
But no work of update and delete operations.
The CDH distribution of Hive does not support transactions (HIVE-5317). Currently, transaction support in Hive is an experimental feature that only works with the ORC file format. Cloudera recommends using the Parquet file format, which works across many tools. Merge updates in Hive tables using existing functionality, including statements such as INSERT, INSERT OVERWRITE, and CREATE TABLE AS SELECT.
If you require these features, please inquire about Apache Kudu.
Kudu is storage for fast analytics on fast data—providing a combination of fast inserts and updates alongside efficient columnar scans to enable multiple real-time analytic workloads across a single storage layer.