Latest Activity
Currently running Denodo 8 and using some views connected to a Postgres 12.9 database. I found that when running a query with an analytical function sum() and a REGEXP_LIKE function, causes the following error: Finished with error: Error executing vi...
<Reference> https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F <Denodo VDP Version> 6.0 Administration tool:...
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 suggesti...
Hi, I am trying to use the analytic function in my derived view in VDP. but it did not recognize the functions and getting errors. (tried all the analtic functions , I got the same errror.. see attached the error detail hyperlink) rank() OVER (PARTITI...
Hi team! I'm facing a common scenario using the Rank function and need some help. Below is the sentence I'm using, basicaly a Rank function with a Partition and Order by conditions: rank() OVER ( PARTITION BY xx_fa_deprn_summary.asset_id, xx_fa_deprn...