Q&A

denodo_tls_configurator examples
answered 04-01-2022 05:37:53 -0500

below is the command im executing but it is not workin. denodo_tls_configurator.bat --keystore C:\Denodo\DenodoPlatform8.0\denodo_server_key_store.jks --truststore C:\Denodo\DenodoPlatform8.0\jre\lib\security\cacerts --license-manager-uses-tls=false -...

Answers: 2

denodo_tls_configurator

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