Home / Q&A / All Questions

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.

Cache Load Question
answered 10-02-2020 07:49:05 -0500

Source Database: DB2 I have a view say top_level_view, which takes a long time to query and aggregate from the DB2 database. We decided to cache this view with a where clause for 15K keyids. To begin with we tried to run the view without caching to se...

Answers: 1

Full Cache Cache

Date Range error
answered 10-02-2020 05:55:55 -0500

Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...

Answers: 1

Create Base View

Date Range parameter doesn't accept date
answered 10-02-2020 05:50:58 -0500

Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...

Answers: 1

Delimited file data source Create Base View delimited file sources rows columns pattern tupple

GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()
answered 07-02-2020 20:22:19 -0500

Hey, There is a stored procedure to generate vql to create base view for jdbc sources - GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW() but is there a option i can generate vql for otehr datasource. I.e json, csv, custom, etc

Answers: 1

Create Base View JSON Delimited Files

Denodo Union / Sort Merge Performance Issue
answered 07-02-2020 18:46:56 -0500

I currently have two derived views, say D1 and D2, that are unioned together to create D3. I originally had an issue with both D1 and D2 which involved a sort merge. Both D1 and D2 are a join of two base views; each ran very well when I had a date fil...

Answers: 1

performance sort merge UNION

Accessibility with screen reader
answered 07-02-2020 07:10:32 -0500

Hello. I'm blind and use JAWS 18.0 (screen reader). I installed Denodo Platform 6.0, but I can't interact with it. Is there a package to install, which makes Denodo Platform 6.0 accessible? System information: OS Name Microsoft Windows 10 Enterpri...

Answers: 1

blind Accessibility JAWS 18.0

Error using Context in a Stored Procedure
answered 07-02-2020 07:08:23 -0500

Virtual DataPort v7.0 update 20190312 I try to use Java Scheduler API into a stored procedure to grant access to training user in the scheduler. When i run my code in Eclipse debug, everything goes well. But when i import the store proc into VDP and r...

Answers: 1

Denodo Scheduler 7.0

Error using Context into a Stored Procedure
answered 07-02-2020 07:03:25 -0500

Virtual DataPort v7.0 update 20190312 I try to use Java Scheduler API into a stored procedure to grant access to training user in the scheduler. When i run my code in Eclipse debug, everything goes well. But when i import the store proc into VDP and r...

Answers: 1

Denodo Scheduler 7.0

CustomWrapper returns 0 records when the file has additional column headers
answered 06-02-2020 12:58:56 -0500

Hi We've written a basic custom wrapper to read a text file and export to a table. The scheduled job to call the wrapper has been working pefectly for many months, however a change was made to append some additional columns to the file without our kno...

Answers: 3

Joining two tables
answered 06-02-2020 12:53:28 -0500

We are using Denodo Platform 7.0 I have question that in denodo how we join one column from a table and that column is lying within the range i.e minimum and maximum of columns in the second table . Ex : A is a column in table 1 and in table 2 we have ...

Answers: 1