What are the types of hive ddl commands?

814

---

How can you stop a partition form being queried?

810

---

What is the default location where hive stores table data?

730

---

What are types of hive built-in functions?

779

---

Why do we need hive?

769

---

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

847

---

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

1067

---

Give some points of hive for hadoop ?

772

---

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)

832

---

What is a metastore in hive?

746

---

What is the importance of driver in hive?

760

---

How can hive avoid mapreduce?

741

---

What are hive operators and its types?

795

---

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

728

---

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

728

---