Answer / Sudil Kumar

A Hive variable is a placeholder that can hold a value during the execution of a query. It allows for dynamic SQL queries by allowing you to store and reuse values inside the query. Variables are declared using the SET command.nnExample: SET var_name = 'value'; SELECT var_name as var, column_name FROM table;

When to choose "External Table" in Hive?

0 Answers  

---

How can client interact with Hive?

1 Answers  

---

As part of optimizing the queries in hive, what should be the order of table size in a join query?

1 Answers  

---

Explain what is Hive?

1 Answers  

---

Are multiline comments supported in Hive?

1 Answers  

---

List the various options available with the Hive command?

1 Answers  

---

What are the different Primitive Data Types available in Hive?

1 Answers  

---

What are the 2 types of table in hive?

1 Answers  

---

How to skip header rows from a table in Hive?

0 Answers  

---

What does the overwrite keyword denote in Hive load statement?

1 Answers  

---

Is it possible to create multiple table in hive for same data?

1 Answers  

---

Why do we need hive?

1 Answers  

---