Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive Not able to delete row

Hive Not able to delete row

New 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
Highlighted

Re: Hive Not able to delete row

Contributor

@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...

Re: Hive Not able to delete row

New Contributor

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.