MV referencing a formula column in an Incorta table throwing error.
I have a file-based table which brings in an ID: "<ID> Total" I use a formula column using a casecontains to drop the " Total" where they exist and return the ID where it does not. All is well with that world.
However, when I try to query the formula column in an MV using Postgres SQL ( I think Spark SQL limits you to non-formula columns? ) I get the following error:
INC_03070101: Failed to load data from [spark://seqsr-dev1:7077] with properties [[error, AnalysisException: Undefined function: 'casecontains'. This function is neither a registered temporary function nor a permanent function registered in the database 'default'.; line 1 pos 76]]
I find this confusing as I'd expect to query the parquet files and I'd expect physical schema formula column results to be stored w/in them -- obviously I'm wrong somewhere ;-)
Any ideas on how to work around the error?