Answer / Shabd Prakash

The main difference between external tables and internal tables in Hive lies in data storage management. An external table stores its data elsewhere (like HDFS) and only stores metadata in the metastore, while an internal table stores both data and metadata in the metastore.

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  

---

What is ObjectInspector functionality in Hive?

1 Answers  

---

Can the name of a view be same as the name of a hive table?

1 Answers  

---

if you run Hive as a server?

1 Answers  

---

What is a hive in big data?

1 Answers  

---

Is it possible to change the default location of Managed Tables in Hive, if so how?

1 Answers  

---

what is partitions in hive?

1 Answers  

---

How to create table in hive for a json input file?

1 Answers  

---

Can we change the data type of a column in a hive table?

1 Answers  

---

What is the difference between Hbase and Hive?

1 Answers  

---

Explain how Hive Deserialize and serialize the data?

1 Answers  

---

What are Features of Hive?

1 Answers  

---