Q&A BY TAG 'Aggregate'

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

MAX function for int field - filter for the result?
answered 23-08-2021 08:42:19 -0400

is there an easy way to set a filter to only keep the max value for a field based on two other columns? is greating a group by view with the max first and joining that to the baseview the only way to accomplish this? There are two fields that make th...

Answers: 1

max function Aggregate Group By

Aggregate Awareness
answered 09-04-2018 05:09:23 -0400

Not sure if this question belongs in this section, but I would like to know how Denodo handles aggregate awareness. Does Denodo have the ability to be configured logically to pull from a single fact table, but physically have multiple tables at differe...

Answers: 1
Related to: Data Virtualization and ETL

Aggregate query re-write

Restful API: Aggregation function with $grouby not working
answered 07-12-2017 07:35:43 -0500

I am trying to consume Rest API from denodo and finding some issues. View has multiple fields like userid, username, managerid, amount. When I am calling service like this /servicepath/view/viewname?managerid=xxxx&$select=userid,username,managerid...

Answers: 1

REST API Aggregate

Aggregate operation on Rest web service
answered 07-12-2017 06:50:23 -0500

Hi, Does Denodo allow passing aggregates operations over an API? I have a REST API and the user needs to select only 3 columns from that API, group by 2 columns and calculate aggregate(sum operation) over the third column. I am able to select three co...

Answers: 1

REST API Aggregate

answered 09-05-2017 14:31:26 -0400

Denodo 6.0, latest update as of 4/10/2017: Are we able to specify how NULLs are treated in aggregate and windowing functions? I wasn't able to find any information about specifying the handling of NULLs in aggregrate and windowing functions. In parti...

Answers: 2

windowing_function Aggregate

GROUP BY and String Aggregate functions
answered 03-05-2017 03:18:14 -0400

I've made a View in Denodo VDP which is a UNION of two other "SELECT" views. Now I want to pivot some of the data in this new view; I use following query; ELECT primitivumnummer AS primitivumnummer, CASE WHEN ( hasname = 'txtNap' ) T...

Answers: 1


View Parameters and Aggregation
answered 02-03-2017 08:54:39 -0500

I am fairly new to Denodo and I have read through the Advanced VQL and VDP Administration Guide but I am not able to resolve the following issue: Sample Base View For the sake of this issue, let's consider a base with student, months and rank. ...

Answers: 4

parameter derived view Aggregate

How to stop Aggregate view from building sub query?
answered 15-10-2015 15:30:43 -0400

Does anyone recognize this pattern in Denodo? And preferably a way to prevent it? Base View (or any view) is selected by a Derived View which is aggregating data. And a filter is given to the Aggregate on one of the columns. Denodo is creating a la...

Answers: 1