Answer / Sandeep Dixit

Hive shares similarities with SQL, as it allows developers to use SQL-like queries (HQL) to access and manipulate data stored in Hive. However, some differences exist due to its distribution nature on top of HDFS.

TRIM function in Hive with example?

1 Answers  

---

When to use Hive?

1 Answers  

---

Explain how Hive Deserialize and serialize the data?

1 Answers  

---

When you should use Hbase?

1 Answers  

---

RLIKE in Hive?

1 Answers  

---

Say when to pick “inward table” and “outside table” in hive?

1 Answers  

---

What is SerDe in Apache Hive ?

1 Answers  

---

What do you mean by schema on read?

1 Answers  

---

What is the utilization of hcatalog?

1 Answers  

---

How can you add a new partition for the month December in the above partitioned table?

1 Answers  

---

Say what the object inspector functionality is in hive?

1 Answers  

---

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

1 Answers  

---