Latest Activity

code

Handler Section

In the Handler section there is a check box in the “When to send:” previously “the number of exported documents is less than: “. Can some please define what this is? If I set it to 0 I dont get an email for COMPLETE, but when I set it to 1 an e-mail al...

code

Authentication error: The username or password is incorrect

Hi, For following components Denodo 8.0 java 11.0 mac OS 12.1 installation worked and sucessful. Virtual Dataport server running successfully on port 9999. Virtual admin tool lanched successfully. But when i put credentials as admin/admin and URI a...

code

Denodo MPP

I want a sample document for getting MPP done in denodo with PrestoDB or Impala.Configure MPP Query Acceleration in Denodo.

MPP
code

timestamp to date

Hi Team, How to convert timestamp to date ? from: 2022-02-17 09:23:13 to: 2022-02-17 Denodo 7.0 update 20210224 Thanks.

code

Denodo alerts when server is in hang state and is not responding

I know we can put email alerts in denodo. But is it possible for scenario where the server is not responding and in hang state, to receive alerts.???

code

Integration of a Json file with a special structure

Hello all, I currently have the problem that a json file cannot be read correctly into Denodo. No data is displayed here, see image 1. With other Json files this works perfectly. I used tuple root as "TUPLEROOT = /JSONFile/JSONArray". Attached is the...

code

Rank over a union view

Hi, we are using denodo version 8 and have been trying to implement the rank function. The delegate analytical function has been specified on the datsource. We are facing the below issue. 1.We have two seperate views which we union. 2.The unioned view ...

code

Isnull

How to use isnull in denodo? provide the solution with example

code

Connect of ADLSv2 with Dendod Docker Container. Error while creating the Base View.

Hi Team, I have tried placing the core-site.xml inside the denodo docker container which is running on a Azure VM. I have established a connection between ADLSv2 container with denodo docker container. When I try to test connection the connection is ...

code

Lag() function used together with Group By

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...