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 September 2019.

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 see views in Tableau
answered 29-06-2020 07:20:40 -0400

I am using denodoexpress version 7. I have made a successful connection through tableau..but i cannot see any tables under the database. What could be the reason? Also can i connect tableau with denodo express version?

Answers: 1

Authentification Error
answered 29-06-2020 06:58:49 -0400

I am unable to connect VDP tool, facing authentication error: Local authentification with domain not supported.

Answers: 1

Denodo active - passive HA env
answered 29-06-2020 06:40:49 -0400

Hi, We are using denodo 7 with latest update 20201003. We have got one production server which is in use but need to add another server to create active-passive HA scenario. Can you please explain the step by step process? will it require any downtim...

Answers: 1

Incremental Cache Stored Procedure times out after 80 seconds
answered 29-06-2020 06:16:49 -0400

We are running the incremental cache stored procedure to insert/update records since the @LASTCACHEREFRESH. The procedure continues to fail with a generic error 'Finished with error: ERROR executing query update of cache [Rows updated in cache: 0].'. ...

Answers: 2

Incremental Cache Cache

Metadata repository and cache repository on same derby instance or different ?
answered 29-06-2020 04:44:31 -0400

I understand Denodo uses Apache Derby (by default) to maintian caches, to maintain its own metadata and also to store metadata for diagnostic & monitoring tool. The question is, to store these three kinds of data, does it use the same instance of D...

Answers: 1

metadata repository

View with input parameters
answered 29-06-2020 03:49:06 -0400

Hello Team, Consider my scenario. So i have query something like this. WITH userdata AS ( SELECT id from user where user_name in (user_list) and user_status='Active' ), payment as( select * from payment where payment_status=1 and payment_user in (sel...

Answers: 1

Paramaterised Query

Custom functions to avoid code repetition
answered 29-06-2020 00:26:01 -0400

If I want create a custom check on fields of the same type I must create a Java Custom User Function to avoid repetitions or there are others ways ? for example I'm checking email address field on different views with: case WHEN ("EMAIL" regexplike '^...

Answers: 3

Founs the error from logs whie connecting to hive
answered 26-06-2020 17:54:47 -0400

i got below error: Caused by: java.lang.IllegalStateException: Detected both log4j-over-slf4j.jar AND bound slf4j-log4j12.jar on the class path, preempting StackOverflowError. See also http://www.slf4j.org/codes.html#log4jDelegationLoop for more detail...

Answers: 1

External database for Denodo metadata or cache repository
answered 26-06-2020 14:01:43 -0400

What RDBMS options do we have as external databases if we want to setup an RDBMS to keep denodo's metadata or cache ? I read under the Data Catalogue section that the external database technology choices are - Derby Embedded MySQL 5.6 and 5.7 Oracle 12...

Answers: 1

external database

Received exception with message 'Java heap space'
answered 26-06-2020 06:10:15 -0400

Hello, I got this error beside when i do a join between two views. But i don't have this error to the other views. I don't use cache and i increase the maximum size in memory of intermediate result but i got the same issue. Can someone help me please...

Answers: 1