You can translate the question and the replies:

How to delegate full join to Dremio source

Hi Team, I have 2 views which from same Dremio datasource. and these 2 views is FULL OUTER Join. But the full out join can't delegate to dremio. could you please help this case? Test1, inner join can deletgate, but outer join not; Test2, change the source configuration, set Delegate natural OUTER JOIN as 'Yes', don't work. Thanks
DataSource VDP 7.0
user
27-08-2020 08:32:05 -0400
code

1 Answer

Hi, I think this can be due to the use of Generic adapter for Dremio as a Data source as the execution engine would not have been able to adapt and create an execution plan based on the capabilities of Dremio. Without the VQL, it is difficult to know why you are experiencing this behavior. However, for this scenario , I will do the following checks, 1. Ensure if Dremio supports Outer join. 2. Analyze Execution trace to see why it is not been delegated. If you are a valid Support user of Denodo, I will suggest you raise a case describing the issue along with the whole VQL of the view and the Dremio data source VQL, as that would be helpful to understand the background better, reproduce the scenario and address the issue. Hope this helps!
Denodo Team
01-09-2020 08:06:38 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here