[SPARK-43017] Connect to multiple hive metastore using single sparkcontext (i.e without stopping it")

• Type: Question
• Status: Resolved
• Priority: Critical
• Resolution: Invalid
• Affects Version/s: 3.2.0
• Component/s: Spark Core, Spark Submit
• Assignee: Unassigned
• Reporter: Pravin Rathore
• Created: 03/Apr/23 23:19
• Updated: 08/Apr/23 21:43
• Resolved: 08/Apr/23 21:43

Description

I wanted to join 2 hive tables which are stored in 2 different hive metastores.
I would like fetch the first table, create a tempview. Change hive metastore uri, connect to that metastore and fetch the second table , create a tempview and then use tempviews to do further. 

I launched 2 different instances of hive on my local , individually i'm able to connect to both, but when i try to connect to them one after other, the second time the old URI's is getting used.

Any workaround this.

Please help out :\