Q&A

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

Business Objects universe
answered 25-06-2020 18:39:20 -0400

I am trying to connect a business objects universe to denodo. I succesfully installed the JDBC client and was able to create a connection in Business Objects. In the Bobj IDT I am able to create a simple universe and publish. However when I try to crea...

Answers: 2

Denodo Increamental Cache Load
answered 25-06-2020 16:04:24 -0400

I am using Denodo V7 and I have enabled full Cache on a view in Denodo. Now I am trying to set up an incremental Cache load for this view through the Denodo Scheduler. But I keep getting an error which goes like this 'Error executing query. Total tim...

Answers: 1

Denodo Incremental Cache

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

Duplicate views are getting created while creating base views
answered 25-06-2020 03:43:54 -0400

Hi Team - I am creating base views on a delimited data source(CSV). For this I created a base view under this data source object in the server explorer pane of VDP Admin client. I also see another base view (with the same name) also getting created aut...

Answers: 1

Base view