SQL joins - troubleshoot non-working
I have a couple simple schemas ( one of them is the Incorta "Sales" schema, the other part of Cognos' Great Outdoors sales schema ). Both of them work as expected until I try to create a SQL Join between tables. As soon as I do I get a perpetually spinning progress graphic.
I thought it might be a spark issue but a materialized view in "Sales" loads successfully and shows up in spark activity ( looking at the browser page for the embedded Spark instance ).
I'll appreciate any pointers as to what to look at next / differently.
R. A. Dawson Sr are you talking about Incorta Join from webUI or ANSI SQL joins inside materialized view using Spark SQL.
if you want to troubleshoot spark execution you can go spark master url and default port listens to 9091
if you want to troubleshoot incorta joins, you will need to analyze incorta logs.
learn more about incorta logs from this article. please look at the section. For Incorta 4.x: