Q&A

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

Data Movement and AdHoc queries
answered 01-04-2021 06:51:16 -0400

Among other things the semantic layer are designed to support AdHoc queries. When having a mix of datasources the Data movement is the key enabler to get the queries to executed effectively. I do not see that happened. What I see is that Data Movement...

Answers: 1

Count the number of commas is a string
answered 31-03-2021 09:45:04 -0400

Is there a way to count the occurences of a comma in a string? I need to filter out any rows there there are NOT exactly 3 commas in that field.

Answers: 2

Regex count

Function to synchronize the VDP server metadata with Data Catalog
answered 31-03-2021 08:57:03 -0400

Hi Team, Do we have the feature in some high version Denodo (such as Version 7.0) , which can have auto metadata synchronize the VDP server metadata with Data Catalog? Then we will have no need to do manual sync VDP metadata to Data catalog, and we wil...

Answers: 5

Data Catalog synchronize with VDP feature

Design studio not working 8.0 - web container restart required
answered 31-03-2021 08:56:38 -0400

Hi Team, Design studio stops working with error. Web container restart required. com.denodo.vdb.vdbinterface.common.connection.ProxyVDBConnectionUtil [] - Error instantiating a VDBPoolableConnection instancejava.lang.reflect.InvocationTargetException...

Answers: 1

design studio

Override - Denodo Platform installs under a single folder (DENODO_HOME) and writes data in the same folder hierarchy
answered 31-03-2021 08:34:41 -0400

The Denodo Platform installs under a single folder (DENODO_HOME) and writes data in the same folder hierarchy so to avoid issues with permissions Is there a means to override this behavor? Modifying DENODO_HOME is causing issues for semi-managed...

Answers: 1
Related to: Denodo Admin and Development Best Practices

Data Same Hierarchy hierarchy Install Denodo Install Single Folder Write Data Same Hierarchy Single Folder

Denodo-Kafka wrapper - JSON Schema
answered 31-03-2021 08:31:23 -0400

Hi Team, While I was going through Denodo-kafka custom wrapper I can see that while giving JSON message format it is throwing an error if I am not selecting any Schema path, it does not seem to be mandatory field as there no asterisk sign on it. Den...

Answers: 3

kafka connector kafka

Denodo data catalog synchronization using curl command
answered 31-03-2021 08:29:43 -0400

Hi Team, We are trying to write a shell script to automate the denodo data catalog syncronization using the curl command. But when am try to execute the curl command, i am getting HTTP status code 403 and message as null in the response. What could be...

Answers: 1

#curl #Datacatalog

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

VQL Denodo 7.0 search methods join Derived views

Changing parameter
answered 30-03-2021 08:40:58 -0400

Hi there, I have made one comparision parameter in a join view, like input '=' or 'in' localdate(2201/02/03) but if I want to add between range here, then what changes I have to do and how it works. I am trying to chnage it but it won't work.

Answers: 4

change parameter

PGP Encryption Custom Input Filter
answered 30-03-2021 06:33:56 -0400

We have a need to retrieve a PGP Encrypted file using the SFTP Delimited File connector. It appears that the only way to handle it (without having a preprocessor pull and decrypt) is to build a custom input filter. Has anyone already built this type of...

Answers: 1

encrypt PGP Custom Input Filter