Answer / Mukesh Dahiya

"Apache Hive can be used with a variety of data warehousing applications. It is best suited for working with large datasets and performing SQL-like queries on them. In Hive, there are two types of tables: Managed Tables (stored in HDFS) and External Tables (pointing to existing data outside the Hive warehouse)."n

how can we access the sub directories recursively?

1 Answers  

---

What is the prerequisite for Apache Hive installation?

1 Answers  

---

UPPER or UCASE function in Hive with example?

1 Answers  

---

How would you drop a table in Hive?

1 Answers  

---

Explain SHOW and DESCRIBE Commands in Hive?

1 Answers  

---

what Hive is composed of ?

1 Answers  

---

When a large data set is maintained?

1 Answers  

---

What is the importance of .hiverc file?

1 Answers  

---

Mention what are views in Hive?

1 Answers  

---

What database are supported by Hive?

1 Answers  

---

Mention what is ObjectInspector functionality in Hive?

1 Answers  

---

Write a query to insert a new column(new_col int) into a hiev table (htab) at a position before an existing column (x_col)

1 Answers  

---