Answer / Mohd Afzal

A partitioned table in Hive is a table divided into smaller, more manageable pieces based on one or more columns (partition keys). This improves query performance by reducing the amount of data scanned.

is HQL case sensitive?

1 Answers  

---

Differentiate between PigLatin and Hive?

1 Answers  

---

what is hadoop archive?

1 Answers  

---

How do you check if a particular partition exists?

1 Answers  

---

What is the difference between External and Internal Table in Hive?

1 Answers  

---

Differentiate between describe and describe extended?

1 Answers  

---

What is Hive Present Version ?

1 Answers  

---

Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

1 Answers  

---

How to change the column data type in hive? Explain rlike in hive.

1 Answers  

---

In which scenario Hive is good fit?

1 Answers  

---

Which java class handles the Input record encoding into files which store the tables in Hive?

1 Answers  

---

How many types of Tables in Hive?

1 Answers  

---