Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Checking for corrupt metadata
answered 07-08-2020 02:25:03 -0400

We have run into issues recently where one of our VDBs, or the entire dbmetadata database has become corrupt. Is there any type of checks than can be done to alert us when this happens for a faster response time?

Answers: 1

Free Trial: no extension available
answered 06-08-2020 07:10:30 -0400

Hi, I am second day on my free trial. I would like to connect to S3. However, there is nothing under "existing extension" Please advise. Thanks, Ming

Answers: 1

license custom S3 extension

About VCS Cache mode setup for views
answered 06-08-2020 06:05:57 -0400

Hi team Currently all of DV views are VCS by gitlab. I have a base view created, which is build on Oracle database. Now the views is under VSC by gitlab also, before we did not turn on the cache mode for this view, but when we put the cache mode to "Pa...

Answers: 1

cache mode view VCS

About VCS Statistics of views
answered 05-08-2020 17:35:10 -0400

Hi team Currently all of DV views are VCS by gitlab. I have a base view created, which is build on Oracle database. Now the views is under VSC bygitlab also, but it has no stastics gathering. So I gathered its statstics, and I also make the vql shown w...

Answers: 1

VCS gitlab view statistics

name the csv reports
answered 04-08-2020 18:14:14 -0400

Hi, using Denodo Testing Tool, I would like to have a distinct csv report for each .denodotest file, using the %NAME of the test for the name of the csv. for example if in my .denodotest file I have %NAME test1, i would like to have a report named test...

Answers: 1

Teradata to denodo sql
answered 04-08-2020 07:16:22 -0400

how to convert the below syntax from teradata to denodo sql (DATE-1 - DAYOFMONTH(DATE-1))+1 (DATE-1 - Extract(Day from DATE-1))+1

Answers: 1

date

Connection error:Connection timedout connect
answered 04-08-2020 03:35:17 -0400

Hi Team, After starting all the servers in the VDP login page of the Denodo platform Control Center 6.0,getting the below error. Connection error:Connection timed out connect. Please help on this regard.

Answers: 4

Multiple Union statements with parameters are not working in VQL.
answered 03-08-2020 08:29:36 -0400

Hi There, We are trying to implement multi UNION. It is something like following: `CREATE VIEW iv_union_test as SELECT * FROM iv_derived_vw q1 WHERE q1.date = i_date AND q1.id = i_id AND q1.flg = 0 UNION SELECT * FROM iv_derived_vw q2 WHERE q2.date ...

Answers: 1

UNION

Can you run a delete statement through the scheduler instead of deleting the entire table before inserting data?
answered 31-07-2020 16:01:28 -0400

Is there a way in Denodo Scheduler to delete specifics rows from a database table without having to delete the entire table and re-populating it with the rows that should not be deleted?

Answers: 1

Denodo Scheduler 7.0

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 31-07-2020 13:13:16 -0400

Hi Team, We use AWS RDS for Denodo Cache. We have upgraded RDS mysql version from 5.6.41 to 8.0.16. When trying to connect from Denodo VDP to RDS, it is throwing below error. Unable to establish connection: Communications link failure The last packe...

Answers: 3

Cache