Q&A

How do I view and export a map?
answered 30-12-2021 08:49:44 -0500

I have created a map within the VQL Shell using the CREATE MAP SIMPLE function. I can see that the map exists because I can list all maps with 'LIST MAPS SIMPLE' and I can see the details of the map with 'DESC VQL MAP SIMPLE.' However, how would anyon...

Answers: 2

Export map

Deadlock issue in Derby DB
answered 30-12-2021 08:08:18 -0500

Hi Team , I am using Denodo 8.0when I am running job from scheduler i am getting below error " A lock could not be obtained due to deadlock,cycle of locks and waiters is : lock : TABLE, SCHED_PROJECTS, Tablelock Waiting XID : {4430...,IX} DERBY , Upd...

Answers: 1

Denodo servers are not starting
answered 30-12-2021 07:28:52 -0500

Hello team, We are not able to start denodo servers, when clicked on start button getting error message as An error was found while starting the program:Cannot run program "cmd.exe" (in directory "C:\Denodo\DenodoPlatform8.0\bin"): CreateProcess error...

Answers: 3

Denodo server starting trouble.

How do I replace special characters in a string?
answered 30-12-2021 07:15:20 -0500

I have a string which includes single quotes which I'd like to remove using the REPLACE function, but I'm not clear what escape characters are required to do this e.g.REPLACE(field, '[esc]'', '') I have also tried creating a MAP to also do this replac...

Answers: 1

string conversion

Denodo Monitor Batch File failing to Start
answered 30-12-2021 07:07:19 -0500

Hello, I'm attempting to configue and launch the Denodo Monitor tool for Denodo Platform 8.0. I've followed the documentation to configure it through the ConfigurationParameters and launch it. When attemtping to run the denodomonitor startup.bat it fa...

Answers: 1

Denodo 8.0 Denodo Monitor Tools

Read DF with DataRange - error
answered 30-12-2021 06:41:30 -0500

Hi, I'm trying to read the monitor query log files with DataRange. If i try this: '<DENODO_HOME>/tools/monitor/denodo-monitor/logs/vdp-queries.log.^DateRange(“yyyy-MM-dd”,@start_date,@end_date,”yyyy-MM-dd”)' i recive the error when i try save dat...

Answers: 1

OS upgrade RHEL 7.3 to 8.4
answered 29-12-2021 07:09:36 -0500

We are planning to upgrade our Red Hat based Denodo servers from RH 7.3 to 8.4. Can we perform an in-place upgrade of the OS or are there issues we will need to be aware of?

Answers: 1

Redhat OS upgrade

Join Views with fields that have similar data, but not identical
answered 29-12-2021 05:25:21 -0500

Hello, I'm new to the Deonodo coummunity. I'm currently working on a poc using two Exel datasources I've created and built views on top of. I am trying to join two of these views together based on a field that contains a calendar quarter. In one field ...

Answers: 1

Excel join

Extracting Data from Views into a file
answered 28-12-2021 07:45:46 -0500

Do we have any in-build denodo function or script to export the data from a view into a file without using denodo scheduler ?.

Answers: 1

Create a Temporary Table in a CTE using Denodo in Dbeaver
answered 28-12-2021 07:02:58 -0500

Hi. I am using the below in Dbeaver Lite using Denodo. Select from V4780_B_TABLE_LOB WITH cte AS ( SELECT FROM ( VALUES ('B4000') ) AS a (agent_code) ) -- select * from cte; This works when accessing another Database outside of Denodo but doesn'...

Answers: 1