Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Mongodb input plugin Error: allowDiskUse parameter

  1. #1
    Join Date
    Oct 2012
    Posts
    2

    Default Mongodb input plugin Error: allowDiskUse parameter

    Hi,
    pentaho v.6.1 and 7.0 (the same issue for both)
    mongodb server 3.4 (i've tried also with the 3.0)
    i'm trying with no success the query above (tested and running with no problem in mongo shell).
    I've tried to mix in every way the composition of the query.
    The red part is the part i've added in the mongo shell
    I've inserted the above query (without red words) in the Tab Query of the Mongodb plugin and i've checked the flag "query is aggregation pipeline"
    db.dati.aggregate(
    [{$group:{_id:{"TARGA_IMPIANTO":"$TARGA_IMPIANTO","GENERATORE_CATEGORIA":"$GENERATORE_CATEGORIA","GENERATORE_PROGRESSIVO":"$GENERATORE_PROGRESSIVO"},count:{$sum:1}}}, {$sort : {TARGA_IMPIANTO : -1 }}], {allowDiskUse:true}
    );

    If you try to run this query on a little database it runs.
    My goal is to find out every record with more than one repetition of the three grouped fields

    These are the messages i receive:
    Exceeded memory limit for $group .....Pass allowDiskUse:true to opt in (alloDiskUse without json notation {})
    or
    errmsg" : "Unrecognized pipeline stage name: 'allowDiskUse'" , if i use json notation for allowDiskUse.
    Could please anyone try to help me ?
    Thanks in advance
    Regards
    Sandro
    Last edited by sandroso; 12-06-2016 at 06:55 AM.

  2. #2

    Default

    Did you tick the "Query in aggregation pipeline" on "Query tab", if not please tick that and try once.

  3. #3
    Join Date
    Oct 2012
    Posts
    2

    Default

    Yessss, i've checked it

Tags for this Thread

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.