Home / Q&A / All Questions

Q&A

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

Remove duplicate words with a regular expressión
answered 07-12-2020 07:38:34 -0500

Hello: I have this input: abc,abc,123,000,123,000 And I need to remove duplicates words. The output must be: abc,123,000 I'm using this regexp: \b(\w+)\b\s,\s(?=.*\1) but it doesn't work. I'm testing in this page were works: https://regex101.com/r/...

Answers: 1

Duplicates Regex

IGC can read data From Denodo but..?
answered 04-12-2020 03:57:15 -0500

Hello, I have made a Governance bridge from Denodo to IBM InfoSphere IGC, question is "Can we automate the data synchronization from denodo to IGC by Denodo Governanvce bridge tool in linux on daily basis?" Thank You.

Answers: 1

IGC

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