Q&A

Build and release process for denodo / CICD process for denodo
answered 16-03-2022 07:23:54 -0400

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

Answers: 1

pipelines buildtools cicd

Query timeout while loading the cache
answered 16-03-2022 06:29:55 -0400

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

Answers: 1

Can Case be used with Join conditions.
answered 15-03-2022 08:56:50 -0400

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

Answers: 3

Connect to embedded Denodo database (Apache Derby) using REST API (required metadata view_custom_property.json, localviews.json).
answered 15-03-2022 08:29:04 -0400

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

Answers: 5

#Export_metadata JSON Denodo Rest API

How to connect ADLSv2 container with Denodo docker container running on a Azure VM.
answered 15-03-2022 08:11:54 -0400

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

Answers: 1

Docker DENODO Azure Data Lake Storage Gen2

JDBC jar file import error
answered 14-03-2022 10:37:21 -0400

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

Answers: 1

REST API - Expression in group by resulting Error
answered 14-03-2022 09:13:08 -0400

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

Answers: 3

Get error when Joining 2 files
answered 14-03-2022 09:10:46 -0400

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

Answers: 1

How to use variables
answered 14-03-2022 09:05:59 -0400

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

Answers: 1

variables

lab
answered 14-03-2022 07:31:58 -0400

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

Answers: 1