What are the types of hive ddl commands?

768

---

How can you stop a partition form being queried?

763

---

What is the default location where hive stores table data?

687

---

What are types of hive built-in functions?

739

---

Why do we need hive?

721

---

Is hive suitable to be used for oltp systems? Why?

792

---

What types of costs are associated with creating the index on hive tables?

1013

---

Give some points of hive for hadoop ?

719

---

Write a query to insert a new column(new_col int) into a hiev table (htab) at a position before an existing column (x_col)

786

---

What is a metastore in hive?

697

---

What is the importance of driver in hive?

710

---

How can hive avoid mapreduce?

683

---

What are hive operators and its types?

749

---

when to choose “internal table” and “external table” in hive?

668

---

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

688

---