Answer / Dayashankar

The TRIM function in Hive is used to remove leading, trailing, or both leading and trailing spaces from a string. Here's an example:nnSELECT TRIM(LEADING 'a' FROM 'aabc') as trimmed;nResult: abc

When you are dealing with static data instead of dynamic data?

1 Answers  

---

What is the major difference between local and remote meta-store?

1 Answers  

---

How would you drop a table in Hive?

1 Answers  

---

What is the importance of driver in hive?

1 Answers  

---

Explain when to use explode in Hive?

1 Answers  

---

How can you prevent a large job from running for a long time? What do u think is more popular among the developers - Pig or Hive?

1 Answers  

---

Can we load data into a view?

1 Answers  

---

What is Internal and External table in Hive?

1 Answers  

---

What are collection data types in Hive?

1 Answers  

---

What is Hive ?

1 Answers  

---

How to create table in hive for a json input file?

1 Answers  

---

What are different modes of metastore deployment in Hive?

1 Answers  

---