Hive update and delete limitations

0 votes
I have heard that there are few limitations for Hive table, that we can not enter any data. What are these limitations?
Jan 4, 2019 in Big Data Hadoop by slayer
• 29,370 points
5,988 views

2 answers to this question.

0 votes

In Hive, Update and Delete work based on these limitations:

  • Update/Delete can only be performed on tables that support ACID
  • If you want to use a Hive table in ACID writes (insert, update, delete) then the table property “transactional” must be set on that table.
  • Only ORC file format is supported
  • Tables must be bucketed to make use of these features
answered Jan 4, 2019 by Omkar
• 69,230 points
0 votes
Vinyl-like crackle sounds. And what is my serial number for Hive 2?
answered May 3, 2020 by Carter
• 140 points

Related Questions In Big Data Hadoop

+1 vote
2 answers

How to delete and update a record in Hive?

Hi, Earlier, there was no operation supported for ...READ MORE

answered Dec 18, 2020 in Big Data Hadoop by akhtar
• 38,260 points
6,591 views
0 votes
1 answer
0 votes
1 answer

How to pause and resume hive job?

Practically speaking, it's difficult/impossible to pause and resume ...READ MORE

answered Jul 17, 2018 in Big Data Hadoop by Neha
• 6,300 points
1,310 views
0 votes
1 answer

What is the difference between Hive internal tables and external tables?

Hive has a relational database on the ...READ MORE

answered Nov 19, 2018 in Big Data Hadoop by Neha
• 6,300 points
2,829 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
10,922 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,451 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,305 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,390 points
4,546 views
0 votes
1 answer

Difference between hive.exec.compress.output=true; and mapreduce.output.fileoutputformat.compress=true;

Hey there! The definition of these two properties ...READ MORE

answered Dec 28, 2018 in Big Data Hadoop by Omkar
• 69,230 points
5,870 views
–1 vote
1 answer

Beeline and Hive Query Editor in Embedded mode

Running Hive client tools with embedded servers ...READ MORE

answered Dec 31, 2018 in Big Data Hadoop by Omkar
• 69,230 points
1,405 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP