https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions https://community.denodo.com/answers/question/details?questionId=906Qj00000KGmpyIAD&title=My+Denodo+Essentials+assessment+is+failed 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 Mon, 07 Oct 2024 10:38:38 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KGmpyIAD&title=My+Denodo+Essentials+assessment+is+failed 2024-10-07T10:38:38Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KDFwzIAH&title=Developing+a+Custom+Policy 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. Sat, 05 Oct 2024 12:09:32 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KDFwzIAH&title=Developing+a+Custom+Policy 2024-10-05T12:09:32Z https://community.denodo.com/answers/question/details?questionId=906Qj00000KC9QbIAL&title=Hashbytes+in+denodo 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. Fri, 04 Oct 2024 22:11:18 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KC9QbIAL&title=Hashbytes+in+denodo 2024-10-04T22:11:18Z https://community.denodo.com/answers/question/details?questionId=906Qj00000K6VP0IAN&title=Need+the+denodo-v80-update-20240926+compatibility+matrix+with+Power+Bi%2C+Alteryx%2C+Tableau Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau Thu, 03 Oct 2024 13:16:46 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000K6VP0IAN&title=Need+the+denodo-v80-update-20240926+compatibility+matrix+with+Power+Bi%2C+Alteryx%2C+Tableau 2024-10-03T13:16:46Z https://community.denodo.com/answers/question/details?questionId=906Qj00000K1S6nIAF&title=Re-register+for+expired+course 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 Wed, 02 Oct 2024 08:17:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000K1S6nIAF&title=Re-register+for+expired+course 2024-10-02T08:17:05Z https://community.denodo.com/answers/question/details?questionId=906Qj00000JwxftIAB&title=can+i+install+denodo+with+postgresql+version+16 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 Tue, 01 Oct 2024 08:21:44 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JwxftIAB&title=can+i+install+denodo+with+postgresql+version+16 2024-10-01T08:21:44Z https://community.denodo.com/answers/question/details?questionId=906Qj00000JoBRxIAN&title=using+an+expression+in+Denodo 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) Sat, 28 Sep 2024 06:00:28 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JoBRxIAN&title=using+an+expression+in+Denodo 2024-09-28T06:00:28Z https://community.denodo.com/answers/question/details?questionId=906Qj00000JkK8rIAF&title=Data+Movement+Proving 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 | Fri, 27 Sep 2024 03:38:54 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JkK8rIAF&title=Data+Movement+Proving 2024-09-27T03:38:54Z https://community.denodo.com/answers/question/details?questionId=906Qj00000Jj2fRIAR&title=JDBC+Connection+Error+-+%23sql6631_3dd5e99_1a%27+is+full 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. Thu, 26 Sep 2024 19:50:19 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Jj2fRIAR&title=JDBC+Connection+Error+-+%23sql6631_3dd5e99_1a%27+is+full 2024-09-26T19:50:19Z https://community.denodo.com/answers/question/details?questionId=906Qj00000Jh5SyIAJ&title=Alter+view+on+a+different+database+in+scheduler+job 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 Thu, 26 Sep 2024 12:42:09 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Jh5SyIAJ&title=Alter+view+on+a+different+database+in+scheduler+job 2024-09-26T12:42:09Z