Latest Activity

code

Error using multiple inner joins

Hi Community I'm facing an error with vdp, when using joins. I'm working on a view using 28 inner joins, at 25th join everything works fine, but when i add the 26th table to join with i have the following error : Finished with error: Error executing...

code

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

code

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

code

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

code

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

code

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,

code

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

code

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?

code

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

code

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