Q&A BY TAG 'data aggregation'

I have a final UNION view between views with group by that have as data source a CSV file (so there is no database as source). When I execute the query on the union in the execution trace appears that an AGGREGATION PUSH-DOWN was done. But the push do...

static optimization data aggregation Optimization

Hi, I'm currently working on a Impala query where I want to calculate the sum of a field in a table, and I need to cast it as a double. However, I'm encountering an error, and I could use some assistance. SELECT SUM(CAST(fieldname AS double)) FROM ta...

datatype data aggregation

Hi, I am getting the following error message when I run my query - There was an error processing the privileges for this query. Does anyone know what this means and why it happens? I have access to all underlying views. This is the query structure I h...

data aggregation

Hi Team, I'm looking for ways to concatenate two or more row values using the "|" separator. I found and used the GROUP_CONCATE() function, but it doesn't work for me using the "DISTINCT" clause. Here is an example of a working and non-working query:...

data aggregation Group By

While calculating median. I am receiving the following error. [GROUPBY] [ERROR] java.lang.reflect.InvocationTargetException Received exception with message 'java.lang.reflect.InvocationTargetException' The logs are as follows: *ERROR 2021-05-31T09:38...

Denodo 8.0 Error data aggregation

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation

Dear Denodo Support Team, I am encountering below error while delegating the aggregate functions setting is unchecked. Error: Finished with error: Error executing query. Total time 0.117 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] ...

Denodo 6.0 Delegate nesting data aggregation delegation

Donedo platform 7 i have downloaded this trail version for POC, had one question about data aggregation as part of requirement. we need to call REST service which returns some data and that data needs to be fed to another Oracle sql query and get that ...

data aggregation