CODEWITHSUNDEEP
hivehdfshiveql
frb
frb

Reputation: 3798

Doubts on Hive external table insertion and update

I've seen from Hive 0.14 insertions and updates are available. My first question is: do insertions and updates work for external tables?

If they do, how it works? I guess related HDFS files have to be modified by appending new lines and by updating involved lines, respectively.

Thanks!

Upvotes: 1

Views: 443

Answers (1)

Ramesh
Ramesh

Reputation: 1484

Yes, Hive 0.14 supports inserts/ deletes. Having said that, it comes with a number of limitations. Currently there is no support for external tables. Please see here for the full list of limitations - https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions

Upvotes: 1

Related Questions