Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Running SQL queries against in-memory data

  1. #1
    Join Date
    Jan 2006
    Posts
    25

    Default Running SQL queries against in-memory data

    A nice feature would be if we can run SQL queries on rows of data in-memory, something along the lines of a 'Filter Step'. This would allow the user to write an SQL query against the datasets extracted at various steps.

    Any thoughts?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Feel free to write it. Not impossible but it's a little tricky and would be as slow as a slug with a limp. The steps see each row one by one, so if you also would like group by, order by's in the SQL then all rows would have to be serialized (for big sets) and processed.

    I don't see it happening short time ... it's not really compatible with the framework.

    Regards,
    Sven
    Last edited by sboden; 09-07-2007 at 03:57 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.