Q&A

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

Column Names and reserve words
answered 04-01-2022 01:56:09 -0500

Denodo is throwing error for below, column name starting with “Underscore” . column name “asoftimestamp” any idea, is this a reserved word ?

Answers: 1

#columnName

Denodo Cache question
answered 03-01-2022 07:45:15 -0500

Hi Support, is it possible to use two different cache source at a same time? I mean to say to separate databases(like teradata & oracle) as cache? and If yes, then how we will synch up both at a same time? Thanks.

Answers: 1

cache denodo

Removing html from a string
answered 03-01-2022 02:21:45 -0500

What is the simplest way of removing html from a string? I have attempted to create a map of various tags and parts of the html, but this is a very flawed way of doing this, leaving numbers, characters and tags which haven't been accounted for in the d...

Answers: 1

HTML string conversion

What is the best caching database for joining Teradata to AWS Athena?
answered 31-12-2021 05:55:55 -0500

I have a dataset that requires left joining ~12M records from Athena onto ~10K records from Teradata. Our Denodo instance is centrally managed and does not currently support any caching or data movement. I want to request support for caching, but do no...

Answers: 1

How do we export resource manager rules/plans ?
answered 30-12-2021 09:07:17 -0500

Please suggest how to export resource manager rules/plans. Tried with File-> Export Database from VDP Admin Tool and using export script from denodo home bin location. When trying with File -> Export getting java out of memory error. Please sugge...

Answers: 2

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