Answer / Sayyad Musarrat Masood Zaidi

The main components of a Hive query processor include: Compiler, Optimizer, Execution Engine, and Metastore.

What is hive installation path?

1 Answers  

---

What are hive operators and its types?

1 Answers  

---

How to enable buckets in Hive?

1 Answers  

---

Is there a date data type in Hive?

1 Answers  

---

Are there any problems which can only be solved by MapReduce and cannot be solved by PIG? In which kind of scenarios MR jobs will be more useful than PIG?

1 Answers  

---

In which scenario Hive is good fit?

1 Answers  

---

How do you write your own custom SerDe ?

1 Answers  

---

Mention the date data type in hive. Name the hive data type collection.

1 Answers  

---

Can you execute Hadoop dfs Commands from Hive CLI? How?

1 Answers  

---

Can we run unix shell commands from hive? Give example?

1 Answers  

---

What is the purpose of exploding in hive?

1 Answers  

---

When should we use SORT BY instead of ORDER BY?

1 Answers  

---