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.

GC overhead limit exceeded.
answered 14-06-2018 08:09:30 -0400

I'm trying to run Cache pre load for a base view with record count of 6221760. I'm getting the below erro. I tried changing the memory settings but no luck. Please suggest. "Finished with error: java.lang.OutOfMemoryError: GC overhead limit exceeded"

Answers: 3

Garbage Collector

how to present the received data from REST webservice
answered 14-06-2018 07:45:08 -0400

Hi there, First of all, I'm a newbie with Denodo, but I am experimenting a lot these days. We are using Denodo 7.0 and want to retrieve data from an rest-webservice. I'am to create the webservice call by using an XML datasource. Within the configura...

Answers: 3

S3-Athena connection
answered 13-06-2018 10:44:47 -0400

Hello Denodo Community, Please provide step by step connection/configuration procedure in getting data from AWS S3 Athena. Apologies for pressing a bit but this is needed urgently. Kindly revert back soonest for us to explore alternatives. Thank you.

Answers: 1

AWS S3 Athena

How to export the results using list command
answered 13-06-2018 07:19:47 -0400

How can we export the result of the below commands in VQL shell list functions list users list roles list databases

Answers: 1

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?
answered 12-06-2018 12:50:33 -0400

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Answers: 1

Parameterize slow query Parameter derived view Tableau

Denodo Model Bridge --> add-on license?
answered 12-06-2018 12:11:02 -0400

Hello, Does using Denodo Model Bridge require an add-on cost license? or is it available as a free tool with the existing Denodo license.

Answers: 1

Denodo Model Bridge

Partial Cache not working
answered 12-06-2018 09:20:31 -0400

I have created a derived view ('client') on the top of a Excel and partial cache mode is on. Now I am trying to check how partial cache works.Initially I have around 10 rows. I have also created a base view on the top of cache database. I am executing ...

Answers: 2

Partial cache with different where conditions Cache

Denodo Scheduler jobs Export issues
answered 12-06-2018 04:25:53 -0400

Hi Team, need your help on below question. I have a project name Its_dev under this project, we have few jobs like Project name: lts_dev(under this project, we have few jobs) job name 1: ABC Job name 2: CDE when i deployed first time into Prod environm...

Answers: 1

How to drop and re-create indexes, when updating Cache using BULK LOAD API nightly via scheduler
answered 12-06-2018 04:24:51 -0400

Hi, We have a scheduelr that updates the cahce of a very very large table around 120 million records on nighlty basis, using BULK LOAD API. With BULK load it expects to drop and recreate indexes, how do we achive this??

Answers: 1
Related to: Cache database size estimate

Cahce Index

VQL to Find List of Users that Belong to a Denodo Role
answered 11-06-2018 18:00:49 -0400

Denodo VDP 6.0 Hi, Can you please let me know a VQL query to find the list of users that belong to a role? I want to write a shell script with embedded VQL that will find the users in a role and add / remove members to the role. Regards, Subrata

Answers: 1

Roles Users