Q&A

regexp no argument for repetition operator: ?'
answered 28-04-2021 17:36:11 -0400

I have the following regexp function: SELECT TRIM(REGEXP(REGEXP(REGEXP(CUSTOMER_NAME_COLUMN, '[,\.]\s*', ' '), '\s+\w(?=\s+|$)', ' '), '\s{2,}', ' ')) AS CUSTOMER_NAME_CLEAN FROM TABLE When trying to run this, I get the following error: [JDBC ROUTE] ...

Answers: 1

regexp

how to check denodo data catalog is in sync or not.
answered 28-04-2021 16:30:57 -0400

how to check data catalog is in sync or not. One of our user could access to a data catalog url & unable to access another data catalog.

Answers: 1

Denodo dialect for python
answered 28-04-2021 11:54:21 -0400

Hi, I downloaded the denodo dialect for python connexion to use with sqlAlchemy on the support site. (Denodo Dialect for SQLAlchemy). I tried to add the dialect like I was told in this article : https://community.denodo.com/docs/html/document/denodoco...

Answers: 3

python dialect

How to obtain the input parameters of the custom stored procedure in the overridden initalize() method?
answered 28-04-2021 07:57:50 -0400

We want to execute some refresh vql command and get back the response through jdbc connection. Is it possible to obtain the input parameters in the initalize() method like we do in the doCall() And how do we extract and return the response of said vql...

Answers: 1
Related to: Executing VQL statements from a stored procedure

Custom stored procedure JDBC

Error while using custom function
answered 28-04-2021 00:31:32 -0400

Hi Team, I developed a custom function when I am using it I wm getting error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function 'psi_hashicorp_decrypt' is not executable. Can you please let me kno...

Answers: 3

Custom Functions

Zeppelin - The system cannot find the path specified
answered 27-04-2021 19:05:13 -0400

Hi, I am trying to use Apache Zeppelin wih Denodo. I followed the instructions in doc section. Downloaded and unzipped in following folder.. I kept it inside Denodo folder. Then tried to run /bin/zeppelin.cmd through Command Prompt (Windows) getting th...

Answers: 1

Zeppelin

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

denodo testing with nested complex structure
answered 27-04-2021 06:34:00 -0400

Hi, I am trying to test some complex structure. Suppose I have the following view: tech_data Array and Array is: measurements weights additional Register Register R...

Answers: 1

Denodo 7.0 Denodo Testing Tool complex array

Denodo Solution Manager installation
answered 26-04-2021 15:07:45 -0400

Assuming, I have 3 enivronments Development, UAT and Production. I would like to know if we need to install the Solution Manager in all the 3 environments (of course on a separate machine than the Denodo Platform) or we just need to have one Solution M...

Answers: 1

Wrapper name cannot be updated when changing the base view name
answered 26-04-2021 08:26:58 -0400

Hi Team, We understandm when we create a base view, Denodo will get the wrapper created firstly and then the base view created on the basis of wrapper. And the wrapper name has the same name as the base view. However we found this case, after we create...

Answers: 1

base view name update wrapper name