`io.unitycatalog.client.model.TableType`, Unexpected value 'MATERIALIZED_VIEW

NUKSY
New Contributor II

‎03-03-2025 11:55 AM

I have been able to set up jdbc driver with databricks to connect to my unity catalog using local spark sessions. When i try to retrieve tables in my schema i get this error 

 An error occurred while calling o43.sql.
: io.unitycatalog.client.ApiException: com.fasterxml.jackson.databind.exc.ValueInstantiationException: Cannot construct instance of `io.unitycatalog.client.model.TableType`, problem: Unexpected value 'MATERIALIZED_VIEW'
 at [Source: (jdk.internal.net.http.ResponseSubscribers$HttpResponseInputStream); line: 1, column: 125] (through reference chain: io.unitycatalog.client.model.ListTablesResponse["tables"]->java.util.ArrayList[0]->io.unitycatalog.client.model.TableInfo["table_type"])

 

0 Kudos

Renu_
Valued Contributor II

‎03-09-2025 10:52 AM

The issue could be because your JDBC driver doesn’t recognize Unity Catalog’s MATERIALIZED_VIEW table type, leading to this error. Try upgrading the Databricks JDBC driver which includes support for Unity Catalog features. You can also add UseNativeQuery=0 to your JDBC options to avoid native query parsing conflicts. And make sure your local Spark configuration aligns with Unity Catalog settings like access mode and permissions.

0 Kudos

NUKSY
New Contributor II
In response to Renu_

‎03-11-2025 08:09 AM

Hi I am still getting this error. What version of Databricks jdbc driver does not cause this error

 

0 Kudos

Jofes
New Contributor II

‎03-11-2025 02:03 AM

I am getting the same but for MANAGED_SHALLOW_CLONE tables:

An error occurred while calling o47.sql. : io.unitycatalog.client.ApiException: com.fasterxml.jackson.databind.exc.ValueInstantiationException: Cannot construct instance of io.unitycatalog.client.model.TableType, problem: Unexpected value 'MANAGED_SHALLOW_CLONE' at [Source: (jdk.internal.net.http.ResponseSubscribers$HttpResponseInputStream); line: 1, column: 90] (through reference chain: io.unitycatalog.client.model.TableInfo["table_type"])

 

0 Kudos

NandiniN
Databricks Employee
Databricks Employee

‎09-19-2025 11:59 AM

Hi @NUKSY , @Jofes 

This should be reported as a bug, see similar issues reported.

https://github.com/unitycatalog/unitycatalog/issues/657

https://github.com/unitycatalog/unitycatalog/issues/1077

Thanks!

0 Kudos