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 ?
You need to set up below properties to delete.
These configuration parameters must be set appropriately to turn on transaction support in Hive:
Server Side (Metastore)
For further information refer to below link
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.