Latest Activity

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

code

Get error when Joining 2 files

When I try to join the 2 files below, I get the below error. SQL Error [50001] [HY000]: Error executing query. Total time 1.632 seconds. QUERY [PROJECTION] [ERROR] QUERY [SELECTION] [ERROR] QUERY [PROJECTION] [ERROR] QUERY [PROJECTION] [ERROR] QUERY ...

code

How to use variables

I have a base view created using JDBC (data source sql) which has billions of rows and has the columns product_id, product_name, country and price. Also I'm having another DF file which has only 1 row and the columns are country and exchange rate. I h...

code

lab

for lab, i am trying to find The delimited files can be found at "http://data-server/files/df/" (replace data-server with the real name or IP address of your server if the host file has not been configured). i am replacing it by http://127.0.0.1:9090/f...