Finally, I deleted a row !!! There are lots of limitations with following link(ex: bucket, orc, set variables, ...) https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Limitations set hive.support.concurrency=true; set hive.enforce.bucketing=true; set hive.exec.dynamic.partition.mode=nonstrict; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; create table test_delete (
id int,
name string
) CLUSTERED BY (id) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ("transactional"="true"); INSERT INTO TABLE test_delete VALUES (31, 'aaa31'); INSERT INTO TABLE test_delete VALUES (32, 'aaa32'); INSERT INTO TABLE test_delete VALUES (33, 'aaa33'); INSERT INTO TABLE test_delete VALUES (34, 'aaa34'); INSERT INTO TABLE test_delete VALUES (35, 'aaa35'); hive> select * from test_delete; OK 31 aaa31 32 aaa32 33 aaa33 34 aaa34 35 aaa35 Time taken: 0.06 seconds, Fetched: 5 row(s) delete from test_delete where name = 'aaa33'; hive> select * from test_delete; OK 32 aaa32 34 aaa34 31 aaa31 35 aaa35 Time taken: 0.129 seconds, Fetched: 4 row(s)
... View more
