You can translate the question and the replies:

Function row_number() not executable with temporary tables

Hi, When I use row_number() with a temporary table in VQL Shell, it gives me this error - Function row_number is not executable. If I run the query without the temporary table, it runs perfectly fine. Is there any way to use row_number() function with a temporary table? Any suggesstions? New to Denodo. Thanks!
user
28-03-2023 11:39:54 -0400
code

1 Answer

Hi, If I face such an error, I would check if the [ROW_NUMBER()](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/analytic_functions/analytic_functions#row-number) function is available in the list of analytical functions in the Source Configuration tab. In general, Virtual DataPort can only delegate the analytical functions but cannot execute it. Hence, I would make sure that the query is delegable to the underlying data source. You could find a similar question answered [here](https://community.denodo.com/answers/question/details?questionId=9060g00000009rMAAQ&title=Function+row_number+is+not+executable). You can also take a look at the [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/generating_wrappers_and_data_sources/creating_data_sources/data_source_configuration_properties) and [Analytic Functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/analytic_functions/analytic_functions) Sections of Virtual DataPort VQL Guide for more information. If you are a user with a valid support account then you can raise a Support case in the [Denodo Support Site](https://support.denodo.com/) and our Support Team will assist you. Hope this helps!
Denodo Team
28-03-2023 17:59:16 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here