Latest Activity

code

Complex filtering on blocks with labels

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

code

What is a Scheduler Job misfire?

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

code

Denodo in Automated Release cycle

We are evaluating Denodo for one of our prestigous client. There are few queries which we have, if you can let me know the response. Wrt Testing, we want to compare Denodo Testing Tool vs SoapUI / Postman. Can you let us know the pros and cons of ...

code

Build and release process for denodo / CICD process for denodo

we are doing POC on cicd/pipeline process for denodo(.vql extensions). someone please help with build and release and stages involved.

code

Query timeout while loading the cache

Hi Team, When caching the data set we are getting query time out. And it is timing out around 30min or so. Query timeout under Tools--> Connections--?set as 33.33 min (2000000 millisec). We are not sure if this setting is affecting the caching? An...

code

Can Case be used with Join conditions.

I am using a code where after using the left outer join i need to add case statement, but I am gettig error while using it. For example:- SELECT * FROM sys.indexes i JOIN sys.partitions p ON i.index_id = p.index_id JOIN sys.allocation_units a ON CASE W...

code

Connect to embedded Denodo database (Apache Derby) using REST API (required metadata view_custom_property.json, localviews.json).

Hello all, I would like to connect to the "live data" of the files view_custom_property.json and localviews.json. And afterwards I would like to create these as a base view. Unfortunately I can't find the right schema to access it via REST API: ...

code

How to connect ADLSv2 container with Denodo docker container running on a Azure VM.

How to connect ADLSv2 container with Denodo docker container running on a Azure VM.

code

JDBC jar file import error

HI there I am trying to import the jdbc jar file in denodo but after the import is completed i am getting errors .![https://drive.google.com/file/d/1Tii-FIxulTdxkmAKSNm3WBCeRzILngyC/view?usp=sharing]. I have attached a screenshot of the error. kindly d...

code

REST API - Expression in group by resulting Error

Hello team, I am working on REST API and forming my query dynamically. Query is forming correctly but I am facing error while it tries to evaluate expression present in GroupBy clause. It say such column does not exists. Below is the sample query and ...