https://community.databricks.com/t5/administration-architecture/cluster-with-shared-access-mode-cannot-query-metastore/m-p/63623#M969 <P>Hi,&nbsp;</P><P>I have created a new UC enabled metastore using an Azure storage account and container connected to a Databricks workspace using an access connector. At first glance everything seems to work.&nbsp;</P><P>I encounter a problem, however, when I try to query UC using a shared access mode cluster. I get an error,&nbsp;</P><P><SPAN>`org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient`</SPAN></P><P><SPAN>which seems to be caused by the exception,&nbsp;</SPAN><SPAN>`SparkConnectGrpcException`, which gets thrown by the SparkConnectClient after informing me that it "cannot invoke RPC" and and that "closed" is contained in the grpc.RpsError.&nbsp;</SPAN></P><P><SPAN>What am I doing wrong, and how can I fix it?&nbsp;&nbsp;</SPAN></P><P>&nbsp;</P><P>Note:&nbsp;</P><P>- There is no problem, when I use SQL Warehouses or single mode access clusters.</P><P>- I have a metastore in a different region (West Europe) that doesn't experience this problem&nbsp;&nbsp;</P><P>- The problematic workspace/metastore is located in North Europe</P> Thu, 14 Mar 2024 07:07:36 GMT alm 2024-03-14T07:07:36Z https://community.databricks.com/t5/administration-architecture/cluster-with-shared-access-mode-cannot-query-metastore/m-p/63623#M969 <P>Hi,&nbsp;</P><P>I have created a new UC enabled metastore using an Azure storage account and container connected to a Databricks workspace using an access connector. At first glance everything seems to work.&nbsp;</P><P>I encounter a problem, however, when I try to query UC using a shared access mode cluster. I get an error,&nbsp;</P><P><SPAN>`org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient`</SPAN></P><P><SPAN>which seems to be caused by the exception,&nbsp;</SPAN><SPAN>`SparkConnectGrpcException`, which gets thrown by the SparkConnectClient after informing me that it "cannot invoke RPC" and and that "closed" is contained in the grpc.RpsError.&nbsp;</SPAN></P><P><SPAN>What am I doing wrong, and how can I fix it?&nbsp;&nbsp;</SPAN></P><P>&nbsp;</P><P>Note:&nbsp;</P><P>- There is no problem, when I use SQL Warehouses or single mode access clusters.</P><P>- I have a metastore in a different region (West Europe) that doesn't experience this problem&nbsp;&nbsp;</P><P>- The problematic workspace/metastore is located in North Europe</P> Thu, 14 Mar 2024 07:07:36 GMT https://community.databricks.com/t5/administration-architecture/cluster-with-shared-access-mode-cannot-query-metastore/m-p/63623#M969 alm 2024-03-14T07:07:36Z