07-13-2022 02:34 PM
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
Solved! Go to Solution.
07-13-2022 09:38 PM
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 .
07-27-2022 08:35 AM
@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.
08-04-2022 05:42 AM
Hi @srini_ch,
I wanted to follow up here. Were you able to get this working as expected?
08-08-2022 07:17 AM - edited 08-08-2022 07:20 AM
Hi,
Sorry for the delayed response!! My query follows a syntax as below,
SELECT
A.X1, A.X2, B.X4, B.X5
FROM
table1 A
LEFT OUTER table2 B ON A.X1 = (B.X2||'.'||B.X3)
Error: Invalid query due to A.X1 = (B.X2||'.'||B.X3) is not a valid constraint
Thanks,
Srini