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?
15-02-2018 10:59:23 -0500

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]( that you should take into account in order to use that cost base optimization. Also, you could read 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
You must sign in to add an answer. If you do not have an account, you can register here