topic Re: `io.unitycatalog.client.model.TableType`, Unexpected value 'MATERIALIZED_VIEW in Data Engineering

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

NUKSY — Mon, 03 Mar 2025 19:55:29 GMT

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"])

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

Renu_ — Sun, 09 Mar 2025 17:52:20 GMT

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.

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

Jofes — Tue, 11 Mar 2025 09:03:52 GMT

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"])

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

NUKSY — Tue, 11 Mar 2025 15:09:16 GMT

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

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

NandiniN — Fri, 19 Sep 2025 18:59:15 GMT

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!