Q&A BY TAG 'Denodo'
How to verify '%Trace' in the DENODOTEST file
answered
17-11-2022 07:39:22 -0500
I have been reading through the documentation of Trace directive in Denodo Testing Tool. I need to access the 'staticO' element in my trace file. When I am accessing the 'staticO' element in the .DENDOTEST file by using the following code 'PLAN ABC.PLA...
Answers:
3
How to test Access Protocols in DENODOTEST file.
answered
16-11-2022 08:51:21 -0500
In DENODOTEST, I need to test the JDBC access protocol that is present in the configuration.properties file. e.g. "jdbc:vdb://<localhost>:<portNumber>/<databaseName>". Is there any information about testing protocols in DENODO? The co...
Answers:
1
Kubernetes + migrate to external database requires temporary restart in admin mode
answered
16-09-2022 12:26:20 -0400
Not so much a question as a note that (if confirmed by others) could be incorporated into documentation? During restart of VDP services after migration to external metadatabase the container reported below error [20220815 version]. I think the issue i...
Answers:
1
Firewall setting for connection with Azure Synapse.
answered
09-09-2022 11:07:28 -0400
This is regarding Denodo Connectivity with Azure Synapse : I wanted to know if we have User Login and Password available for Azure Synapse storage. Do we still need to whitelist Firewall IP connections ? And if we don't have User Login and Passw...
Answers:
1
Removing column from base view
answered
25-08-2022 14:43:06 -0400
Hello, I need to remove a column from the base view created now. Is it possible to do from web design studio's graphical interface itself or have to query it in VQL query window
Answers:
1
How to connect local sql server 2019 db and oracle sql db 11g to denodo express?
answered
22-08-2022 06:12:20 -0400
Hello, How to connect local sql server 2019 db and oracle sql db 11g to denodo express? Not sure what exactly needs to be put for connecting the db with denodo. Please help. Thanks.
Answers:
1
Access Denodo Express DENODO connection How to connect the Denodo Server to the Microsoft SQL Server Oracle 11g
How to get a length of the array in Denodo?
answered
20-07-2022 01:13:56 -0400
I have a column in the Denodo view with the type ARRAY. How can I get the length of this array? Standard sql ARRAY_LENGTH function is not working.
Answers:
2
AWS Glue - Denodo SELECT Query with LIMIT issue
answered
15-07-2022 19:38:17 -0400
Hi, I am running a Glue 3.0 job against Denodo 7.0 server. When I run a SELECT query with LIMIT the job fails with the below error: An error occurred while calling o101.load. Syntax error: Exception parsing query near 'LIMIT' File \"/opt/amazon/spar...
Answers:
1
Scheduler job are failing with below error.
answered
08-07-2022 13:48:45 -0400
Scheduler job are failing with below error. Error executing query. Total time 58.293 seconds. Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results __6A8344AF-188C-4395-BF17-5B65090A3EBF_J8677F255-F04D-497C-A94...
Answers:
1
"Output can be undefined" possible solutions
answered
22-06-2022 01:30:19 -0400
Hi, So I have been getting this "iterator output can be undefined" error It is output to many different sequences, but I can't seem to figure out why I am getting this error. All the iterator holds is a record contructor that holds the extracted data o...
Answers:
3