Answer / Lata Sngh

The 'IF EXISTS' clause allows you to drop a table only if it already exists. This can prevent errors when you try to drop a non-existent table. For example: DROP TABLE IF EXISTS mytable;

How is HCatalog different from Hive?

1 Answers  

---

When we are using queries instead of scripting?

0 Answers  

---

When you point a partition of a hive table to a new directory, what happens to the data?

1 Answers  

---

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  

---

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

1 Answers  

---

What is skew data in hive?

1 Answers  

---

what are the different modes of Hive?

1 Answers  

---

what Hive is composed of ?

1 Answers  

---

How many types of Tables in Hive?

1 Answers  

---

When you are dealing with static data instead of dynamic data?

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  

---

What is the default database provided by Apache Hive for metastore?

1 Answers  

---