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.

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

Scheduler extractor part is displaying all the views .
answered 06-02-2020 07:52:51 -0500

Hi, I was trying to create a new vdpcache job in scheduler 7.0. In the extractor section after selecting the database, still I see that when i select new load process I see all the views showing in the list. Although in the VDP i restricted the access...

Answers: 1

Denodo Scheduler 7.0

API for VQL or other management tasks
answered 06-02-2020 07:47:16 -0500

Is it possible to use an API (with REST or SQL) to create table, users and manage permissions ?

Answers: 1

API for VQL or other mangement tasks
answered 06-02-2020 07:46:07 -0500

Is it possible to use an API (with REST or SQL) to create table, users and manage permissions ?

Answers: 1

Converting timestampz to epoch time
answered 06-02-2020 07:43:50 -0500

Hi, I have seen previous enquiries about a function to convert to and from epoch time before. Are there any possibility that this function will be prioritized in future patches? The autogenerated column "expirationDate" uses epoch time for the expirat...

Answers: 1

Interpolation Variables Epoch time timestamp

Diagnostic & Monotoring Tool Query stuck
answered 06-02-2020 07:26:40 -0500

Hi, I have a query from 29 January supposedly running in Diagnostic & Monotoring Tool today is the 5th of February, even though the query doesn't really seem to be executing since the number of rows isn't going higher, the CPU usage seems to be at...

Answers: 1

Why can I not see any Revision Elements in SMAT ?
answered 06-02-2020 07:20:06 -0500

When using SMAT to create a new revision when I click on the Revision Element tab I dont get any elements displayed

Answers: 1