SAP Knowledge Base Article - Preview

3313410 - SQL statement contains N JOINs. Maximum JOINs per query is 40 - SAP HANA Smart Data Integration

Symptom

  • SQL statement contains <N> JOINs. Maximum JOINs per query is 40. The value can be configured through DP Agent configuration framework.maxJoinsPerQuery, however maxJoinsPerQuery > 40 (default) could adversely affect query parse time and increased memory allocation for complex queries.
  • Table name involved in the query contains the word JOIN, ex:
    • SELECT "VTABLE_JOIN$VT"."WWREC", "VTABLE_JOIN$VT"."WWREG" FROM """DISTRIBUTE"".""TABLE_JOIN""" "VTABLE_JOIN$VT" ]
  •  The number <N> shown in the error text roughly corresponds to the number of columns selected from the table


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.