Answer / Lalit Mohan Gupta

SMB Join in Hive is not directly supported. Hive primarily works with data stored in Hadoop Distributed File System (HDFS), and external data can be joined using a UDF (User Defined Function). To perform an SMB join, you need to mount the SMB share as a Hadoop filesystem and use Hive's JOIN command. However, it's recommended to avoid SMB for large datasets due to performance issues.

How do you write your own custom SerDe ?

1 Answers  

---

Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

1 Answers  

---

Can you explain smb join in hive?

1 Answers  

---

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

1 Answers  

---

Mention if we can name view same as the name of a Hive table?

1 Answers  

---

What is the stable version of Hive ?

0 Answers  

---

What is Partition table in Hive?

1 Answers  

---

How to change the column data type in hive? Explain rlike in hive.

1 Answers  

---

What is the use of explode in Hive?

1 Answers  

---

What are the different collection type in Hive?

1 Answers  

---

Explain Data Type Conversion in Hive?

1 Answers  

---

What is Clustring in Hive?

1 Answers  

---