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

Need to know the changes made by someone at DS Scheduler level
answered 22-11-2017 03:50:07 -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 privil...

Answers: 1

Query for DATASOURCENAME of a base view
answered 21-11-2017 23:29:40 -0500

How can I retreive the DATASOURCENAME for a single base view, multiple base views and/orall dependent base views of an interface? I am currently running "desc vql view <view_name>" which returns the entire VQL. Is there a way to return only the D...

Answers: 1

Joining JDBC and ODBC base views, fail execution (ODBC error)
answered 21-11-2017 06:35:18 -0500

I am doing the first course of the Denodo Developer Certification. I am trying to join (inner join, any type of join method) bv_wo_customer table, from an Oracle-JDBC based source, with bb_cc_service_call, from an MS Access-ODBC based source, by commo...

Answers: 1

ODBC Access JDBC join

Denodo order by issue when partial cache enabled.
answered 21-11-2017 06:33:14 -0500

Hello, guys. I faced with the weird issue when enabling denodo cache (partial mode) in the following case: Created two tables in MS SQL Server and imported it to Denodo: create table dbo.Denodo_Bug_View1 ( ColumnId bigint not null identity(1...

Answers: 1

Partial cache order by

Sharepoint Online
answered 21-11-2017 05:30:31 -0500

Can I upload the files to Sharepoint Online using the denodo

Answers: 1

Sharepoint

Denodo - Simba driver fails to push down the right query to Hive when joining two derived views
answered 20-11-2017 07:38:01 -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: 1

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