You can translate the question and the replies:

Iam unable to execute NTILE function in denodo

Hi, While executing query in denodo by using ntile function is not executing. It is showing as below error.Kindly help on this. SQL Error [50006] [HY000]: Error executing view: Function ntile is not executable Much appreciate if you provide suggestions on this. Regards, Naren K
user
08-05-2020 13:45:54 -0400
code

1 Answer

Hi, Denodo supports the [NTILE](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#ntile) Function when it can be delegated to the underlying data source. So, I would make sure the data source supports the NTILE function for execution. For data sources that do not support Analytic functions (like NTILE), I would use the Data Movement optimization to transfer the data to a database that supports NTILE function. Refer the documentation for the [workaround](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#workaround-to-execute-analytic-functions). For more details, you may refer to Q&A [here](https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&title=When+will+Denodo+support+analytic+functions+%28i.e.+RANK%2C+NTILE%2C+PARTITION+BY....%29%3F). Hope this helps!
Denodo Team
11-05-2020 00:03:55 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here