Hi, we are currently running VDP 7 20210818. The query can be delegated to an SQL Server. I try to use the Lag() function in a Group by VQL clause. Select lag(a.activity_id) over (partition by a.patient_id order by max(a.startdatetime)) as prev_activ...
Answers:
1
denodo 8: VQL Option Display rows: seems to be that the max value there is 1000. is it possible to force to display all rows (enabling also retrieve all rows)?
Answers:
1
Hi there, I am trying to use sqlalchemy with denodo but I am running into a few issues. I have the dialect added as per the instructions from your sqlalchemy dialects page, and I can parse the connection string it seems. However, whenever I create a c...
Answers:
2
HI, i've set a JSON source for the API https://www.openfigi.com/api, with a parameter in POST body. CREATE DATASOURCE JSON ds_openfigi FOLDER = '/01-connectivity/01-data-sources/openfigi' ROUTE HTTP 'http.CommonsHttpClientConnection,120000' POST 'http...
Answers:
1
Total Number of Users on platform Total number of objects created on daily basis How do I query and get the above information using catalog queries? Thanks
Answers:
3
We are unning into problems while loading native libraries and JARs. logger.debug("VOLT: build context - policyUrl: " + policyUrl); logger.debug("VOLT: build context - trustStoreDir: " + trustStoreDirectory); logger.debug("VOLT: build context - vibeS...
Answers:
1
Do we have to use admin account to login to solution manager,? is there a role or something similar to grant to indivisual id, so indivisual can login with his credentials. we dont want to use admin account to login to solution manager
Answers:
1
Hi. I am getting a SQL Error [1100]: Syntax error: Exception parsing query near '*'. Can someone show me how to properly code the below. I am trying to aggregate this to one record per key. With V5035_C12_POL_CT as (SELECT ROUTINE2.AGENT ,ROUTINE2.POL...
Answers:
1
Hello, I am creating an app where teachers can search for resources. Each resource is tagged with topics which are used to flter results. I have a complex use case and am looking for some advice For example: Resource 1 is tagged with topic "Math...
Answers:
1
The only documentation I can find regarding the word misfire is located in the Denodo job Handler section. https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/handler_section Can ...
Answers:
3