Answer / Beena

Partitions in Hive are used to split large tables into smaller, more manageable chunks based on a specified column or columns. This improves query performance by reducing the amount of data scanned during query execution. Partitioning can be done using the ALTER TABLE command.

Is it possible to use the same metastore by multiple users, in case of the embedded hive?

1 Answers  

---

How can you connect an application, if you run hive as a server?

1 Answers  

---

Write a Hive UDF that returns a sentiment score. For example, if good = 1, bad = -1, and average = 0, then a review of a restaurant states "Good food, bad service," your score might be 1 - 1 = 0.

1 Answers   LinkedIn,

---

Can we change the data type of a column in a hive table?

1 Answers  

---

What happened after creating a table in hive ?

1 Answers  

---

What is the need for custom serde?

1 Answers  

---

What is dynamic partitioning and when is it used?

1 Answers  

---

Can we say cogroup is a group of more than 1 data set?

1 Answers  

---

How do you write your own custom SerDe ?

1 Answers  

---

Differentiate between hive and hbase?

1 Answers  

---

How can you prevent a large job from running for a long time? What do u think is more popular among the developers - Pig or Hive?

1 Answers  

---

What do you mean by schema on read?

1 Answers  

---