cancel
Showing results for 
Search instead for 
Did you mean: 

MV using Incorta SQL

srini_ch
Ranger

Hi,

I tried creating an MV using Incorta SQL as Data Source, but I keep getting below error as shown below. Can you help me understand when to use this particular type in creating MV's.

INC_04030340: Materializing table failed because 109152

Thanks,

Srini

3 REPLIES 3

amit_kothari
Employee
Employee

This option is for spark sql and it can refer to incorta physical schema tables (no business schema allowed here) . You can paste your sql here and I can check . Pls also log a ticket . 

JoeM
Community Manager
Community Manager

@srini_ch  - Not sure if this applies in your case, but a materialized view column cannot reference a column in an Incorta Analyzer table or Incorta SQL table that exists in the same physical schema as the materialized view. 

KailaT
Community Manager
Community Manager

Hi @srini_ch

I wanted to follow up here. Were you able to get this working as expected?