Latest Activity

code

INSERT INTO with SELECT

Hi Team, Could you please confirm the below limitation of VQL syntax. Working - INSERT INTO view2 SELECT col1 FROM view1; Working - INSERT INTO view2 (col1) VALUES ("abc"); Not working - INSERT INTO view2 (col1) SELECT col1 FROM view1; Not working - ...

code

Created Stored Procedure

I try to create an SP to create all the vdb folder structures, but when I run this: String query = "CONNECT DATABASE" + vdb + ";" + "CREATE OR REPLACE FOLDER '/01 - connectivity';" + "CREATE OR REPLACE FOLDER '/ 01 - connectivity / 01.1 - data sources'...

code

Can I Use limit clause within the definition of a VQL view?

CREATE OR REPLACE VIEW my_limit_derivedview folder 'myfolder' AS SELECT X,Y, Z FROM my_derived_view WHERE x = 10 limit 1; Cannot save the above as a VQL view definition. The error comes as "Exception parsing query near limit" The same select query "S...

code

JDBC property as a parameter

Is there a way that we can pass a denodo JDBC property in as a parameter? PostgreSQL has an "options" parameter which does this as seen on https://jdbc.postgresql.org/documentation/head/connect.html. We are trying to define the ticketCache property fr...

code

Simba connection error in : uncategorized Column Type

Hi, I am trying to fetch the data from a table on Azure Databricks (ADLS). Tables are delta tables. I am using Simba driver on Denodo and the connection is successful as suggested in denodo documentation. After successful connection. I try to do "Creat...

code

Unable to start Virtual DataPort Server.

I have installed Denodo express 8 version on MAC Os with JDK 11 as per the info from https://community.denodo.com/docs/html/browse/latest/en/platform/installation/appendix/supported_java_runtime_environments/supported_java_runtime_environments Post th...

code

VCS configuration in solution manager

Hi team, We are trying to configure git in solution manager using VCS,can u please suggest where we can find the databses which we created in denedo platform (or denodo design studio),how to enable these databases in solution manager. Thank you.

code

Denodo 8.0 needs internet acces to update to the latest version?

Hi, does Denodo 8.0 need acces to internet when performing unattendet installation with the Modifying the Denodo Platform Installer to Include the Latest Update?

code

How to create a base view from query in S3

How to create a base view from query in S3?

code

Why cache job is taking too much time to establish connection to the database.

Hi, We have scheduled a cache job in scheduler to load the cache. But it is taking too much time to connect to the database. Sometime it takes one and half hour and sometime 2 hours to establish a connection to the database. Once it establishes the con...