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

4 REPLIES 4

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?

srini_ch
Ranger

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