You can translate the question and the replies:

is there any way to notify end user (like fail query) if his query response has been restricted using resource manager.

hi , we would like to restrict the number of days of data to be returned from a time series table. based on response from denodo team they suggested resource manager could be one of option to achieve it. but problem is it doesnt fail the query rather it restrict the query output rows ( we tried stop the query when maximum no of returned rows reached a threshold) . is there any way to fail the query or user should get notified that query output is not complete otherwise we cant let user get incomplete output of rows
user
04-11-2019 23:58:59 -0500

1 Answer

Hi, When you execute a query with Resource Manager restrictions in the VDP Administration Tool you can check the State value of the Execution Trace tab. In that value, when a Row limit restriction has been aplied, the ROW\_LIMIT\_REACHED status is shown. For those specific scenarios where you want a query to be rejected depeding on different conditions such as the row number, you can develop a custom policy. Check the [Developing a Custom Policy](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/custom_policies/developing_a_custom_policy) section of the VDP Developer Guide for more information. Hope this helps!
Denodo Team
06-11-2019 12:21:11 -0500
You must sign in to add an answer. If you do not have an account, you can register here