topic Re: MV Column Types No Longer Changeable? in Data & Schema Discussions

MV Column Types No Longer Changeable?

mrossPM2 — Wed, 04 Dec 2024 13:37:20 GMT

We recently upgraded from 2023.7.2 to 2024.7.2. I noticed that we are no longer able to manually change the Column Type in MVs (the Column Type is changeable on regular Incorta tables). On the old version we could change the Column Types for MVs. The drop down is grayed out as shown below. Is this a bug in our cluster, or is this a new restriction that was put in place?

Re: MV Column Types No Longer Changeable?

JoeM — Wed, 04 Dec 2024 14:13:59 GMT

@mrossPM2 - Your eyes do not deceive you. This is a change made in 2024.7.1.

Data types can no longer set by the schema manager in the UI. Instead the UI will reflect the output data type through MV script validation. This prevents discrepancies between the data model and the parquet storage, and ultimately prevents compaction errors. To that end, setting all data types in the MV is recommended.

https://docs.incorta.com/latest/release-notes-2024-7-0#materialized-view-usability-enhancement

Re: MV Column Types No Longer Changeable?

mrossPM2 — Wed, 04 Dec 2024 14:25:27 GMT

Thanks Joe. Slight nitpick, but the documentation refers to data types while the Incorta UI calls them column types. Might be nice to keep the naming consistent.