Q&A BY TAG 'Denodo 8.0'
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
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-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
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
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 - 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
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
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
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
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