You can translate the question and the replies:

Error gathering the statistics of the view: Wrong stats query resultset

When I try to gather the statistics for a Base View, I am getting the error: "Error gathering the statistics of the view: Wrong stats query resultset" I tried it going to base view > option> statistics and selected enable statistics and complete missing statistics executing SELECT queries options and clicked Gather statistics for selected fileds. Also tried executing "call generate_stats('bv_local_user')" but getting same error. How to resolve this?
Gather Statistics Generate stats
user
15-02-2018 10:59:23 -0500
code

1 Answer

Hi, I have created a base view from a JDBC datasource and I'm gathering the statistics without problem so I couldn't reproduce the error. Gathering statistics process have some [limitations](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_statistics_of_views#limitations-of-the-gathering-statistics-process) that you should take into account in order to use that cost base optimization. Also, you could read how the [gathering statistics process works](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_statistics_of_views#how-the-gathering-statistics-process-works) and the system tables of each vendor used. If you have a support user, do not hesitate to open a new support case and the Denodo Support Team will help you with this issue. Hope this helps!
Denodo Team
23-02-2018 04:46:19 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here