Home / Q&A / All Questions

Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

LAG funcation in Denodo
answered 08-02-2019 16:50:37 -0500

Hi How i am suppose to implement following function in Denodo LAG(A.DESCRIPTION,1) OVER (PARTITION BY A.ID ORDER BY A.TIME) AS DESCRIPTION_FROM

Answers: 1

problem with acme_crm
answered 08-02-2019 10:56:46 -0500

I use the Denodo platform 7.0 and mysql workbench 8.0.12. Hello, As I made some mistakes in the beginning with the tutorial, I wanted to start again from the beginning so I dropped all folders and the tutorial database too. After I created the tutorial...

Answers: 1

Learning path for Denodo
answered 08-02-2019 09:06:09 -0500

Hi, From my company, we are starting a learning drive for DV and Denodo.I would like to know what should be a course path if we start to learn Denodo today? We do not have much knowledge on Data Virtualization but have a good working experience in BI D...

Answers: 1

listtag in denodo
answered 08-02-2019 06:36:52 -0500

Hi How i am supose to execute following query in denod listagg (C.SHORT, '; ') WITHIN GROUP ( ORDER BY C.SHORT asc) AS DESCRIPTION

Answers: 1

List of view name for a particular flow from tree-view
answered 08-02-2019 06:00:46 -0500

Hi Team, What will be the query to get list of view name for a particular flow from treeview. in bottom to top order. Is there any query available to get this desire result. Thanks!!!

Answers: 1

List of view using "Used By"
answered 08-02-2019 05:41:21 -0500

Hi Team, Is there any query to get list of views using "Used by" in any particular interface. i want to extract a list, containg name of modified view name in any particular interface. Thanks!!

Answers: 1

REST service is not processing 'X-HTTP-Method-Override' header
answered 07-02-2019 18:01:23 -0500

axios({ method: "POST", url: "http://localhost:9090/server/customerdb/person/views/person", headers: { "X-HTTP-Method-Override": "GET", "Content-Type": "application/json;charset=UTF-8", "Accept": "application/json" }, data: { "$filter": "firstname eq '...

Answers: 1

REST

What happens to existing database during "CREATE OR REPLACE DATABASE"?
answered 07-02-2019 17:35:03 -0500

Hi, what happens to an exisiting database X if the VQL statement "CREATE OR REPLACE DATABASE X" is executed? Has this effect on existing objects in this database? Thank you.

Answers: 1

Error in create BV from SQL query
answered 07-02-2019 04:30:48 -0500

Hi I am executing query in DB2 which working fine and getting the results , while i was executing same query from Denodo to creating base view i am getting following error Error executing sentence: com.denodo.util.exceptions.InternalErrorException...

Answers: 1

Query to Return Summary and Last Record as One Row
answered 07-02-2019 03:59:28 -0500

I'm struggling to write a query which returns a single row with summarized data and the last instance of an event. Scenario: Let's say I have a customer table and a sales transaction table. I need to write a query which returns the Total Sales by Cust...

Answers: 1