Q&A

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

How can we preserve the current Denodo (VDP) installation , if later we decide to install other modules like Scheduler, ITPilot etc. ?
answered 25-06-2020 11:23:16 -0400

I read somewhere in the documentation that it is recommended to install all the modules of Denodo Platform initially the first time, even though we may not need all the modules (ITPilot, Catalogue, Scheduler etc.). Let's say, we have not installed all ...

Answers: 1

Denodo Installation

publish web services with Oauth 2 authentication question
answered 25-06-2020 09:50:28 -0400

When publish web services with Oauth 2 authentication. Using postman testing get message "The user does not have CONNECT privileges on the database 'api'" Which user need set privileges to connect to database 'api'

Answers: 1

Data Lineage metadata extraction and its graphical representation
answered 25-06-2020 02:30:40 -0400

I understand denodo provide certain predefined views to expose metadata. Couple of those views expose data lineage information. But do you expect the consuming application to build the graphical representation themselves or do you also provide some sup...

Answers: 1

Metadata views data lineage

Unable to connect to hive
answered 25-06-2020 01:37:05 -0400

I have downloaded the jdbc driver for hive. I am using cloudera distribution. I downloaded the driver and put it under /opt/denodo/denodo-platform-7.0/lib-external/jdbc-drivers/hive-1.1.0-cloudera this path. It is still showing error: Unable to estab...

Answers: 1