Latest Denodo community answered questions 2024-10-07T10:38:38Z 2024-10-07T10:38:38Z

Hi Denodo team, I have complted course of Denodo Essentials but I am failed in test so I need to reapprear for same course once again and pass the test so that I can apperar for remaining Denodo training. Please provide me solution for this issue. Thanks & Regards Vikas Thombre

2024-10-07T10:38:38Z 2024-10-05T12:09:32Z 2024-10-05T12:09:32Z

I would like to ask which version started supporting the "Developing a Custom Policy" feature. Additionally, is there a way to apply a Custom Policy to every view by default? Thanks.

2024-10-05T12:09:32Z 2024-10-04T22:11:18Z 2024-10-04T22:11:18Z

what is the equivallent of sql function HASHBYTES in denodo? cast(HASHBYTES('', 222) AS INT) i tried using hash function which gives me string values but i need numeric values. quick help will be appreciated.

2024-10-04T22:11:18Z 2024-10-03T13:16:46Z 2024-10-03T13:16:46Z

Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau

2024-10-03T13:16:46Z 2024-10-02T08:17:05Z 2024-10-02T08:17:05Z

Hi. I am trying to access this course https://community.denodo.com/training/course/8.0/Advanced%20Configuration%20of%20Denodo%20View. The course has expired however I wish to re-register. The option is not available to re-register for this course, only a link to Launch Course in LMS which does not work as it has expired. Please could you help? Thanks, Gareth

2024-10-02T08:17:05Z 2024-10-01T08:21:44Z 2024-10-01T08:21:44Z

can you confirm that i can install denodo entreprise 8 associated witt a postgres sql v 16 I cannot find a compatibility matrix with such detail thanks

2024-10-01T08:21:44Z 2024-09-28T06:00:28Z 2024-09-28T06:00:28Z

I'm trying to replicate this expression into Denodo : CASE WHEN SUBSTRN(FINANCIAL_ASSOCIATE_ID,1,7) = 'BS:BNK:' THEN SUBSTRN(FINANCIAL_ASSOCIATE_ID,8) ELSE SUBSTRN(FINANCIAL_ASSOCIATE_ID,4) END. Can someone help me with that? I started with this : subs('bv_db_dds_financial_associate."FINANCIAL_ASSOCIATE_ID"', 1, 7)

2024-09-28T06:00:28Z 2024-09-27T03:38:54Z 2024-09-27T03:38:54Z

Hi. So I tried the Data Movement Optimization however it doesn't seem to be that effective in optimizing CPU usage and spends more execution/ query time. Can help with the analysis? I used the DVD rental sample dataset | Attributes | With DM | Without DM | | ----------------------- | ------------ | ----------------- | | Execution Time | 445 ms | 57 ms | | CPU Time | 375 ms | 62 ms | | CPU Usage Avg | 8.42% | 13.84% | | Static Opt Time | 398 ms | 24 ms |

2024-09-27T03:38:54Z 2024-09-26T19:50:19Z 2024-09-26T19:50:19Z

Hi, I receive the error as following when running the view: [JDBC ROUTE] [ERROR] Received exception with message 'The table '/var/tmp/#sql6631_3dd5e99_1a' is full'. I connect Denodo to MySQL.Is that something wrong with MySQL database instead? Thanks.

2024-09-26T19:50:19Z 2024-09-26T12:42:09Z 2024-09-26T12:42:09Z

Hello, I'm trying to execute a dynamic alter view using the scheduler in order to simplify the updates of description in my different views. But i have an issue regarding the proper syntax of the "alter view". **this** = "alter view test_alterview_rp_audience_globale_mensuel (alter column annee add (DESCRIPTION = 'Annee de l''audience du site'))" **that** = "alter view test.test_alterview_rp_audience_globale_mensuel (alter column annee add (DESCRIPTION = 'Annee de l''audience du site'))" I work my database called 'test', when i execute **this** in the VQL Shell of the database it works fine. But when i execute it in the scheduler i have this error : "View 'test_alterview_rp_audience_globale_mensuel' not found" If i add 'test' in front of the name of the view like **that** it says this error : "Syntax error: Exception parsing query near '.'" ; which does not make sense since "select * from test.test_alterview_rp_audience_globale_mensuel" works fine. Is there a way to set the name of the database used in the VQL Shell with a command line ? (like use database ... or something else) Or is there a way to set the database in the "Extraction section" of the scheduler job ? I have not find any of these in the documents. Or if someone has another solution for me. Thanks

2024-09-26T12:42:09Z