Answer / Vikash Rai

To optimize join queries in Hive, it is recommended to join larger tables first and smaller ones later. This strategy reduces the amount of data that needs to be shuffled between nodes during the MapReduce job, improving query performance.

If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?

1 Answers  

---

Is Hive useful when making data warehouse applications?

1 Answers  

---

What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;

1 Answers  

---

Which company initially developed Hive ?

1 Answers  

---

Difference between external table and internal table in HIVE ?

1 Answers  

---

What is the difference between CREATE TABLE AND CREATE EXTERNAL TABLE?

1 Answers  

---

What is a generic UDF in the hive?

1 Answers  

---

What are the different components of a Hive architecture?

1 Answers  

---

what is Metastore in Hive?

1 Answers  

---

What is ObjectInspector functionality?

1 Answers  

---

What types of costs are associated in creating index on hive tables?

1 Answers  

---

What is Clustring in Hive?

1 Answers  

---