mongodb string to number

Question

I have document in mongodb 2.6.11 including array of string i.e.

{ cpu: [ '0', '2', '4', '0', '0', '2', '0', '4', '0' ],
 con: [ '232', '2396', '17082', '339', '5', '1738', '503', '4', '0' ] }

How do I convert them to numbers without saving in actual collection so I can use them in $project (aggregation) and later use in $group to calculate $avg?

db.checkpointstest3.aggregate([
    {$unwind: "$cpu"}])

I have correct $group , but it works on numbers not strings

Alex · Accepted Answer · 2016-02-05 20:19:47Z

2

Currently the aggregation pipeline does not allow for type conversion, see this JIRA ticket. If changing the type of your field is not an option, you either have to fall back on a map reduce query or write your own aggregation using forEach.

answered Feb 5, 2016 at 20:19

Alex

21.9k11 gold badges68 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mongodb string to number

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related