What are the types of hive ddl commands?

712

---

How can you stop a partition form being queried?

723

---

What is the default location where hive stores table data?

650

---

What are types of hive built-in functions?

696

---

Why do we need hive?

685

---

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

744

---

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

974

---

Give some points of hive for hadoop ?

672

---

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)

756

---

What is a metastore in hive?

654

---

What is the importance of driver in hive?

657

---

How can hive avoid mapreduce?

620

---

What are hive operators and its types?

681

---

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

630

---

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

648

---