Q&A

AI/ML
answered 18-01-2021 05:58:32 -0500

Hi, Does Denodo 8.0 has its own AI/ML algorithms or is it that one can create own AI/ML scripts in say R/Python etc and run them in Denodo 8.0? Also, which other tools of AI/ML can be integrated in Denodo 8.0? Thanks & Regards, Nisarg Shah

Answers: 1

How to convert a date in string format to interval date
answered 18-01-2021 05:54:50 -0500

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Answers: 1

Date Conversion VDP DENODO

The pod in the denodo-container keeps crashing
answered 15-01-2021 05:43:22 -0500

Hello docker/kubernetes experts, I followed the steps mentioned above and after creating the denodo-service.yaml, I can see that the pod keeps crashing with the status : CrashLoopBackOff. Please let me know if anything is missing that might be causing...

Answers: 6
Related to: Deploying Denodo in Kubernetes

kubernetes

How to update existing custom connector
answered 15-01-2021 05:39:20 -0500

When updating an existing custom connector (replacing the extension with a new one), Denodo 7 requires to remove all existing data sources, base/derived views using the connector. How do I do the updating without redoing all the developed views?

Answers: 1

Custom Connector

View parameters
answered 15-01-2021 05:18:36 -0500

Hi, I am trying to use where IN viewparameter like below. like FROM table WHERE column in (param) USING PARAMETERS ( param : text '''A'', ''B'''); Above is not working as FROM table WHERE column in ('A','B') Can you please let me know how to use ...

Answers: 1

Paramaterised Query selection view

Roles Assignment
answered 15-01-2021 04:22:23 -0500

Hi, I understand that it is possible to assign multiple roles to a specific user, and the result will be of UNION. However, is there other way to achieve the following outcome? Assuming there are several records in the database and there are 2 fields...

Answers: 1

roles

How to read records with a different number of columns from the same source file?
answered 14-01-2021 22:18:02 -0500

There is one record with 3 fields or columns in a delimited file and there is another record with 4 fields or columns in the same file. How do I read both of these records in the same base view?

Answers: 1

"error accessing the metadata while loading/storing objects"
answered 14-01-2021 14:18:48 -0500

Hi I get this error for any operation performed on the database. - "error accessing the metadata while loading/storing objects" Denodo Platform 6.0 on a Linux VM OS - CentOS Linux release 7.2.1511 (Core) Last week, we were able to create a new view s...

Answers: 2

How to debug a custom handler?
answered 13-01-2021 06:21:56 -0500

I am developing a custom handler to be used for some of our scheduled jobs. Is there a step-by-step tutorial for debuging custom handler code? What I have found so far are for custom extentions of VDP functinalities (functions or stored procedure). Fo...

Answers: 3

Denodo4E

Unable to test OData Url in Postman
answered 13-01-2021 05:04:43 -0500

Hi Team, I've installed Denodo express 8 in my local system which is Windows10 operating system to practice myself. I've created local database tutorial connecting to my Oracle DB. Tested the connection it was successful. When i place the below Odata u...

Answers: 1