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

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.

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)
answered 30-03-2020 11:50:34 -0400

Hello Denodo Support Team, I understand that Denodo VQL supports TVFs (Table Value Functions) regarding the unpivoting of multiple columns in a view and joining to other sources. However, the most recent proposed solution for addressing the powerful UN...

Answers: 1

VQL unpivot cross apply

JDBC connection to R with the Denodo 6 version
answered 30-03-2020 09:35:31 -0400

In response to the below Answer, Regarding the RJDBC and rJava packages, can you please elaborate more on this. Are these packages to be installed in denodo VDP Server? Thanks Hi, RJDBC and rJAVA packages are only useful when you try to connect to ...

Answers: 1

Denodo 6.0 JDBC

Base view deployed even though table not present in database
answered 27-03-2020 12:22:06 -0400

Hello team, We are deploying a view created from A database from A environment to B environment. When deployed a view from A to B we found that the table was not present in the database B yet the view was deployed. we got to know that table was not pr...

Answers: 1

SolutionManager Invalid query in create base view from query Base view Deployment using Solution Manager Best Practice

Is it possible to connect to R with the Denodo 6 version?
answered 27-03-2020 08:51:55 -0400

I am trying to establish a connection to R from denodo 6. Would like to know the steps and where to get RJDBC and rJava packages to install? Appreciate your help! Thanks Krishna

Answers: 1

Denodo 6.0 JDBC

Denodo Data Catalog Unable to Query
answered 27-03-2020 06:49:51 -0400

Whenever I try to query a view from the Denodo Data Catalog, it gets stuck saying "loading query tab" which never goes away, keeping the data catalog from being usable. Is there any way to fix this, and how would I go about it? Thanks, and I really hop...

Answers: 3

data catalog

Great video...please keep it up for future updates!
answered 27-03-2020 05:01:46 -0400

Quick feedback that we really appreciate the effort put-in to produce this video. So nice to get a cursory (but firsthand) look at key features without having to skim through detailed release notes!

Answers: 1
Related to: Denodo Platform Enhancements - 7.0 Update 20200310

Query return error when execute it
answered 26-03-2020 10:30:47 -0400

I already have the denodo 7.0 version trial version, but the querry still take lot of time and return error.

Answers: 1

Querry execution return error
answered 26-03-2020 10:30:07 -0400

Hi I just strart testing denodo Sandbox free trial but when executing some querry its return error DataBriks.historical_store_sales Finished with error: Error executing query. Total time 92.279 seconds. HISTORICAL_STORE_SALES [BASE] [ERROR] HISTORICAL...

Answers: 1

Base view Create Base View

is anyone running Denodo in a VM on Mac Mojave?
answered 26-03-2020 05:28:22 -0400

Since Denodo isn't officially released on a Mac yet I was wondering whether someone has done so on a Mac using Parallels, VMware Fusion or VirtualBox? Thanks, Kevin\

Answers: 1

Custom Function With Annotation
answered 26-03-2020 03:33:03 -0400

Denodo : 7 Hi , I am trying the sample code from "Developing Custom Function with Annotation".Note that I only want to delegate to underlying database . My code looks like this : package com.denodo.vdp.demo.function.custom; import com.denodo.common.c...

Answers: 1