SUMMARY:
This issue has been classified as working by design in Strategy SQL Engine 9.4.1. An Enhancement Request for this issue has been logged and is being reviewed for a future Strategy release. This issue only occurs against Impala when trying to use a Cross Join in SQL.
SYMPTOM:
When an End User attempts to run a report that should generate a Cross Join between tables against an Impala Database in Strategy 9.4.1, they find that the Cross Join does not appear but is replaced by a standard join.
STEPS TO REPRODUCE:
Step 1) Create a report containing the attributes Year and Region against a non-Impala Database.
Step 2) View the SQL of that report and Developers will see a 'Cross Join'.
Step 3) Change the database to be Imapala and users will find the SQL does not contain a Cross Join as expected but shows a standard join.
VIDEO:
You can find a detailed video on how this issue is reproduced here:
CAUSE:
This has been classified as Working by Design in Strategy 9.4.1. Currently Cross Joins against an Impala Database are not support by Strategy’s SQL Engine. An Enhancement Request for this issue has been logged and is being reviewed for a future Strategy release.
ACTION:
Currently this issue is being reviewed by Strategy for a potential code level fix on an upcoming Strategy release. It is strongly encouraged that you post your questions on the community forum for any community based workarounds
Third Party Software Installation: WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
