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,280 points
1,946 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,020 points
0 votes
Vinyl-like crackle sounds. And what is my serial number for Hive 2?
answered May 3 by Carter
• 140 points

Related Questions In Big Data Hadoop

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,280 points
214 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,280 points
1,430 views
–1 vote
1 answer

Create Hive table with bucketing and ORC file format

create table hive_dml (emp_id int, first_name string, last_name ...READ MORE

answered Jan 4, 2019 in Big Data Hadoop by Omkar
• 69,020 points
1,037 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
• 10,920 points
5,503 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
• 10,920 points
810 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyF ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
34,100 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,310 points
2,072 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,020 points
1,932 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,020 points
435 views