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

[dylanwan · Accepted solution]

Can you try use the CONCAT() SQL function?

SELECT  A.X1, A.X2, B.X4, B.X5
  FROM table1 A
  LEFT JOIN table2 B 
         ON A.X1 = concat(B.X2,'.',B.X3)

Reference

Spark SQL functions - concat.

[RADSr]

Did you try using concat() or "+" for your concatenation operator?