Answer / Mamta Singh

Hive is a data warehousing and SQL-like query language built on top of Apache Hadoop. It allows users to write queries in a format similar to SQL, and then execute those queries against large datasets stored in HDFS.

Explain bucketing in Hive?

1 Answers  

---

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

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  

---

What is the significance of ‘IF EXISTS” clause while dropping a table?

1 Answers  

---

What will be the output of cast ('XYZ' as INT)?

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  

---

What are the key segments of hive architecture?

1 Answers  

---

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

1 Answers  

---

What is Hive Data Definition language?

1 Answers  

---

Specify the different methods of hive?

1 Answers  

---

How can you configure remote metastore mode in Hive?

1 Answers  

---

What is the functionality of Query Processor in Apache Hive?

1 Answers  

---