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.

Reading from Kafka
answered 19-04-2018 00:13:44 -0400

We are valuing tools to catalogue assets from streaming data sets as Kafka. Could be a solution this architecture?: Kafka - PrestoDB - Denodo catalogue I have seen in the whitepaper that Denodo 7.0 can read effectively Kafka messages. Could you kind...

Answers: 1

denodo vsql
answered 18-04-2018 11:46:34 -0400

How Can i query the real datatype of derived view ? as querying catalog it shows timestamp and varchar2 but in real those are date and text.

Answers: 1

Error removing JAR: Error loading User(XXXXXX)
answered 18-04-2018 07:59:45 -0400

Hi, I used the custom policy code provided in samples and added a user check and query contains check. Now i cannot delete the jar from jar management and get errors. Error removing JAR: Error loading User(XXXXXX) What is the solution for this? Than...

Answers: 2

custom policy Denodo 6.0

Denodo 7.0 JDBC client-drivers does ot contain a class...
answered 18-04-2018 02:54:09 -0400

Hi, Adding the Denodo JDBC client driver (<DENODO_HOME>/tools/client-drivers/jdbc/vdp-jdbcdriver-core/denodo-vdp-jdbcdriver.jar) in DB Solo (same with DbVisualizer) is failling with a message about a missing class. Ex: DB Solo 5.0.2 error: Jar f...

Answers: 1

JDBC

sequence in denodo
answered 18-04-2018 01:51:28 -0400

HI, Can i create a sequence in VQL or can i used nextval and increment a sequence in VQL. Regards Salman Khan

Answers: 1

sequence

OutofMemory java heap space
answered 17-04-2018 12:14:12 -0400

Hi Team, While am try to login into VDP am unable to login, am getting error OutofMemory java heap space. Please help me onthis issue.

Answers: 1

Denodo Training - Derived Views
answered 17-04-2018 11:45:29 -0400

Hello, I am taking the Denodo Training and i am stuck creating a derived view. Data Virtualization Developer Introduction - DEN60EDU0118LAB01 I do not understand how to convert parameters into a simple field.

Answers: 2

training derived view

Function row_number is not executable
answered 17-04-2018 10:27:20 -0400

I have the following query against Oracle 11g: select ROW_NUMBER() OVER (PARTITION BY part_id ORDER BY part_cost ) rowwithpartition , part_cost from tablereport The view saves but when I try to run it I get: Finished with error: Error executing view...

Answers: 1

QUERY [VIRTUAL] [ERROR]
answered 17-04-2018 09:22:49 -0400

Hello everyone, When trying to run queries from Denodo (on DBeaver), I keep getting this error message: QUERY [VIRTUAL] [ERROR] SQL Error [50001] [HY000]: Error executing query. Even when I try to run very simple queries. Any idea what can be the ca...

Answers: 1

VQL for interface creation
answered 17-04-2018 09:16:38 -0400

On creating interfaces from derived views using denodo front end, I found that some decimal columns(in the derived view) were shown either as decimal or long datatype in the interface. I wish to create interfaces using vql script. Is it safe if I copy...

Answers: 2

Interface