Answer / Sanjeev Kumar Gautam

Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data query and analysis. Hive gives an SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop.

How many types of Tables in Hive?

1 Answers  

---

Why Hive is not suitable for OLTP systems?

1 Answers  

---

What is the significance of ‘IF EXISTS” clause while dropping a table?

1 Answers  

---

When to choose "Internal Table" in Hive?

1 Answers  

---

Differentiate between hive and hbase?

1 Answers  

---

What are collection data types in Hive?

1 Answers  

---

What will be the output of cast ('XYZ' as INT)?

1 Answers  

---

What is the difference between sort by and order by in hive?

1 Answers  

---

Is it possible to change the default location of Managed Tables in Hive, if so how?

1 Answers  

---

Differentiate between describe and describe extended?

1 Answers  

---

What is the use of Hcatalog?

1 Answers  

---

what is partitions in hive?

1 Answers  

---