Q&A

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

How to solve QUERY_TIMEOUT
answered 24-06-2020 16:51:48 -0400

How can I solve the QUERY_TIMEOUT after 900 seconds. My connection is: Driver class: oracle.jdbc.OracleDriver Database URI: jdbc:oracle:thin:@10.187.18.24:1521/DOKO As explained in Developer guide, I tried: jdbc:oracle:thin:@10.187.18.24:1521/DOKO?que...

Answers: 8

QUERY_TIMEOUT

HOw to connect denodo VDP from a java program
answered 23-06-2020 09:34:12 -0400

i want to connect to denodo that is installed on remote server. i want to connect it from my local system using Java Program. How can i do that?

Answers: 1