Answer / Mitul Saxena

The Internal Table in Hive is a performance optimized table storage format that stores data on HDFS and manages its own metadata. It is recommended when you require high query performance, as it uses columnar storage, partitioning, and bucketing for efficient data access. However, it may not support some advanced features like JSON serialization or external tables.

What are the types of hive ddl commands?

1 Answers  

---

What is the utilization of hcatalog?

1 Answers  

---

Does Pig give any warning when there is a type mismatch or missing field?

1 Answers  

---

When to use explode in Hive?

0 Answers  

---

What is the difference between Cassandra, Pig and Hive?

1 Answers  

---

Specify the different types of tables accessible in hive?

1 Answers  

---

Give the command to see the indexes on a table?

1 Answers  

---

Why is Hive not suitable for OLTP systems?

1 Answers  

---

Is it possible to add 100 more nodes when we already have 100 nodes in Hive?

1 Answers  

---

Mention what is the difference between Hbase and Hive?

1 Answers  

---

Hive for Hadoop - Give some points?

1 Answers  

---

When application is on high latency (high response time)?

1 Answers  

---