Answer / Rohit Dikshit

"Hive is a data warehousing tool built on top of Hadoop for providing SQL-like queries over large datasets stored in HDFS (Hadoop Distributed File System). It allows users to create tables, partitions, and execute complex analytical queries without the need to write MapReduce code."

Explain about the different types of join in Hive?

1 Answers  

---

List the various options available with the Hive command?

1 Answers  

---

Can we run unix shell commands from hive? Can hive queries be executed from script files? How? Give an example.

1 Answers  

---

Mention what is ObjectInspector functionality in Hive?

1 Answers  

---

Can you list few commonly used hive services?

1 Answers  

---

Explain Usage of Hive?

1 Answers  

---

What are the different parts of Hive ?

1 Answers  

---

What is the significance of the line set hive.mapred.mode = strict;?

1 Answers  

---

Difference between order by and sort by in Hive?

1 Answers  

---

What will be the result when you do cast(‘abc’ as int)?

1 Answers  

---

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

1 Answers  

---

What is the difference between Hive CLI and Beeline?

1 Answers  

---