Q&A

INSERT INTO with SELECT
answered 18-10-2021 04:32:01 -0400

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

Answers: 3

VQL syntax insert

Created Stored Procedure
answered 18-10-2021 03:24:08 -0400

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

Answers: 1

Can I Use limit clause within the definition of a VQL view?
answered 18-10-2021 03:15:33 -0400

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

Answers: 1

remove all _0 from field names on new base view
answered 17-10-2021 22:51:00 -0400

we have config turned on where if a field is renamed because of space or special characters it appends underscore 0 to the end of the field name, we want to keep that feature on but I have a view of like 100 fields and half of them have it. Is there a...

Answers: 1

Base view Vql shell Rename

JDBC property as a parameter
answered 17-10-2021 21:44:46 -0400

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

Answers: 3

jdbc property parameter

Simba connection error in : uncategorized Column Type
answered 15-10-2021 06:38:06 -0400

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

Answers: 1

simba JDBC Azure databricks

Unable to start Virtual DataPort Server.
answered 15-10-2021 05:02:48 -0400

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

Answers: 3

Virtual DataPort Server

VCS configuration in solution manager
answered 14-10-2021 02:19:33 -0400

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.

Answers: 1

Solution Manager Denodo with Git GitHub VCS Connecting to remote databases

Denodo 8.0 needs internet acces to update to the latest version?
answered 14-10-2021 02:10:45 -0400

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?

Answers: 1

How to create a base view from query in S3
answered 13-10-2021 08:53:32 -0400

How to create a base view from query in S3?

Answers: 2

Base view