You can translate the question and the replies:

Error with data movements using Excel files

Hello, I have a Derived View which contains multiple joins to other Derived and Base Views. The Base Views are sourced from individual Excel files. The Derived Views are derivations and joins on those Excel files. I wanted to turn on the Data Movement feature ('Enable Data Movement') for each Base View in the Execution Plan (where the Data Movement is to happen in the Cache database which is MySQL). After I set all the underlying Views in the Execution Plan and then execute the view, I am getting the following error: "Finished with error: There was an error simplifying view with data movements". Am I not allowed to set all underlying objects in the Execution Plan to 'Enable Data Movement'?
user
02-07-2018 01:23:34 -0400
code

1 Answer

Hi, I was doing several tests and I wasn't able to reproduce your issue. You're allowed to set all underlying objects in the Execution Plan to _Enable Data Movement_. However, if you're using full cache, you don't need to enable data movement because the join operation will be delegated to the cache. You should take into account the [Data Movement](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/optimizing_queries/data_movement/data_movement) document in order to configure you Virtual DataPort. Also, you have to take into account the [Known Limitations](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/optimizing_queries/data_movement/known_limitations) of Data Movement. Hope this helps!
Denodo Team
03-07-2018 08:15:37 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here