When I need to get a specific number of results, I usually add the **LIMIT** clause to the end of my query. For example:
SELECT * FROM customers LIMIT 10;
When I have a problem executing a view and I am not sure where is the error, I follow these steps to pinpoint the reason:
1. I get the query executed in the Denodo VDP Server by reading the vdp-requests.log.
2. Once I have the query throwing the error, I execute it in the VQL Shell of the VDP Admin tool.
3. I annalyze the execution trace to see which is the first node with error.
If with that you are still not able to solve your problem and you have a user with access to the Denodo Support site (http://support.denodo.com), I would recommend you to raise a support case and the Denodo Support team will help you to find the solution.
Hope this helps!