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

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Unable to create a new jdbc hive2 data source
answered 20-11-2017 05:26:12 -0500

Attempting to create a new jdbc hive data source in the Denodo OVDAS database. Could you please assist Database adapter: Hive 0.12.0 (HiveServer2) URI: jdbc:hive2://i-565853a0.aws.amgen.com:10000/default;principal=hive/i-565853a0.aws.amgen.com@HADOOP....

Answers: 1

Hive JDBC

Date Format issue in Denodo
answered 20-11-2017 02:46:23 -0500

Hi Team, Thanks for your support here, I have a one date column...dateapplicatonaccepted. ..it would be data format in DB and I am bringing into Denodo and it was populating as below. Tue Apr 21 00:00:00 EDT 2015 Thu Jan 01 00:00:00 EST 2015 Mon Apr 20...

Answers: 4

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

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