Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can I delete the above index named index_bonuspay?
When we are using queries instead of scripting?
Can We Change settings within Hive Session? If Yes, How?
When to use explode in Hive?
What is a Hive variable? What for we use it?
How to skip header rows from a table in Hive?
What is the stable version of Hive ?
When to choose "External Table" in Hive?
What are the different types of tables available in Hive?
Where does the data of a Hive table gets stored?
