Answer / rajasekhar

Hive is used for storing and processing huge amount of data.
RDBMS is used for storing terabytes of data.
Hive is OLAP
RDBMS is OLTP

How will you convert the string ’51.2’ to a float value in the price column?

1 Answers  

---

Explain the Differences between Hive and Spark SQL?

1 Answers  

---

What do you mean by schema on read?

1 Answers  

---

What are the Binary Storage formats supported in Hive?

1 Answers  

---

The partition of hive table has been modified to point to a new directory location. Do I have to move the data to the new location or the data will be moved automatically to the new location?

1 Answers  

---

Say what the object inspector functionality is in hive?

1 Answers  

---

What are types of hive built-in functions?

1 Answers  

---

Why is Hive not suitable for OLTP systems?

1 Answers  

---

If you run a select * query in hive, why does it not run mapreduce?

1 Answers  

---

What is the usefulness of the distributed by clause in hive?

1 Answers  

---

What are hive operators and its types?

1 Answers  

---

What are different modes of metastore deployment in Hive?

1 Answers  

---