Answer / Sachin Kumar Chaubey

Views in Hive are virtual tables that do not store data but instead represent a SELECT statement. They can be thought of as a stored query or derived table that allows users to work with the results as if they were a real table. Views can help simplify complex queries and make it easier for users to understand and work with the data.

if you run Hive as a server?

1 Answers  

---

When Hive is run in embedded mode

1 Answers  

---

Are multiline comments supported in Hive?

1 Answers  

---

how can we access the sub directories recursively?

1 Answers  

---

How Hive distributes the rows into buckets?

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 enable buckets in Hive?

1 Answers  

---

Can we load data into a view?

1 Answers  

---

What are the types of tables in Hive?

1 Answers  

---

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

1 Answers  

---

CONCAT function in Hive with Example?

1 Answers  

---

What are the default read and write classes in Hive?

1 Answers  

---