Q&A BY TAG 'Denodo 8.0'

You must sign in to ask a question. If you do not have an account, you can register here

Left outer join losing rows
answered 03-09-2021 06:54:45 -0400

Hi, I'm joining a bunch of derived views. The SQL has 3 INNER joins and 2 LEFT OUTER joins. The LEFT OUTER joins are losing rows. One of this LEFT OUTER join has a static filter condition (like Active = 'Yes'). None of these derived views have PKs def...

Answers: 1

Denodo 8.0 left join

Custom policies - Trying to get data from Denodo base view
answered 23-08-2021 04:36:06 -0400

Using Denodo 8.0, I'm trying to build a custom policy that will be applied to a specific derived view, that works this way: When user tries to access the data of a derived view, the policy checks to see if the current user is in a config table. If th...

Answers: 6

Denodo 8.0 custom policy jmx

denodo-v80-update-202107152200.jar fails command line update
answered 22-07-2021 03:07:00 -0400

./jre/bin/java /opt/denodo/updates-for-denodo-20210715/denodo-v80-update-202107152200.jar "/opt/denodo/denodo_platform_8_0" -c Error: Could not find or load main class .opt.denodo.updates-for-denodo-20210715.denodo-v80-update-202107152200.jar Caused b...

Answers: 1

Denodo 8.0 update Error Virtual DataPort

Custom functions jar file renaming and name conflicts
answered 09-06-2021 18:20:55 -0400

Hello, When we started developing custom functions in Denodo, we had stored them all in a single package. However, we have now reached about 200 custom functions and in order to simplify maintenance, we would like to split that package in 3 (Date func...

Answers: 3

Denodo 8.0 extension Custom Functions

MEDIAN gives an error
answered 01-06-2021 15:28:15 -0400

While calculating median. I am receiving the following error. [GROUPBY] [ERROR] java.lang.reflect.InvocationTargetException Received exception with message 'java.lang.reflect.InvocationTargetException' The logs are as follows: *ERROR 2021-05-31T09:38...

Answers: 1

Denodo 8.0 Error data aggregation

Denodo 8 - SSL Configuration and TLS Configuration Script
answered 26-05-2021 12:41:06 -0400

Team, I'm in the process of configuring SSL for our Denodo 8.0 servers. I'm on the step where we use the TLS Configurator to configure / enable SSL for the platform componenets. For the most part, everything is clear with one exception. The instruction...

Answers: 2

Denodo 8.0 SSL

Help ASAP with Property File Location
answered 05-05-2021 09:26:15 -0400

Hello, we have created a custom policy to provide row-level security to certain objects. Inside the logic, this policy works with config tables to get the provided level of security for the users via JDBC. Since we are connecting via JDBC, we have to s...

Answers: 2

Denodo 8.0 custom policy properties

PostgreSQL v 13.2 Database connector/JDBC drivers - When?
answered 30-04-2021 13:30:37 -0400

Hi there, I know it is very early on to be asking this question, but does anyone know by when the JDBC drivers for v13.2 of PostgreSQL will be available, or if they are already available, where to get them? At the moment the highest version in the se...

Answers: 1

Denodo 8.0 Connector PostgreSQL JDBC Remote Tables

Apache zeppelin install windows for Denodo8
answered 27-04-2021 17:44:01 -0400

I would like to know the step by step process to install the open the zeppelin in my local windows machine I have the zeppelin zip and after extract execute zeppelin.cmd and configured denodo/interpreter-setting.json file. Still I am not able/launch t...

Answers: 1

Zeppelin Denodo 8.0

Isolated query of a joint view
answered 16-04-2021 08:35:01 -0400

Hello, is it possible to solve the following scenario: I have two views with different sources, which I would like to join (a push-down is therefore not possible). I want to join these views and make them available for reporting. However, the reportin...

Answers: 1

Denodo 8.0 performance join