Hive Not able to delete row

[#1]

My Create table script :

CREATE TABLE IF NOT EXISTS ruckus.UV_MACADD_RT

( event_year INT, event_month INT, event_day INT, event_hour INT, event_minute INT, event_second INT, mac_address String )

COMMENT 'Visitors Realtime - Mac Address - using 15 Minutes'

PARTITIONED BY (venue_id String)

CLUSTERED BY (event_year) INTO 3 BUCKETS

ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'

STORED AS orc TBLPROPERTIES ('transactional'='true');

The table created successfully, but when I try to delete :

delete from ruckus.uv_macadd_rt where venue_id='abc';

I got this error message.

org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

FYI : I have turned on ACID transaction using Ambari.

Any idea what is happening ?

[#2]

@Kalim Julia

You need to set up below properties to delete.

These configuration parameters must be set appropriately to turn on transaction support in Hive:

Client Side

• hive.support.concurrency – true
• hive.enforce.bucketing – true (Not required as of Hive 2.0)
• hive.exec.dynamic.partition.mode – nonstrict
• hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager

Server Side (Metastore)

• hive.compactor.initiator.on – true (See table below for more details)
• hive.compactor.worker.threads – a positive number on at least one instance of the Thrift metastore service

For further information refer to below link

https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Transaction/Lock...

[#3]

I am facing the same problem. Following all the above steps but still unable to get delete command running.

Note: I have table with no sorting.