Latest Activity

code

Data catalog change timestamp type fields format

Hello, Currently when we query views containing fields of type "timestamp" in our Data Catalog, the data in these fields is formated in an odd way like the following example: Mon Dec 05 09:52:00 2005 When querying the same view through the VDP...

code

How to have all view statistics regarding to how many times queries have been thrown to each view

I would like to know how to have all view statistics regarding to how many times queries have been thrown to each view. https://community.denodo.com/docs/html/browse/6.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_stati...

code

Custom wrapper EBCDIC sources

Hi, we have as a source an EBCDIC file and we have to configure a custom wrapper to read it. Do you know best practices or do you have any experience with this format file or similar one?

code

LDAP Datasource & Base View Creation

System Distributor ID: Ubuntu Description: Ubuntu 18.04.5 LTS Release: 18.04 Codename: bionic Denodo Version: 8 (denodo-install-8.0-ga-linux64) Updates: None Issue Ldap datasource gets created fine & 'Test Connection' succeeds. But the creatio...

Related to: LDAP authentication best practices

code

Migrating vql scripts to other environments

I created two data sources one is for delimited file source and another is for filesystem custom wrapper. For each data source I created one base view. Then I create one derived view by joining those base views. In the derived view I have specified whe...

code

Flatten array with column of index of value in array

Hi, I have a view in which there is an ID column, and a column with an array in that I want to flatten. This of course flattens the array so each value in the array becomes a new row, with the same ID column across multiple rows. What I want to be ab...

code

vql to invalidate cache (base views, derived views)

Hi team, I want to find out vql to invalidate cache, I run below for a base views, but it has error "selected view: 'base_view_name' is a base view": ALTER VIEW base_view_name CACHE INVALIDATE it cna only run for derived view: ALTER VIEW derived_view_...

code

Denodo V7 Increemental Load

I am getting the following error message while trying to run the Incremental load. This was working fine in the production environment, but now in the test environment I keep getting thsi error even with 1 days' data. Error executing query. Total time ...

code

Create/Deploy/undeploy REST endpoints programaticly

Hi, is there a way to create/deploy/redeploy/undeploy... denodo REST endpoints programmatically using some command lines or an API instead of using the "denodo virtual dataport administration tool" or the "denodo design studio" witch are more UI tools...

code

Updating license

Currently I'm using trial version, and now I need to extend the lincense for another year. I got the latest license file, but not able find how to update the file. Tried updating the latest file as denodo.lic and launch the tool, this is not helping. ...