0

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.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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:

    https://community.incorta.com/t/18jnhd/where-are-the-incorta-logs-and-what-can-i-find-there

    Like
    • Siva Kowsika 

       

      Hi Siva - thanks for responding.  I should have updated this topic and marked it as resolved.   I had an  issue w/ Spark configuration.

      Like 1
Like Follow
  • 9 days agoLast active
  • 2Replies
  • 22Views
  • 2 Following