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

747

---

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

809

---

What is the precedence order of hive configuration?

939

---

Why hive does not store metadata information in hdfs?

942

---

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

684

---

How hive can improve performance with orc format tables?

720

---

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

703

---

What are the uses of explode hive?

721

---

how can we access the sub directories recursively?

794

---

How do we write our own custom serde?

714

---

Explain the functionality of object-inspector.

727

---

Differentiate between hive and hbase?

766

---

Explain process to access sub directories recursively in hive queries.

900

---

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

689

---

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

60

---