Answer / Ekta Agrawal

The main components of Apache Hive architecture are: 1. Hive Metastore: A central repository for managing metadata information about Hive tables, partitions, and their storage locations in various data warehouses like HDFS or external databases. 2. HiveQL (HQL) Compiler: A tool that translates SQL-like HQL queries into MapReduce jobs or Tez tasks to be executed by the Hadoop framework. 3. Driver: A Java program that acts as a client for executing HQL queries and communicates with the Hive Metastore and Hive Execution Engine. 4. Hive Execution Engine: The engine responsible for executing MapReduce jobs or Tez tasks to process the data stored in HDFS based on the query results.

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

1 Answers  

---

What is a metastore in hive?

1 Answers  

---

what does /*streamtable(table_name)*/ do?

1 Answers  

---

What is Buckets in Hive?

1 Answers  

---

What is bucketing ?

1 Answers  

---

In which scenario Hive is good fit?

1 Answers  

---

What does the overwrite keyword denote in Hive load statement?

1 Answers  

---

TRIM function in Hive with example?

1 Answers  

---

In case of embedded Hive, can the same metastore be used by multiple users?

1 Answers  

---

Explain what is Hive?

1 Answers  

---

How to managed create a table in hive ?

1 Answers  

---

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

1 Answers  

---