Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

pymongo aggregate don't allow explain option

I succesfully run:

result = my_col.aggregate(my_pipeline, allowDiskUse=True)

Now when I try:

result = my_col.aggregate(my_pipeline, allowDiskUse=True, explain=True)

it fails saying:

pymongo.errors.ConfigurationError: The explain option is not supported. Use Database.command instead.

Thus I try so as to add the needed option:

result = mydb.command('aggregate', 'mycol', my_pipeline, {'explain':True})

but it fails saying:

pymongo.errors.OperationFailure: 'pipeline' option must be specified as an array

What is wrong?

Thanks for any advice.

Christian

like image 214
Christian Arnault Avatar asked Apr 28 '17 09:04

Christian Arnault


1 Answers

Pass your pipeline using the "pipeline" keyword argument to "command":

db.command('aggregate', 'mycol', pipeline=my_pipeline, explain=True)

For example:

db.command('aggregate', 'mycol', pipeline=[{'$project': {'name': '$field'}}], explain=True)
like image 146
A. Jesse Jiryu Davis Avatar answered Nov 07 '22 19:11

A. Jesse Jiryu Davis