Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: "GROUP BY" not performed in DB on BI Report Maker

  1. #1

    Exclamation "GROUP BY" not performed in DB on BI Report Maker

    Greetings amigos,

    Running into an odd problem on v. 4.5 of BI server (whatever the latest GA is).

    We're using the pentaho-bi-ce and using the "Ad-Hoc Report Designer" with a data source as a single table on a SQL db.

    I make a new report, select some Level 1 and Level 2 groups, some details with a COUNT aggregation, and generate the preview.

    We watch the queries coming into the DB. But the query doesn't have any GROUP BY. It just does a SELECT, pulls in all the rows, then I guess pentaho aggregates the results internally?

    Since our datasets can be several TB...this is a big problem.

    The DB we're running is a home-built SQL database with a compliant JDBC driver.
    Last edited by lusciouspear; 06-12-2012 at 11:47 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.