Q&A

Error using multiple inner joins
answered 19-01-2021 04:53:30 -0500

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

Answers: 1

joins

How to find Invalid views using VQL or Query
answered 19-01-2021 02:23:36 -0500

I want to find the invalid views using vql or query . This is really important as when import happens to higher environement using solution manager it really doesnt show the errored view and need to manually check all the views which is very tedious. ...

Answers: 6

Query optimization for fixed length file sources
answered 18-01-2021 10:18:33 -0500

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

Answers: 1

Query Optimization in denodo 7

Spatial functions available in Denodo Express?
answered 18-01-2021 07:05:21 -0500

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

Answers: 1

Spatial data

"Remote license not found. The server is not registered in Solution Manager." when starting VDP server in Docker container.
answered 18-01-2021 06:04:32 -0500

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

Answers: 1

container Denodo 7.0 Denodo 7 Solution Manager Docker 7 License 7.0 docker

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