Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: MongoDB-Spoon "Group By" query help

  1. #1
    Join Date
    Jun 2012
    Posts
    2

    Default MongoDB-Spoon "Group By" query help

    I am using Spoon 4.3.0 and want to create a MongoDB Input. (consequently want to use it in reporting in pentaho server/designer)
    Where in I want to run a query expression which has GROUP BY in it.
    I tried taking help from query examples both from Pentaho and MongoDB sites.
    But I get JSON Parser error. I guess, I don't know even how to construct a query having GROUP BY.

    Can someone please help me out in this.

    For example something in SQL the query would be

    Select sum(quantity),sum(price)
    where customer = "xyz"
    group by product_name;

    Any help would be much appreciated!!

    Thanks.

  2. #2
    Join Date
    Aug 2006
    Posts
    1,741

    Default

    Group by is a new feature coming out for Mongo 2.2 as part of the aggregation framework:

    http://www.mongodb.org/display/DOCS/Aggregation

    We would need to add support for this to the MongoDb input step in PDI.

    Cheers,
    Mark.

  3. #3
    Join Date
    Jun 2012
    Posts
    2

    Default

    Thanks Mark.

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.