You can translate the question and the replies:

Use MPP engine for FLATTEN operations

Dear Denodo Team, we noticed that flattening operations could produce high CPU workload. Do to this we want to outsource this operation to another system. Is there a way in place to perform the flattening operations on the MPP engine instead of Denodo vdp server directly? Using CONTEXT clause MPPMOVEMENTPLAN doesn't have any effect. Flattening is still performed on vdp server side. Regards, Gerhard
user
11-10-2023 07:42:18 -0400
code

1 Answer

Hi, The denodo optimizer provides native integration with several Massive Parallel Processing systems to accelerate queries that require significant processing such as JOINs. As far as I know though, the flatten operation cannot be delegated to the MPP source. I would recommend enabling the cache on the view resulting from the flatten operation, thus improving the performance. If you have a valid Support User, please consider opening a Support Case for further assistance or get in touch with your Technical Account Manager. Hope this helps
Denodo Team
12-10-2023 10:17:47 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here