Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions can i install denodo with postgresql version 16 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 using an expression in Denodo 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 Data Movement Proving 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 JDBC Connection Error - #sql6631_3dd5e99_1a' is full 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 Alter view on a different database in scheduler job 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 Problems with Cloud Storage and Denodo â?? Any Advice? https://community.denodo.com/answers/question/details?questionId=906Qj00000Jgc2kIAB&title=Problems+with+Cloud+Storage+and+Denodo+%C3%A2%E2%82%AC%E2%80%9C+Any+Advice%3F Hello everyone, I'm currently facing challenges with cloud storage when integrating it with the Denodo platform. The primary issues revolve around data accessibility, performance bottlenecks, and synchronization between the cloud storage and Denodo. Specifically, I would like to know: Performance Tuning: What configurations or best practices can be applied to enhance performance when using Denodo with cloud storage? Data Accessibility: How can I ensure smooth and quick access to data stored in the cloud while using Denodo? Are there particular setups or approaches that help in this regard? Synchronization Issues: What steps can I take to address any potential synchronization problems between Denodo and the cloud storage? Are there tools or methods that can help streamline this process? Integration Strategies: Are there recommended strategies or industry best practices for effectively integrating Denodo with cloud storage solutions? I would greatly appreciate any insights, tips, or experiences that others have had with Denodo in a [cloud storage](https://www.lenovo.com/gb/en/d/cloud-storage/) context. Your advice will be invaluable in helping me resolve these challenges! Thank you! Thu, 26 Sep 2024 08:32:45 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Jgc2kIAB&title=Problems+with+Cloud+Storage+and+Denodo+%C3%A2%E2%82%AC%E2%80%9C+Any+Advice%3F 2024-09-26T08:32:45Z typos and errors in systemd scripts https://community.denodo.com/answers/question/details?questionId=906Qj00000JdJkdIAF&title=typos+and+errors+in+systemd+scripts Hi, I noticed some typos and errors in the vqlserver script for systemd: * DENODO_SERVICE="DENODO_APP=Denodo VDP Server" should be DENODO_SERVICE="Denodo VDP Server" without DENODO_APP= * DENODO_PID_CHECK_PATTERN=ââ?¬ï¿½DENODO_APP=Denodo VDP Serverââ?¬ï¿½ should be DENODO_PID_CHECK_PATTERN="DENODO_APP=Denodo VDP Server" please, notice the character for double quotes * if [[ -n "$pid" ]] && [[ -r /proc/$pid/cmdline ]] && xargs -0 printf '%s\n' < /proc/$pid/cmdline | /bin/grep -q "$DENODO_PID_CHECK_PATTERN"; then should be if [[ -n "$pid" ]] && [[ -r /proc/$pid/cmdline ]] && xargs -0 printf '%s\n' < /proc/$pidf/cmdline | /bin/grep -q "$DENODO_PID_CHECK_PATTERN"; then also inside schedulerserver and schedulerindexserver Thanks to the author of the scripts for his useful work and Best regards Wed, 25 Sep 2024 16:29:18 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JdJkdIAF&title=typos+and+errors+in+systemd+scripts 2024-09-25T16:29:18Z PBI - Refresh error message https://community.denodo.com/answers/question/details?questionId=906Qj00000JaMByIAN&title=PBI+-+Refresh+error+message i got an error message when using PBI to refresh a report. This is the first time trying this. I used my usual company email and sign-on password, which i hope is the same password for Denodo at this company. However, it appears that it might be access to specfic databases. i got an error message when using PBI to refresh a report. This is the first time trying this. I used my usual email and sign-on password, which i hope is the same password for Denodo. error 1: fv_std_insurance_dp_counterparty ODBC: ERROR [08001] could not transalte host name "den9001-vm.XXX.ca" to address: Unknown host. where XXX is my comany name. (how do i copy in a screenshot in jpg ?) Tue, 24 Sep 2024 19:35:19 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JaMByIAN&title=PBI+-+Refresh+error+message 2024-09-24T19:35:19Z Advancement Operations Data Services https://community.denodo.com/answers/question/details?questionId=906Qj00000JZZPmIAP&title=Advancement+Operations+Data+Services Is a tag a relabel in Denodo? If so, can a column be easily renamed? Tue, 24 Sep 2024 17:45:10 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JZZPmIAP&title=Advancement+Operations+Data+Services 2024-09-24T17:45:10Z How to prove Query Optimizations efficiency https://community.denodo.com/answers/question/details?questionId=906Qj00000JXpIaIAL&title=How+to+prove+Query+Optimizations+efficiency How can i prove the various query optimization configurations efficiency. Selecting and unselecting any of the 4 below does not change the original query. I know that the documentation has the explanation of the query optimizations, but how can I prove it in the Denodo Design Studio. * Automatic cost-based optimization * Automatic simplification of queries * Use summaries for query acceleration * Data movement Tue, 24 Sep 2024 08:20:54 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000JXpIaIAL&title=How+to+prove+Query+Optimizations+efficiency 2024-09-24T08:20:54Z