Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Slf4j dependency conflict changing to "Insufficient resources to execute operation" when trying to connect Dremio as a JDBC datasource
answered 04-04-2019 07:04:38 -0400

Hi, I'm currently running Denodo Platform v7.0 on Windows. I'm attempting to connect Dremio as a JDBC datasource and running into errors when testing the connection. I have added the Dremio JDBC driver .jar file to a new directory in the {DENODO HOME...

Answers: 3

JDBC JDBC Data Sources

denodo express install issue
answered 04-04-2019 05:16:53 -0400

after i installed denodo express on linux and execute denodo_platform.sh, it is returning null on the command prompt. I am not able to open Denodo Platform Control Center. please advice.

Answers: 1

Get refreshed current state Job Information using the Denodo Scheduler Client API
answered 04-04-2019 04:26:30 -0400

In my Java Application, I trigger a Denodo Scheduler Job using the Scheduler Manager Factory, and on the Scheduler WebAdmin I can see that the Job got triggered, and the state changes from NOT_RUNNING to RUNNING. However,the belowschedulerManager.getJ...

Answers: 3

java java code

Analytic function row_number() is not executable when executing it over a subquery
answered 04-04-2019 02:24:01 -0400

Inspite of enabling the Delegate Analytic functions list in source configuration of a Oracle data source the below query is failing with error "Function row_number is not executable". select Department_id, total_sal, row_number() over(partition by 1 o...

Answers: 1

concatenate rows - same column
answered 04-04-2019 02:03:20 -0400

Hello, I am trying to concatenate data from the same column but on different rows for the same record. The column in question is one that contains notes and what I need to do is combine notes. Below is an example of what I am looking to do. TABLE ID S...

Answers: 4

concatenate

VQL issue
answered 03-04-2019 10:18:46 -0400

I have an issue with vql, whenever i am exporting and importing existing views are not replacing. suppose if i have folder A having 4 views and folder B having 3 views in Test-Environment when i am importing vql from QA environment with updated vales ...

Answers: 3

I can´t access to scheduller
answered 03-04-2019 08:23:34 -0400

I can´t access to scheduler. I installed denodo, started all servers and scheduler administration tool and when I try to login using admin/admin I get a connection error

Answers: 1

Denodo Scheduler 7.0

How to get result in array or registered ?
answered 02-04-2019 10:31:13 -0400

SELECT xpath ( cast ('xml', '<?xml version="1.0" encoding="ISO-8859-1"?> <a> <b>Hello</b> <b>World</b> </a>' ) , '/a/b/text()', false) as xpath_results FROM Dual(); The result is xpath_results HelloWorld ...

Answers: 2

XPATH XML

Connect to Denodo with C# via Npgsql
answered 02-04-2019 08:21:09 -0400

Good Morning, I am trying to connect via C# to Denodo. My connection string is ssl encrypted. Code is running in catch-branch by connection open. The following message is given: {"Received unexpected backend message ParseComplete. Please file a bug."...

Answers: 1

C# Received unexpected backend message Npgsql

Access to Derived Views from Mysql or Postgres
answered 02-04-2019 08:18:09 -0400

I have created some derived views and I need to read the data from those views and process the data and save it in an external database (Mysql, postbres), in a custom table. How you could do that? Or is possible to publish the information that I get fr...

Answers: 1

external Database PostgreSQL MySQL