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 updated version of the Denodo Express 6.0 with new features and fixed issues starting in November 2017.

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 6.0 at the Express home page in the Denodo Community

Denodo - Simba driver fails to push down the right query to Hive when joining two derived views
asked 17-11-2017 08:06:31 -0500

Hi, I'm trying to have a derived view which contains inner join of three tables join with another derived view on one condition. When I run this query, Simba is failing to push down the right query to Hive. eg: DV1 - Table A inner join Table B inner jo...

Answers: 0

Need your help on the below error & How to fix it.
answered 17-11-2017 07:43:55 -0500

117026310 [Cache_dv_activity_payment_request_630 (My Payments).DenodoSched_Worker-1] ERROR 2017-11-15T19:29:42.130 com.denodo.scheduler.core.job.BaseJob [Cache_dv_activity_payment_request_630 (My Payments).DenodoSched_Worker-1] - Exception executing jo...

Answers: 1

Restricting Import access to users with Connect and Read privileges
answered 17-11-2017 06:47:48 -0500

It appears that users with the connect and read access also have rights to import VQLs into denodo and we want to determine a way to limit access to truly be read only and not allow any changes from accounts that have read access. Is this possible?

Answers: 1

VDP import Access account

export job from one project and import it to another project
answered 17-11-2017 06:13:03 -0500

Hi Team, Can this be achieved. Please guide. Importing / Copying / Cloning a Job, say, "Job1" from Project, say, "P1" to Project, say, "P2" as Job, say, "Job2" Or, the option I see is manually modifying the exported xml and other files. Thanks.

Answers: 1

denodo scheduler

Error gathering the statistics of the view
answered 17-11-2017 06:11:37 -0500

Hi Team, I am getting the below error while trying to gather statistics for a derived view. This derived view is created from 3 derived view and 3 db tables. Could you please help? Error messages Error gathering the statistics of the view: Error execut...

Answers: 1

Gather Statistics

Load a SAS-Table in the Cache
answered 17-11-2017 04:27:49 -0500

I want to load a SAS-Table in the Cache: select * from sas_table CONTEXT ('i18n'='de_euro', 'cache_preload'='true', 'cache_invalidate'='all_rows', 'cache_wait_for_load'='true', 'cache_return_query_results'='false', 'cache_atomic_operation'='false',...

Answers: 1

Setting Hive parameter configuration in the query
answered 17-11-2017 03:15:42 -0500

Hi, We need more memory for some of our queries. The below commands was needed for hive: SET mapreduce.map.memory.mb=5120; SET mapreduce.map.java.opts=-Xmx4096M; SET mapreduce.reduce.memory.mb=8192; SET mapreduce.reduce.java.opts=-Xmx6554M; How can we...

Answers: 1

Hive

Functionality of allusers role?
answered 16-11-2017 08:31:52 -0500

We are currently using VDP V6.0.20170220. As a local schema admin (not server admin), I would like to leverage the allusers role to grant security to connect to my schema, read from certain views, etc. to all LDAP users in situations where the data ac...

Answers: 3

Role and User Management

Need to know the changes made by someone at DS Scheduler level
asked 16-11-2017 06:50:09 -0500

HI Denodo Team Scheduler job got failed with below error. Updated right password & it got succeded. Could you pls know how can we find out the changes made by someone from the logs. dataSource 'DS_TEST'. authentication error: Insufficient privileges to...

Answers: 0

data source connection string information
answered 16-11-2017 05:31:18 -0500

Hi, Is there a view in Denodo which could tell me the connection url configured against each data source ?

Answers: 8