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

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 exec...

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', 'qu...

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 ca...

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 acc...

Answers: 3

Role and User Management

Query Permissions by Object
answered 15-11-2017 02:32:50 -0500

Is there a way to query Denodo's catalog to return a list of roles or users who have permissions on an object?

Answers: 2

VQL Views Permissions

Same wrapper is being assigned
answered 14-11-2017 11:36:44 -0500

Hi Experts, I have table which is available in multiple sources (I mean exact same name in different db's), I noticed same wrapper is being used for both the tables. Is there a way to avoid happening this ? and what are all downsides with this ? Tha...

Answers: 6

Wrapper

'redirect_uri_mismatch' error
answered 14-11-2017 11:00:29 -0500

After clicking on "Generate the authentication URL" I am getting an 'redirect_uri_mismatch' error. I am leaving redirect_uri as default. Is the problem because of that?

Answers: 6
Related to: How To Integrate the Google Drive API in Denodo

oauth Google Drive API redirect_uri_mismatch

Denodo base views not accessible
answered 14-11-2017 04:30:51 -0500

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Answers: 1

Missing Base view

Views not accessible
answered 14-11-2017 04:27:26 -0500

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Answers: 1

Missing Base view

Denodo DataSource Class
answered 10-11-2017 14:41:29 -0500

We are trying to connect to Denodo through a JDBC client. What is the data source class name that should be used to connect ?

Answers: 2