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 April 2018.

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

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 MPP Configuration guidelines (engine and memory)
answered 12-06-2018 04:43:16 -0400

In the Denodo MPP guidelines https://community.denodo.com/kb/view/document/MPP%20Query%20Acceleration:%20Sizing%20guidelines?category=Performance+%26+Optimization it is stated that for Impala the recommendation is to use 16 nodes with each 32GB memory....

Answers: 1

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

How to update admin pwd in Solution manager
answered 11-06-2018 13:35:19 -0400

How to update defualt admin pwd in Solution manager?

Answers: 1

solution manager install

Reg: About Denodo Tool:-
answered 11-06-2018 08:34:06 -0400

Hi Team. Good morning!!! I have a quick question Reg : Denodo Tool. So far I have been doing different type of scenarios in Denodo Tool whatever I did in sql before. But I didn't understand Why Denodo is called ETL Tool. Coz it has all sql functions ...

Answers: 1

REST Service query - select newest date row
answered 11-06-2018 08:33:23 -0400

We are using Denodo 6.0 on Windows 10 Desktop. We have a question about querying REST web service to narrow down multiple rows to a single row based on a date column. What would be the syntax in the query? In the following example, we'd like to get the...

Answers: 3

Filter Denodo Testing Tool REST Webservice

Allow Denodo Platfrom againt Firewall
answered 08-06-2018 07:41:08 -0400

I have published a REST Service using Denodo Express installed on a cloud server. I am able to access the webservice using web localhost:9090. But I am unable to access the REST service from my desktop using the web URL servername:9090. I have done the...

Answers: 1

Target
answered 07-06-2018 11:37:40 -0400

Hi Experts, I am new in denodo 1.can we replicate the data from excel to SQL. 2.Can we use any sources & any targets

Answers: 1

Data Source