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.

Returning an existing compound type from executeReturnType
answered 29-06-2020 09:43:17 -0400

I have a bunch of complex compound types defined via CREATE TYPE syntax. Can I use them as a custom function return type, that is, return this type from executeReturnType()? E.g. something like this: @CustomExecutorReturnType public CustomRecordTy...

Answers: 1

Custom Functions Compound Types

Parameterized View
answered 29-06-2020 07:30:40 -0400

Hi, I have two different data souce connected in Denodo (one is Netezza and one is Oracle). I have created one baseviews in both the sources using query.(i.e. net_baseview and orc_baseview) net_baseview has some paramteres (start date and end date an...

Answers: 1

Paramaterised Query

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