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.

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

How to create base view on Bex query having range as a selection
answered 26-03-2020 01:54:10 -0400

Hello Team, We have a scenario where we are consuming Bex query having range selection to design base view. Let say we want to have data from 03.2019 till 03.2020. In that case we have to add 12 times the same field and give diferent months. Even if w...

Answers: 3

Create view from the predefined Denodo stored procedures
answered 25-03-2020 12:48:30 -0400

How do you create a base view from the predefined/out-of-the-box Denodo stored procedures? I do not see them listed in the element tree although I am able to return results as well as list the procedures via the VQL shell query.

Answers: 3

Denodo stored procedure

Quoting columns that are keywords or start with digits
answered 25-03-2020 10:41:10 -0400

I'm trying to run the following query against a virtualized Postgres database via JDBC SELECT "fielding" . "gs" AS "gs" FROM "data_world_gosales" . "fielding" AS "fielding" I get an error Field not found 'fielding.gs' in view 'fielding' . Other field...

Answers: 1

View parameter : function as Default Value
answered 25-03-2020 10:40:00 -0400

Hi, putting View Parameters in a Derived View, can I specify a function result as Default Value. e.g. Getyear(date) => any specific syntax needed ? Thanks

Answers: 1

view parameter default value

Write back data from Excel source to Oracle db using Denodo
answered 25-03-2020 09:48:27 -0400

Hi, I have data that gets generated in excel and I would like to insert this data everytime it is generated into a Oracle DB using denodo. Is this possible in denodo?If yes how can it be done. Thanks & Regards, Nisarg Shah

Answers: 2