Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Data limitation on Adhoc report

  1. #1

    Default Data limitation on Adhoc report

    Hello
    I have more than 60,000,000 records and I have created a report into metadata editor, when I want to execute report into Pentaho console, a low memory error is raised.
    I want to limit the number of record which Tomcat send to the Adhoc report and I want to display e.g. the first 2000 records. could any one say me, how could I limit the number of records.
    Hint: I don't want to use limit in select statement at metadata editor level because I have some aggregation function and it has to calculate on all of the data band.


    Thanks
    Last edited by fariborzgolara; 12-19-2011 at 05:06 AM.

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.