Q&A

Unable to Query views with individual columns in select query
answered 03-12-2020 06:51:36 -0500

Hi Denodo team, I am trying to query a view with its individual columns in the select query but it is failing to fetch the result and throwing the below error. Finished with error: Error in select view conditions: Field not found 'view_name.column_name...

Answers: 1

JDBC query JDBC SQL

How to get the most recent file from data source AWS S3?
answered 03-12-2020 05:46:04 -0500

I'm using Denodo Distributed File System Custom Wrapper. On S3, we have a file gets generated weekly with a full dump of data. So is there a best way to always get the most recent file whenever requested? Also is there a date range supported using cust...

Answers: 1

S3 Bulk Data Load

Tableau vs Denodo
answered 03-12-2020 01:15:00 -0500

I am a Tableau Developer. I work with various source systems to create combined data view. Based on information provided on Denodo platfom, It looks like it connects wth source system to fetch data and provides functionalities to combine them. Tableau ...

Answers: 2

Command to confirm for odata4 service running in vdp server?
answered 02-12-2020 06:24:37 -0500

What is the command to confirm for odata4 service running ( by default) in a vdp server?

Answers: 1

DENODO

I have installed Oracle VM VirtualBox and I cannot find the file referenced as Denodo Training QuickStart Virtual Machine.ova
answered 01-12-2020 12:50:03 -0500

I have installed Denodo 8.0 successfully and Oracle VM VirtualBox and I cannot find the file referenced as Denodo Training QuickStart Virtual Machine.ova. In order to point the Virtual Box to the Denodo data for the Developer course. Does anyone know w...

Answers: 2

Data catalog change timestamp type fields format
answered 01-12-2020 07:06:36 -0500

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...

Answers: 3

formatdate Data Catalog formatting timestamp

How to have all view statistics regarding to how many times queries have been thrown to each view
answered 01-12-2020 06:39:27 -0500

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...

Answers: 1

DENODO view statistics Denodo view

Custom wrapper EBCDIC sources
answered 01-12-2020 05:35:00 -0500

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?

Answers: 1

EBCDIC custom wrapper

LDAP Datasource & Base View Creation
answered 30-11-2020 16:35:15 -0500

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...

Answers: 1
Related to: LDAP authentication best practices

LDAP openldap

Migrating vql scripts to other environments
answered 30-11-2020 04:15:47 -0500

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...

Answers: 1