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?
03-09-2020 05:11:04 -0400

1 Answer

Hi, As mentioned in the [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]( ("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
You must sign in to add an answer. If you do not have an account, you can register here