Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

BulkLoad Issue on CacheDB
answered 24-01-2019 08:05:57 -0500

Hi Team I have environment where we are having 300millions records it took us 10hrs to load on the cache DB(3years data) with proper query, I want to schedule another job with 1 day older records to be cached which i am expeting only updated records,...

Answers: 1

Incremental mode last_modified_date > '@LASTCACHEREFRESH'
answered 24-01-2019 06:39:31 -0500

What is the date format of the variable LASTCACHEREFRESH My data has a column last_updated with a data type as "text" and value like "2019-01-22 11:00" but using the condition last_updated > @LASTCACHEREFRESH and the cache does not get loaded. I ha...

Answers: 1

LASTCACHEREFRESH

Modifying the Denodo Testing Tool HTML Report
answered 24-01-2019 02:18:30 -0500

Hi Team, Is there any way to edit and customize the denodo testing tool html reporter to our needs. Please advise. Thanks

Answers: 1

DenodoTestingTool

MPP and authorization
answered 23-01-2019 08:57:58 -0500

Hallo Denodo Team, First of all, thank you for the answeres to my many questions. This question may be vague, because I didn't really understand the context. Is there any possible issue that you are aware of with authorization/security when entrustin...

Answers: 1

authorization security MPP

JVM Details
answered 23-01-2019 07:42:20 -0500

Hi Team, I would like to automate the JVM heap size usage by moniotring. I need below deatils from where i can get those details. JVM Type: Ex: Sun/Rockit or IBM.. etc…? Application Name: Tier Name:Node Name: Type of application server: Server OS Typ...

Answers: 1

Denod JVM

Logs Information
answered 23-01-2019 07:06:54 -0500

Hi Team, In Denodo VDP server I find different logs for VDP like VDP-admin, vdp,vdp-requests logs, what is the significance or use of these differentr logs can you please explain in detail. Regards

Answers: 1

Error Loading View in Denodo VDP Tool
answered 22-01-2019 17:07:53 -0500

Hi Team, When I am trying to edit a Base view or double click and try to open a Base View I am getting a error : "An internal error occurred when loading this wizard. Check the application log for details in Denodo" May I know why do I get these erro...

Answers: 1

How to deploy the derived view in the different environments (Staging/Production) from Development with updated fields without modifying the individual derived views?
answered 22-01-2019 16:09:34 -0500

I have created a "Selection" Derived View. I would like to add a field in the Derived View for "URL" in the final output for Tableau reports like "https://DevTableauServerName/DevReportname". So, I added like this, Output Tab -> New Field -> Fi...

Answers: 1

derived view URL deployment

How can we the VDP Datasource name
answered 22-01-2019 11:00:45 -0500

We'd like ro know as how to change the VDP datasource name? We have greated many base views and derived views using the existing datasource (ds_test) Existing Datasource name: ds_test to be renamed as: ds_test_DONOTUSE

Answers: 2
Related to: How to replace a data source without modifying the derived views

Change VDP datasource name

Function LASTDAYOFMONTH not delegated to Teradata
answered 22-01-2019 06:26:53 -0500

Hallo Denodo Team, Investigating the reasons why a query is not delegated to the Teradata data source, we have read this explanation: The function 'lastdayofmonth' cannot be delegated to this database Teradata has a corresponding function, namely LA...

Answers: 2

delegate lastdayofmonth teradata delegation