Deleting rows from Hive external table

Question

I have a Hive external table created from a list of CSV files.

If I perform a Hive delete on a table row (or a number of rows), will the corresponding CSV record/s will be deleted as well?

score 5 · Accepted Answer · edited May 23 '17 at 12:14

5

As far as I know you can't quite delete a row in Hive -- Hive's not a database, it's a scripting language for Map Reduce. However you could do something like

INSERT OVERWRITE INTO TABLE mytable
SELECT * from mytable 
where rowid <> 1;

In which case yes, the CSV will be updated. Also see the answers to this question How to delete and update a record in Hive

edited May 23 '17 at 12:14

Community

1
1

answered Jun 03 '15 at 07:17

maxymoo

35,286
11
92
119

`INSERT OVERWRITE TABLE mytable SELECT * from mytable where rowid <> 1;` worked for me. – Bharath Ram May 27 '21 at 07:02
1

This solution does not work for partitioned external tables. – Arman Jan 26 '23 at 06:12

Deleting rows from Hive external table

1 Answers1