Latest Activity

code

How to multiply rows based on some numbers

Hello! I'm new to SQL world and Denodo community as well. What I'm trying to do is to multiply rows by month gap as below. I've been looking for this for hours.. Result 1 | User | Account | Product | Column D | Start Month | End Month | | XXX | Pau...

code

Moving Denodo Cache Database

Can we move Denodo Cache Database to another server without interrupting Denodo's operations?

code

Convert a number to an INTERVAL DAY TO SECOND

Hello, Is there any possibility to achieve in Denodo something similar to NUMTODSINTERVAL Oracle function? select NUMTODSINTERVAL(0.6, 'DAY') from dual; Thank you in advance!

code

Migrating tags to higher environments

How can we just explicitly migrate only tags to higher environments?

code

Check if Value in Array

Hi, I have to check if a string is a substring of a longer one. Trivially this would lead to INSTR which doesn't work in this particular case as some of the strings to look for are substrings of others (eg. 'abc', 'abcde', ...). The long string is deli...

code

(Additional Question) Is it possible to CUD (Insert/Update/Delete) in denodo query editor ?

Hi, You've answered like this https://community.denodo.com/answers/question/details?questionId=9064u000000wkIHAAY&title=Is+it+possible+to+CUD+%28Insert%2FUpdate%2FDelete%29+in+denodo+query+editor+%3F I'd tested CUD in Impala with Kudu Table. but...

code

Connection reset by peer - From log

Here we are having 1 functional account of519143, and part of onecdp_dev vdb, whenever we were trying to connect with VDP admin tool or web services, we were getting 1 error, and from the logs we extracted the error, can anyone help on this to understa...

code

Denodo connectivity with Grafana

Hi Team, We are to read Denodo data from Grafana. We have datasource postgresql configured in denodo where we have created base view on top of it. After creating data source in grafana as Denodo(postgresql) we are not getting data in the Grafana. Belo...

code

Result of LIST VIEWSTATSUMMARIES in GET_STATS_FOR_FIELD

Hi there I want to refresh the statistics (at the end via scheduler) for those views which have the stats enabled. The refresh can be done with the new GETSTATSFORFIELD like call GETSTATSFORFIELDS ( 'ATSOURCETHROUGHVDPONLY' ,'myDB' , 'myView' ,null, t...

code

Can we variabilize the connection string of jdbc and use to other query ?

Hello, I have some database ( more than 100 ) with different name but the same table name. I would like to have into my column after each base view created a database "unique id" on each base view. For my use case, I would like to union all my base ...