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 ?