mongodb - how to calculate percentile -

-

i have access logs below, stored in mongodb instance:

time                          service                 latency [27/08/2013:11:19:22 +0000]    "post service http/1.1"    403 [27/08/2013:11:19:24 +0000]    "post service b http/1.1"    1022  [27/08/2013:11:22:10 +0000]    "post service http/1.1"    455

is there analytics function percentile_disc in oracle calculate percentile? ot calcualte latency percentiles on period of time.

there still appears no native way calculate percentiles combining few aggregate operators can same result.

db.items.aggregate([         {'$group': {             '_id': {                 'league': '$league',                 'base': '$base',                 'type': '$type'             },             'value': {'$push': '$chaosequiv'}         }},         {'$unwind': '$value'},         {'$sort': {'value': 1}},         {'$group': {'_id': '$_id', 'value': {'$push': '$value'}}},         {'$project': {             '_id': 1,             'value': {'$arrayelemat': ['$value', {'$floor': {'$multiply': [0.25, {'$size': '$value'}]}}]}         }}     ], allowdiskuse=true)

note wrote original code in pymongo problem needed group on 3 fields in first group may more complex necessary single field. write solution specific question don't think there enough specific information.


Comments

Post a Comment

Popular posts from this blog

design - Custom Styling Qt Quick Controls -

-
Image
i have custom design qt quick controls. example, change background colour of tool bar, since hate default design. how can that? in qt quick controls, there limited styling available via qt quick control styles items, buttonstyle , checkboxstyle , etc. at moment, other styles require delving qt sources , messing internal details. here complete example of how 1 might modify toolbar's style. main.qml import qtquick 2.1 import qtquick.layouts 1.0 import qtquick.controls 1.0 applicationwindow { toolbar: toolbar { id: toolbar component.oncompleted: toolbar.data[0].item.children = [newrectangle]; property item _newrectangle: rectangle { // rectangle within toolbarstyle's panel // gleaned from: // http://qt.gitorious.org/qt/qtquickcontrols/source/ // c304d741a27b5822a35d1fb83f8f5e65719907ce:src/styles/base/toolbarstyle.qml id: newrectangle anchors.fill: parent...
Read more

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more