Q&A

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

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

XSLT Stored procedure
answered 25-03-2020 06:14:26 -0400

Hello, I have been trying to use XSLT stored procedure following the examples in the documentation with no success. Here is a try that returns null : SELECT XSLT( ' <shop> <products> <product> <id>1</id> <name>Vi...

Answers: 1