You can translate the question and the replies:

Collecting Field wise stats without using CSV

How can I generate statistics at a field level using the scheduler without creating the csv or the base view to pass the viewname and fieldname values ?
user
02-01-2020 02:37:49 -0500

3 Answers

Hi, To avoid creating a CSV file or view for updating statistics for fields in a view, you can use the LIST source included in the Denodo Scheduler for parameters instead of the CSV or DATABASE (JDBC or VDP) sources. This source allows you to specify a list of values within the Scheduler for a single parameter in a parameterized query. For more information about available data sources for parameterized queries you can look at the [Configuring the Values to Be Used in a Parameterized Query]( https://community.denodo.com/docs/html/browse/latest/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section#configuring-the-values-to-be-used-in-a-parameterized-query) section of the Denodo Scheduler documentation. Hope this helps!
Denodo Team
02-01-2020 14:11:43 -0500
That is the problem for using the field level stats I need to pass two parameters 1) The view name 2) The field array How can I achieve it in scheduler without using csv or base view ?
user
03-01-2020 01:30:25 -0500
Hi, A quick way to query all of the views in a database is to use the [GET_VIEWS()](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) and [GENERATE_STATS()](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/generate_stats) functions included in the Denodo Virtual DataPort server. Instead of using a list source in the Scheduler, create a data source connection to the desired Virtual DataPort database. You can run a query on the GET_VIEWS() function to return information about the views in the database. For example: “SELECT name FROM GET_VIEWS() WHERE database_name = ‘<database_name>’” would return all the names of views in the database "<database_name>". Keep in mind that this will update statistics for all views in the database. Make sure to add filters if you want to reduce the number of views this is applied to. After adding a mapping from “name” to your parameterized query variable, the name of each view can be put into the “GENERATE_STATS(‘@<query_variable>’)” parameterized query and the Scheduler will automatically generate statistics for each view in your database. Hope this helps!
Denodo Team
14-01-2020 08:45:13 -0500
You must sign in to add an answer. If you do not have an account, you can register here