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
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
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
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
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
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
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
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
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
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