Latest Activity

Query optimization for fixed length file sources

Hi, We have fixed lenth data source and it is mutli record type file for example the starting of the row will what type record it is like if start with 's' it is a student record it is start with 'm' it is marks record like that there will be mutiple ...

Spatial functions available in Denodo Express?

Hi, We are performing a proof of concept with Denodo. For our organisation spatial data is of uthermost importance. In the documentation of the Xtrafunc functionality I can see there are some spatial functions (https://community.denodo.com/docs/html/do...

"Remote license not found. The server is not registered in Solution Manager." when starting VDP server in Docker container.

Can't get past the server trying to find a license on the license/solution manager when starting a VDP server in a Docker container. I've successfully started a local installation of a VDP server getting a license from the license/solution manager and ...

AI/ML

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

How to convert a date in string format to interval date

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,

The pod in the denodo-container keeps crashing

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

Related to: Deploying Denodo in Kubernetes

How to update existing custom connector

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?

View parameters

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

Roles Assignment

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

How to read records with a different number of columns from the same source file?

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?