MV using Incorta SQL

[srini_ch]

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

[amit_kothari]

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]

@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]

Hi @srini_ch, 

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

[srini_ch]

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