Answer / Gyaneshchandra Sharma

Yes, Hive does support temporary tables. Temporary tables in Hive are created using the CREATE TEMPORARY TABLE statement. These tables can be used for intermediate calculations within a HiveQL query and will automatically be dropped when the query finishes.

What is the use of Hcatalog?

1 Answers  

---

What is the definition of Hive?

1 Answers  

---

How can the columns of a table in hive be written to a file?

1 Answers  

---

what does /*streamtable(table_name)*/ do?

1 Answers  

---

Clarify how hive de-serialize and serialize the information?

1 Answers  

---

How do you list all databases whose name starts with p?

1 Answers  

---

Difference between HBase vs Hive?

1 Answers  

---

What is the use of "order by" in Hive?

1 Answers  

---

While loading data into a hive table using the load data clause, how do you specify it is a hdfs file and not a local file ?

1 Answers  

---

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

1 Answers  

---

What are the advantages and Disadvantages in archieving partition in Hive?

1 Answers  

---

Can i access Hive Without Hadoop ?

1 Answers  

---