Getting exception while updating table in Hive

Question

I have created one table in hive from existing s3 file as follows:

 create table reconTable (
 entryid string,
 run_date string
 )
 LOCATION 's3://abhishek_data/dump1';

Now I would like to update one entry as follows:

update reconTable set entryid='7.24E-13' where entryid='7.24E-14';

But I am getting following error:

FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

I have gone through a few posts here, but not getting any idea how to fix this.

score 0 · Answer 1 · answered Nov 05 '18 at 07:37

I think you should create an external table when reading data from a source like S3.

Also, you should declare the table in ORC format and set properties 'transactional'='true'.

score 0 · Answer 2 · answered Sep 07 '21 at 07:10

0

You can refer to this Cloudera Community Thread:

answered Sep 07 '21 at 07:10

Arya A.

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. – Adrian Mole Sep 07 '21 at 15:24

2 Answers2