Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive Not able to delete row

avatar
Contributor

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 REPLIES 2

avatar
Rising Star

@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

Server Side (Metastore)

For further information refer to below link

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

avatar
Rising Star

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.