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

710

---

Can we run unix shell commands from hive? Can hive queries be executed from script files? How? Give an example.

756

---

What is the precedence order of hive configuration?

887

---

Why hive does not store metadata information in hdfs?

893

---

Whenever we run hive query, new metastore_db is created. Why?

656

---

How hive can improve performance with orc format tables?

677

---

How to change the column data type in hive? Explain rlike in hive.

649

---

What are the uses of explode hive?

684

---

how can we access the sub directories recursively?

757

---

How do we write our own custom serde?

663

---

Explain the functionality of object-inspector.

681

---

Differentiate between hive and hbase?

716

---

Explain process to access sub directories recursively in hive queries.

855

---

Mention the date data type in hive. Name the hive data type collection.

654

---

What is the local repository and where it is useful while using ambari environment?

60

---