Latest Activity

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

code

VQL Display rows

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)?

code

SQLAlchemy Denodo Connection Issues

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