Answer / Anish Kumar Pandey

To change the column data type in Hive, you can use the ALTER TABLE command followed by the CHANGE COLUMN statement. Regarding rlike, it is a regular expression pattern for case-insensitive matching in Hive.

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

1 Answers  

---

How can you prevent a large job from running for a long time? What do u think is more popular among the developers - Pig or Hive?

1 Answers  

---

What is “serde” in “hive”?

1 Answers  

---

what is hadoop archive?

1 Answers  

---

Hive new version supported Hadoop Versions ?

1 Answers  

---

What is different table structure available in the hive?

1 Answers  

---

What are the different components of a Hive query processor?

1 Answers  

---

How do you specify the table creator name when creating a table in hive?

1 Answers  

---

Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

1 Answers  

---

What is Bucket in Hive?

1 Answers  

---

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

1 Answers  

---

Explain the functionality of object-inspector.

1 Answers  

---