You can translate the question and the replies:

Row_Number() against Derived view

I have a final view which has been derived from two different data sources MySQL and Postgres. I have cached the derived view. and underlying cache DB is postgres. it supports the row_number function When I execute the 'row_number()' function in the below query ``` SELECT row_number() OVER (ORDER BY column1, column2) AS id FROM derived_view ``` I get the below error `Finished with error: Function 'row_number' is not executable` Please advice, what could be an issue?
row_number anaytical_function
user
03-09-2020 05:11:04 -0400
code

1 Answer

Hi, As mentioned in the [Analytic Functions (Window Functions)](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#analytic-functions-window-functions) section of the Virtual DataPort VQL Guide, Virtual DataPort can only delegate analytic functions to a database and cannot execute them. Since PostgreSQL supports ROW_NUMBER(), I would check your PostgreSQL [data source configuration](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/data_source_configuration_properties/data_source_configuration_properties#data-source-configuration-properties) ("Configuration > Connection") and make sure that "row_number" is included in the **Delegate analytic functions** list. Hope this helps!
Denodo Team
04-09-2020 19:55:24 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here