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!
28-03-2023 11:39:54 -0400

1 Answer

Hi, If I face such an error, I would check if the [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]( You can also take a look at the [Data Source Configuration Properties]( and [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]( and our Support Team will assist you. Hope this helps!
Denodo Team
28-03-2023 17:59:16 -0400
You must sign in to add an answer. If you do not have an account, you can register here