Selector (like max, min, first, etc) return a string instead of timestamp

[victorhooi]

This was originally raised as grafana/grafana#2930 - however, it appears to be an issue in InfluxDB

tl;dr - max() is returning strings instead of timestamps

I'm attempting to use Grafana to graph some sparse points stored in InflxuDB.

I am running InfluxDB nightly (0.9.5-nightly-f1e0c59)

For some odd reason, it works fine with mean(), but not with max().

This is the graph with mean():

The request:

Request URL:http://insight.mongodb-field.com:3000/api/datasources/proxy/1/query?epoch=ms&q=SELECT+mean(%22duration_in_milliseconds%22)+AS+%22duration_in_milliseconds%22+FROM+%22operations%22+WHERE+%22project%22+%3D+%27CS-23893%27+AND+time+%3E+1444398692s+and+time+%3C+1444398768s+GROUP+BY+time(100ms)

The response:

{"results":[{"series":[{"name":"operations","columns":["time","duration_in_milliseconds"],"values":[[1444398692000,null],[1444398692100,null],[1444398692200,null],[1444398692300,null],[1444398692400,null],[1444398692500,null],[1444398692600,null],[1444398692700,null],[1444398692800,null],[1444398692900,null],[1444398693000,null],[1444398693100,null],[1444398693200,null],[1444398693300,null],[1444398693400,null],[1444398693500,null],[1444398693600,null],[1444398693700,null],[1444398693800,null],[1444398693900,null],[1444398694000,null],[1444398694100,null],[1444398694200,null],[1444398694300,null],[1444398694400,null],[1444398694500,null],[1444398694600,null],[1444398694700,null],[1444398694800,611],[1444398694900,null],[1444398695000,null],[1444398695100,null],[1444398695200,null],[1444398695300,null],[1444398695400,null],[1444398695500,null],[1444398695600,null],[1444398695700,null],[1444398695800,null],[1444398695900,null],[1444398696000,null],[1444398696100,null],[1444398696200,null],[1444398696300,null],[1444398696400,null],[1444398696500,null],[1444398696600,null],[1444398696700,null],[1444398696800,null],[1444398696900,null],[1444398697000,null],[1444398697100,null],[1444398697200,null],[1444398697300,null],[1444398697400,null],[1444398697500,null],[1444398697600,null],[1444398697700,null],[1444398697800,null],[1444398697900,null],[1444398698000,null],[1444398698100,null],[1444398698200,null],[1444398698300,null],[1444398698400,null],[1444398698500,null],[1444398698600,null],[1444398698700,null],[1444398698800,null],[1444398698900,null],[1444398699000,null],[1444398699100,null],[1444398699200,null],[1444398699300,null],[1444398699400,null],[1444398699500,null],[1444398699600,null],[1444398699700,null],[1444398699800,null],[1444398699900,null],[1444398700000,null],[1444398700100,null],[1444398700200,null],[1444398700300,null],[1444398700400,null],[1444398700500,null],[1444398700600,null],[1444398700700,null],[1444398700800,null],[1444398700900,null],[1444398701000,null],[1444398701100,null],[1444398701200,null],[1444398701300,null],[1444398701400,null],[1444398701500,null],[1444398701600,null],[1444398701700,null],[1444398701800,null],[1444398701900,null],[1444398702000,null],[1444398702100,null],[1444398702200,null],[1444398702300,null],[1444398702400,null],[1444398702500,null],[1444398702600,null],[1444398702700,null],[1444398702800,null],[1444398702900,null],[1444398703000,null],[1444398703100,null],[1444398703200,null],[1444398703300,null],[1444398703400,null],[1444398703500,null],[1444398703600,null],[1444398703700,null],[1444398703800,null],[1444398703900,null],[1444398704000,null],[1444398704100,null],[1444398704200,null],[1444398704300,null],[1444398704400,null],[1444398704500,null],[1444398704600,null],[1444398704700,null],[1444398704800,null],[1444398704900,null],[1444398705000,null],[1444398705100,null],[1444398705200,null],[1444398705300,null],[1444398705400,null],[1444398705500,null],[1444398705600,null],[1444398705700,null],[1444398705800,null],[1444398705900,null],[1444398706000,null],[1444398706100,null],[1444398706200,null],[1444398706300,763],[1444398706400,null],[1444398706500,null],[1444398706600,null],[1444398706700,null],[1444398706800,null],[1444398706900,null],[1444398707000,null],[1444398707100,null],[1444398707200,null],[1444398707300,null],[1444398707400,null],[1444398707500,null],[1444398707600,null],[1444398707700,null],[1444398707800,null],[1444398707900,null],[1444398708000,null],[1444398708100,null],[1444398708200,null],[1444398708300,null],[1444398708400,null],[1444398708500,null],[1444398708600,null],[1444398708700,null],[1444398708800,null],[1444398708900,null],[1444398709000,null],[1444398709100,null],[1444398709200,null],[1444398709300,null],[1444398709400,null],[1444398709500,null],[1444398709600,null],[1444398709700,null],[1444398709800,null],[1444398709900,null],[1444398710000,null],[1444398710100,null],[1444398710200,null],[1444398710300,null],[1444398710400,null],[1444398710500,null],[1444398710600,null],[1444398710700,null],[1444398710800,null],[1444398710900,null],[1444398711000,null],[1444398711100,null],[1444398711200,null],[1444398711300,null],[1444398711400,null],[1444398711500,null],[1444398711600,null],[1444398711700,null],[1444398711800,null],[1444398711900,null],[1444398712000,null],[1444398712100,null],[1444398712200,null],[1444398712300,null],[1444398712400,null],[1444398712500,null],[1444398712600,null],[1444398712700,null],[1444398712800,null],[1444398712900,null],[1444398713000,null],[1444398713100,null],[1444398713200,null],[1444398713300,null],[1444398713400,null],[1444398713500,null],[1444398713600,null],[1444398713700,null],[1444398713800,null],[1444398713900,null],[1444398714000,null],[1444398714100,null],[1444398714200,null],[1444398714300,null],[1444398714400,null],[1444398714500,null],[1444398714600,null],[1444398714700,null],[1444398714800,null],[1444398714900,null],[1444398715000,null],[1444398715100,null],[1444398715200,null],[1444398715300,null],[1444398715400,null],[1444398715500,null],[1444398715600,null],[1444398715700,null],[1444398715800,null],[1444398715900,null],[1444398716000,null],[1444398716100,null],[1444398716200,null],[1444398716300,1249],[1444398716400,null],[1444398716500,null],[1444398716600,null],[1444398716700,null],[1444398716800,null],[1444398716900,null],[1444398717000,null],[1444398717100,null],[1444398717200,null],[1444398717300,null],[1444398717400,null],[1444398717500,null],[1444398717600,null],[1444398717700,null],[1444398717800,null],[1444398717900,null],[1444398718000,null],[1444398718100,null],[1444398718200,null],[1444398718300,null],[1444398718400,null],[1444398718500,null],[1444398718600,null],[1444398718700,null],[1444398718800,null],[1444398718900,null],[1444398719000,null],[1444398719100,null],[1444398719200,null],[1444398719300,null],[1444398719400,null],[1444398719500,null],[1444398719600,null],[1444398719700,null],[1444398719800,null],[1444398719900,null],[1444398720000,null],[1444398720100,null],[1444398720200,null],[1444398720300,null],[1444398720400,null],[1444398720500,null],[1444398720600,null],[1444398720700,null],[1444398720800,null],[1444398720900,null],[1444398721000,null],[1444398721100,null],[1444398721200,null],[1444398721300,null],[1444398721400,null],[1444398721500,null],[1444398721600,null],[1444398721700,null],[1444398721800,null],[1444398721900,null],[1444398722000,null],[1444398722100,null],[1444398722200,null],[1444398722300,null],[1444398722400,null],[1444398722500,null],[1444398722600,null],[1444398722700,null],[1444398722800,null],[1444398722900,null],[1444398723000,null],[1444398723100,null],[1444398723200,null],[1444398723300,null],[1444398723400,null],[1444398723500,null],[1444398723600,null],[1444398723700,null],[1444398723800,null],[1444398723900,null],[1444398724000,null],[1444398724100,null],[1444398724200,null],[1444398724300,null],[1444398724400,null],[1444398724500,null],[1444398724600,null],[1444398724700,null],[1444398724800,null],[1444398724900,null],[1444398725000,null],[1444398725100,null],[1444398725200,null],[1444398725300,null],[1444398725400,null],[1444398725500,null],[1444398725600,null],[1444398725700,null],[1444398725800,null],[1444398725900,null],[1444398726000,null],[1444398726100,null],[1444398726200,null],[1444398726300,null],[1444398726400,null],[1444398726500,null],[1444398726600,null],[1444398726700,null],[1444398726800,null],[1444398726900,null],[1444398727000,null],[1444398727100,null],[1444398727200,null],[1444398727300,null],[1444398727400,null],[1444398727500,null],[1444398727600,null],[1444398727700,null],[1444398727800,null],[1444398727900,null],[1444398728000,null],[1444398728100,null],[1444398728200,null],[1444398728300,null],[1444398728400,null],[1444398728500,null],[1444398728600,null],[1444398728700,null],[1444398728800,null],[1444398728900,null],[1444398729000,null],[1444398729100,null],[1444398729200,null],[1444398729300,null],[1444398729400,null],[1444398729500,null],[1444398729600,null],[1444398729700,null],[1444398729800,null],[1444398729900,null],[1444398730000,null],[1444398730100,null],[1444398730200,null],[1444398730300,null],[1444398730400,null],[1444398730500,3535],[1444398730600,null],[1444398730700,null],[1444398730800,null],[1444398730900,null],[1444398731000,null],[1444398731100,null],[1444398731200,null],[1444398731300,null],[1444398731400,null],[1444398731500,null],[1444398731600,null],[1444398731700,null],[1444398731800,null],[1444398731900,null],[1444398732000,null],[1444398732100,null],[1444398732200,null],[1444398732300,null],[1444398732400,null],[1444398732500,null],[1444398732600,null],[1444398732700,null],[1444398732800,null],[1444398732900,null],[1444398733000,null],[1444398733100,null],[1444398733200,null],[1444398733300,null],[1444398733400,null],[1444398733500,null],[1444398733600,null],[1444398733700,null],[1444398733800,null],[1444398733900,null],[1444398734000,null],[1444398734100,null],[1444398734200,null],[1444398734300,null],[1444398734400,null],[1444398734500,null],[1444398734600,null],[1444398734700,null],[1444398734800,null],[1444398734900,null],[1444398735000,null],[1444398735100,null],[1444398735200,null],[1444398735300,null],[1444398735400,null],[1444398735500,null],[1444398735600,null],[1444398735700,null],[1444398735800,null],[1444398735900,null],[1444398736000,null],[1444398736100,null],[1444398736200,null],[1444398736300,null],[1444398736400,null],[1444398736500,null],[1444398736600,null],[1444398736700,null],[1444398736800,null],[1444398736900,null],[1444398737000,null],[1444398737100,null],[1444398737200,null],[1444398737300,null],[1444398737400,null],[1444398737500,null],[1444398737600,657],[1444398737700,null],[1444398737800,null],[1444398737900,null],[1444398738000,null],[1444398738100,null],[1444398738200,null],[1444398738300,null],[1444398738400,null],[1444398738500,null],[1444398738600,null],[1444398738700,null],[1444398738800,null],[1444398738900,null],[1444398739000,null],[1444398739100,null],[1444398739200,null],[1444398739300,null],[1444398739400,null],[1444398739500,null],[1444398739600,null],[1444398739700,null],[1444398739800,null],[1444398739900,null],[1444398740000,null],[1444398740100,null],[1444398740200,null],[1444398740300,null],[1444398740400,null],[1444398740500,null],[1444398740600,null],[1444398740700,null],[1444398740800,null],[1444398740900,null],[1444398741000,null],[1444398741100,null],[1444398741200,null],[1444398741300,null],[1444398741400,null],[1444398741500,null],[1444398741600,null],[1444398741700,null],[1444398741800,null],[1444398741900,null],[1444398742000,null],[1444398742100,null],[1444398742200,null],[1444398742300,null],[1444398742400,null],[1444398742500,null],[1444398742600,null],[1444398742700,null],[1444398742800,null],[1444398742900,null],[1444398743000,null],[1444398743100,null],[1444398743200,null],[1444398743300,null],[1444398743400,null],[1444398743500,null],[1444398743600,null],[1444398743700,null],[1444398743800,null],[1444398743900,null],[1444398744000,null],[1444398744100,null],[1444398744200,null],[1444398744300,null],[1444398744400,null],[1444398744500,null],[1444398744600,null],[1444398744700,null],[1444398744800,null],[1444398744900,null],[1444398745000,null],[1444398745100,null],[1444398745200,null],[1444398745300,null],[1444398745400,null],[1444398745500,null],[1444398745600,null],[1444398745700,null],[1444398745800,null],[1444398745900,null],[1444398746000,null],[1444398746100,null],[1444398746200,null],[1444398746300,null],[1444398746400,null],[1444398746500,null],[1444398746600,null],[1444398746700,null],[1444398746800,null],[1444398746900,null],[1444398747000,null],[1444398747100,null],[1444398747200,null],[1444398747300,null],[1444398747400,null],[1444398747500,null],[1444398747600,null],[1444398747700,null],[1444398747800,null],[1444398747900,null],[1444398748000,null],[1444398748100,null],[1444398748200,null],[1444398748300,null],[1444398748400,null],[1444398748500,null],[1444398748600,null],[1444398748700,null],[1444398748800,null],[1444398748900,null],[1444398749000,null],[1444398749100,null],[1444398749200,null],[1444398749300,null],[1444398749400,null],[1444398749500,null],[1444398749600,null],[1444398749700,null],[1444398749800,null],[1444398749900,null],[1444398750000,null],[1444398750100,null],[1444398750200,null],[1444398750300,null],[1444398750400,null],[1444398750500,null],[1444398750600,null],[1444398750700,null],[1444398750800,null],[1444398750900,null],[1444398751000,null],[1444398751100,null],[1444398751200,null],[1444398751300,null],[1444398751400,null],[1444398751500,null],[1444398751600,null],[1444398751700,null],[1444398751800,439],[1444398751900,null],[1444398752000,null],[1444398752100,null],[1444398752200,null],[1444398752300,null],[1444398752400,null],[1444398752500,null],[1444398752600,null],[1444398752700,null],[1444398752800,null],[1444398752900,null],[1444398753000,null],[1444398753100,null],[1444398753200,null],[1444398753300,null],[1444398753400,null],[1444398753500,null],[1444398753600,null],[1444398753700,null],[1444398753800,null],[1444398753900,null],[1444398754000,null],[1444398754100,null],[1444398754200,null],[1444398754300,null],[1444398754400,null],[1444398754500,null],[1444398754600,null],[1444398754700,null],[1444398754800,null],[1444398754900,null],[1444398755000,null],[1444398755100,null],[1444398755200,null],[1444398755300,null],[1444398755400,null],[1444398755500,null],[1444398755600,null],[1444398755700,null],[1444398755800,null],[1444398755900,null],[1444398756000,null],[1444398756100,null],[1444398756200,null],[1444398756300,null],[1444398756400,null],[1444398756500,null],[1444398756600,null],[1444398756700,null],[1444398756800,null],[1444398756900,null],[1444398757000,null],[1444398757100,null],[1444398757200,null],[1444398757300,null],[1444398757400,null],[1444398757500,null],[1444398757600,null],[1444398757700,null],[1444398757800,null],[1444398757900,null],[1444398758000,null],[1444398758100,null],[1444398758200,null],[1444398758300,null],[1444398758400,null],[1444398758500,null],[1444398758600,null],[1444398758700,null],[1444398758800,null],[1444398758900,null],[1444398759000,null],[1444398759100,null],[1444398759200,null],[1444398759300,null],[1444398759400,null],[1444398759500,null],[1444398759600,null],[1444398759700,null],[1444398759800,null],[1444398759900,null],[1444398760000,null],[1444398760100,null],[1444398760200,null],[1444398760300,null],[1444398760400,null],[1444398760500,null],[1444398760600,null],[1444398760700,null],[1444398760800,null],[1444398760900,null],[1444398761000,null],[1444398761100,null],[1444398761200,null],[1444398761300,null],[1444398761400,null],[1444398761500,null],[1444398761600,null],[1444398761700,3657],[1444398761800,null],[1444398761900,null],[1444398762000,null],[1444398762100,null],[1444398762200,null],[1444398762300,null],[1444398762400,null],[1444398762500,null],[1444398762600,null],[1444398762700,null],[1444398762800,null],[1444398762900,null],[1444398763000,null],[1444398763100,null],[1444398763200,null],[1444398763300,null],[1444398763400,null],[1444398763500,null],[1444398763600,null],[1444398763700,null],[1444398763800,null],[1444398763900,null],[1444398764000,null],[1444398764100,null],[1444398764200,null],[1444398764300,null],[1444398764400,null],[1444398764500,null],[1444398764600,null],[1444398764700,null],[1444398764800,null],[1444398764900,null],[1444398765000,null],[1444398765100,null],[1444398765200,null],[1444398765300,null],[1444398765400,null],[1444398765500,null],[1444398765600,null],[1444398765700,null],[1444398765800,null],[1444398765900,null],[1444398766000,null],[1444398766100,null],[1444398766200,null],[1444398766300,null],[1444398766400,null],[1444398766500,null],[1444398766600,null],[1444398766700,null],[1444398766800,null],[1444398766900,null],[1444398767000,null],[1444398767100,null],[1444398767200,null],[1444398767300,null],[1444398767400,null],[1444398767500,null],[1444398767600,null],[1444398767700,null],[1444398767800,null],[1444398767900,null]]}]}]}

However, if I switch to max(), I get an empty graph:

This is the request:

Request URL:http://insight.mongodb-field.com:3000/api/datasources/proxy/1/query?epoch=ms&q=SELECT+max(%22duration_in_milliseconds%22)+AS+%22duration_in_milliseconds%22+FROM+%22operations%22+WHERE+%22project%22+%3D+%27CS-23893%27+AND+time+%3E+1444398692s+and+time+%3C+1444398768s+GROUP+BY+time(100ms)

This is the response:

{"results":[{"series":[{"name":"operations","columns":["time","duration_in_milliseconds"],"values":[[1444398692000,null],[1444398692100,null],[1444398692200,null],[1444398692300,null],[1444398692400,null],[1444398692500,null],[1444398692600,null],[1444398692700,null],[1444398692800,null],[1444398692900,null],[1444398693000,null],[1444398693100,null],[1444398693200,null],[1444398693300,null],[1444398693400,null],[1444398693500,null],[1444398693600,null],[1444398693700,null],[1444398693800,null],[1444398693900,null],[1444398694000,null],[1444398694100,null],[1444398694200,null],[1444398694300,null],[1444398694400,null],[1444398694500,null],[1444398694600,null],[1444398694700,null],["2015-10-09T13:51:34.8Z",611],[1444398694900,null],[1444398695000,null],[1444398695100,null],[1444398695200,null],[1444398695300,null],[1444398695400,null],[1444398695500,null],[1444398695600,null],[1444398695700,null],[1444398695800,null],[1444398695900,null],[1444398696000,null],[1444398696100,null],[1444398696200,null],[1444398696300,null],[1444398696400,null],[1444398696500,null],[1444398696600,null],[1444398696700,null],[1444398696800,null],[1444398696900,null],[1444398697000,null],[1444398697100,null],[1444398697200,null],[1444398697300,null],[1444398697400,null],[1444398697500,null],[1444398697600,null],[1444398697700,null],[1444398697800,null],[1444398697900,null],[1444398698000,null],[1444398698100,null],[1444398698200,null],[1444398698300,null],[1444398698400,null],[1444398698500,null],[1444398698600,null],[1444398698700,null],[1444398698800,null],[1444398698900,null],[1444398699000,null],[1444398699100,null],[1444398699200,null],[1444398699300,null],[1444398699400,null],[1444398699500,null],[1444398699600,null],[1444398699700,null],[1444398699800,null],[1444398699900,null],[1444398700000,null],[1444398700100,null],[1444398700200,null],[1444398700300,null],[1444398700400,null],[1444398700500,null],[1444398700600,null],[1444398700700,null],[1444398700800,null],[1444398700900,null],[1444398701000,null],[1444398701100,null],[1444398701200,null],[1444398701300,null],[1444398701400,null],[1444398701500,null],[1444398701600,null],[1444398701700,null],[1444398701800,null],[1444398701900,null],[1444398702000,null],[1444398702100,null],[1444398702200,null],[1444398702300,null],[1444398702400,null],[1444398702500,null],[1444398702600,null],[1444398702700,null],[1444398702800,null],[1444398702900,null],[1444398703000,null],[1444398703100,null],[1444398703200,null],[1444398703300,null],[1444398703400,null],[1444398703500,null],[1444398703600,null],[1444398703700,null],[1444398703800,null],[1444398703900,null],[1444398704000,null],[1444398704100,null],[1444398704200,null],[1444398704300,null],[1444398704400,null],[1444398704500,null],[1444398704600,null],[1444398704700,null],[1444398704800,null],[1444398704900,null],[1444398705000,null],[1444398705100,null],[1444398705200,null],[1444398705300,null],[1444398705400,null],[1444398705500,null],[1444398705600,null],[1444398705700,null],[1444398705800,null],[1444398705900,null],[1444398706000,null],[1444398706100,null],[1444398706200,null],["2015-10-09T13:51:46.3Z",763],[1444398706400,null],[1444398706500,null],[1444398706600,null],[1444398706700,null],[1444398706800,null],[1444398706900,null],[1444398707000,null],[1444398707100,null],[1444398707200,null],[1444398707300,null],[1444398707400,null],[1444398707500,null],[1444398707600,null],[1444398707700,null],[1444398707800,null],[1444398707900,null],[1444398708000,null],[1444398708100,null],[1444398708200,null],[1444398708300,null],[1444398708400,null],[1444398708500,null],[1444398708600,null],[1444398708700,null],[1444398708800,null],[1444398708900,null],[1444398709000,null],[1444398709100,null],[1444398709200,null],[1444398709300,null],[1444398709400,null],[1444398709500,null],[1444398709600,null],[1444398709700,null],[1444398709800,null],[1444398709900,null],[1444398710000,null],[1444398710100,null],[1444398710200,null],[1444398710300,null],[1444398710400,null],[1444398710500,null],[1444398710600,null],[1444398710700,null],[1444398710800,null],[1444398710900,null],[1444398711000,null],[1444398711100,null],[1444398711200,null],[1444398711300,null],[1444398711400,null],[1444398711500,null],[1444398711600,null],[1444398711700,null],[1444398711800,null],[1444398711900,null],[1444398712000,null],[1444398712100,null],[1444398712200,null],[1444398712300,null],[1444398712400,null],[1444398712500,null],[1444398712600,null],[1444398712700,null],[1444398712800,null],[1444398712900,null],[1444398713000,null],[1444398713100,null],[1444398713200,null],[1444398713300,null],[1444398713400,null],[1444398713500,null],[1444398713600,null],[1444398713700,null],[1444398713800,null],[1444398713900,null],[1444398714000,null],[1444398714100,null],[1444398714200,null],[1444398714300,null],[1444398714400,null],[1444398714500,null],[1444398714600,null],[1444398714700,null],[1444398714800,null],[1444398714900,null],[1444398715000,null],[1444398715100,null],[1444398715200,null],[1444398715300,null],[1444398715400,null],[1444398715500,null],[1444398715600,null],[1444398715700,null],[1444398715800,null],[1444398715900,null],[1444398716000,null],[1444398716100,null],[1444398716200,null],["2015-10-09T13:51:56.3Z",1249],[1444398716400,null],[1444398716500,null],[1444398716600,null],[1444398716700,null],[1444398716800,null],[1444398716900,null],[1444398717000,null],[1444398717100,null],[1444398717200,null],[1444398717300,null],[1444398717400,null],[1444398717500,null],[1444398717600,null],[1444398717700,null],[1444398717800,null],[1444398717900,null],[1444398718000,null],[1444398718100,null],[1444398718200,null],[1444398718300,null],[1444398718400,null],[1444398718500,null],[1444398718600,null],[1444398718700,null],[1444398718800,null],[1444398718900,null],[1444398719000,null],[1444398719100,null],[1444398719200,null],[1444398719300,null],[1444398719400,null],[1444398719500,null],[1444398719600,null],[1444398719700,null],[1444398719800,null],[1444398719900,null],[1444398720000,null],[1444398720100,null],[1444398720200,null],[1444398720300,null],[1444398720400,null],[1444398720500,null],[1444398720600,null],[1444398720700,null],[1444398720800,null],[1444398720900,null],[1444398721000,null],[1444398721100,null],[1444398721200,null],[1444398721300,null],[1444398721400,null],[1444398721500,null],[1444398721600,null],[1444398721700,null],[1444398721800,null],[1444398721900,null],[1444398722000,null],[1444398722100,null],[1444398722200,null],[1444398722300,null],[1444398722400,null],[1444398722500,null],[1444398722600,null],[1444398722700,null],[1444398722800,null],[1444398722900,null],[1444398723000,null],[1444398723100,null],[1444398723200,null],[1444398723300,null],[1444398723400,null],[1444398723500,null],[1444398723600,null],[1444398723700,null],[1444398723800,null],[1444398723900,null],[1444398724000,null],[1444398724100,null],[1444398724200,null],[1444398724300,null],[1444398724400,null],[1444398724500,null],[1444398724600,null],[1444398724700,null],[1444398724800,null],[1444398724900,null],[1444398725000,null],[1444398725100,null],[1444398725200,null],[1444398725300,null],[1444398725400,null],[1444398725500,null],[1444398725600,null],[1444398725700,null],[1444398725800,null],[1444398725900,null],[1444398726000,null],[1444398726100,null],[1444398726200,null],[1444398726300,null],[1444398726400,null],[1444398726500,null],[1444398726600,null],[1444398726700,null],[1444398726800,null],[1444398726900,null],[1444398727000,null],[1444398727100,null],[1444398727200,null],[1444398727300,null],[1444398727400,null],[1444398727500,null],[1444398727600,null],[1444398727700,null],[1444398727800,null],[1444398727900,null],[1444398728000,null],[1444398728100,null],[1444398728200,null],[1444398728300,null],[1444398728400,null],[1444398728500,null],[1444398728600,null],[1444398728700,null],[1444398728800,null],[1444398728900,null],[1444398729000,null],[1444398729100,null],[1444398729200,null],[1444398729300,null],[1444398729400,null],[1444398729500,null],[1444398729600,null],[1444398729700,null],[1444398729800,null],[1444398729900,null],[1444398730000,null],[1444398730100,null],[1444398730200,null],[1444398730300,null],[1444398730400,null],["2015-10-09T13:52:10.5Z",3535],[1444398730600,null],[1444398730700,null],[1444398730800,null],[1444398730900,null],[1444398731000,null],[1444398731100,null],[1444398731200,null],[1444398731300,null],[1444398731400,null],[1444398731500,null],[1444398731600,null],[1444398731700,null],[1444398731800,null],[1444398731900,null],[1444398732000,null],[1444398732100,null],[1444398732200,null],[1444398732300,null],[1444398732400,null],[1444398732500,null],[1444398732600,null],[1444398732700,null],[1444398732800,null],[1444398732900,null],[1444398733000,null],[1444398733100,null],[1444398733200,null],[1444398733300,null],[1444398733400,null],[1444398733500,null],[1444398733600,null],[1444398733700,null],[1444398733800,null],[1444398733900,null],[1444398734000,null],[1444398734100,null],[1444398734200,null],[1444398734300,null],[1444398734400,null],[1444398734500,null],[1444398734600,null],[1444398734700,null],[1444398734800,null],[1444398734900,null],[1444398735000,null],[1444398735100,null],[1444398735200,null],[1444398735300,null],[1444398735400,null],[1444398735500,null],[1444398735600,null],[1444398735700,null],[1444398735800,null],[1444398735900,null],[1444398736000,null],[1444398736100,null],[1444398736200,null],[1444398736300,null],[1444398736400,null],[1444398736500,null],[1444398736600,null],[1444398736700,null],[1444398736800,null],[1444398736900,null],[1444398737000,null],[1444398737100,null],[1444398737200,null],[1444398737300,null],[1444398737400,null],[1444398737500,null],["2015-10-09T13:52:17.6Z",657],[1444398737700,null],[1444398737800,null],[1444398737900,null],[1444398738000,null],[1444398738100,null],[1444398738200,null],[1444398738300,null],[1444398738400,null],[1444398738500,null],[1444398738600,null],[1444398738700,null],[1444398738800,null],[1444398738900,null],[1444398739000,null],[1444398739100,null],[1444398739200,null],[1444398739300,null],[1444398739400,null],[1444398739500,null],[1444398739600,null],[1444398739700,null],[1444398739800,null],[1444398739900,null],[1444398740000,null],[1444398740100,null],[1444398740200,null],[1444398740300,null],[1444398740400,null],[1444398740500,null],[1444398740600,null],[1444398740700,null],[1444398740800,null],[1444398740900,null],[1444398741000,null],[1444398741100,null],[1444398741200,null],[1444398741300,null],[1444398741400,null],[1444398741500,null],[1444398741600,null],[1444398741700,null],[1444398741800,null],[1444398741900,null],[1444398742000,null],[1444398742100,null],[1444398742200,null],[1444398742300,null],[1444398742400,null],[1444398742500,null],[1444398742600,null],[1444398742700,null],[1444398742800,null],[1444398742900,null],[1444398743000,null],[1444398743100,null],[1444398743200,null],[1444398743300,null],[1444398743400,null],[1444398743500,null],[1444398743600,null],[1444398743700,null],[1444398743800,null],[1444398743900,null],[1444398744000,null],[1444398744100,null],[1444398744200,null],[1444398744300,null],[1444398744400,null],[1444398744500,null],[1444398744600,null],[1444398744700,null],[1444398744800,null],[1444398744900,null],[1444398745000,null],[1444398745100,null],[1444398745200,null],[1444398745300,null],[1444398745400,null],[1444398745500,null],[1444398745600,null],[1444398745700,null],[1444398745800,null],[1444398745900,null],[1444398746000,null],[1444398746100,null],[1444398746200,null],[1444398746300,null],[1444398746400,null],[1444398746500,null],[1444398746600,null],[1444398746700,null],[1444398746800,null],[1444398746900,null],[1444398747000,null],[1444398747100,null],[1444398747200,null],[1444398747300,null],[1444398747400,null],[1444398747500,null],[1444398747600,null],[1444398747700,null],[1444398747800,null],[1444398747900,null],[1444398748000,null],[1444398748100,null],[1444398748200,null],[1444398748300,null],[1444398748400,null],[1444398748500,null],[1444398748600,null],[1444398748700,null],[1444398748800,null],[1444398748900,null],[1444398749000,null],[1444398749100,null],[1444398749200,null],[1444398749300,null],[1444398749400,null],[1444398749500,null],[1444398749600,null],[1444398749700,null],[1444398749800,null],[1444398749900,null],[1444398750000,null],[1444398750100,null],[1444398750200,null],[1444398750300,null],[1444398750400,null],[1444398750500,null],[1444398750600,null],[1444398750700,null],[1444398750800,null],[1444398750900,null],[1444398751000,null],[1444398751100,null],[1444398751200,null],[1444398751300,null],[1444398751400,null],[1444398751500,null],[1444398751600,null],[1444398751700,null],["2015-10-09T13:52:31.8Z",439],[1444398751900,null],[1444398752000,null],[1444398752100,null],[1444398752200,null],[1444398752300,null],[1444398752400,null],[1444398752500,null],[1444398752600,null],[1444398752700,null],[1444398752800,null],[1444398752900,null],[1444398753000,null],[1444398753100,null],[1444398753200,null],[1444398753300,null],[1444398753400,null],[1444398753500,null],[1444398753600,null],[1444398753700,null],[1444398753800,null],[1444398753900,null],[1444398754000,null],[1444398754100,null],[1444398754200,null],[1444398754300,null],[1444398754400,null],[1444398754500,null],[1444398754600,null],[1444398754700,null],[1444398754800,null],[1444398754900,null],[1444398755000,null],[1444398755100,null],[1444398755200,null],[1444398755300,null],[1444398755400,null],[1444398755500,null],[1444398755600,null],[1444398755700,null],[1444398755800,null],[1444398755900,null],[1444398756000,null],[1444398756100,null],[1444398756200,null],[1444398756300,null],[1444398756400,null],[1444398756500,null],[1444398756600,null],[1444398756700,null],[1444398756800,null],[1444398756900,null],[1444398757000,null],[1444398757100,null],[1444398757200,null],[1444398757300,null],[1444398757400,null],[1444398757500,null],[1444398757600,null],[1444398757700,null],[1444398757800,null],[1444398757900,null],[1444398758000,null],[1444398758100,null],[1444398758200,null],[1444398758300,null],[1444398758400,null],[1444398758500,null],[1444398758600,null],[1444398758700,null],[1444398758800,null],[1444398758900,null],[1444398759000,null],[1444398759100,null],[1444398759200,null],[1444398759300,null],[1444398759400,null],[1444398759500,null],[1444398759600,null],[1444398759700,null],[1444398759800,null],[1444398759900,null],[1444398760000,null],[1444398760100,null],[1444398760200,null],[1444398760300,null],[1444398760400,null],[1444398760500,null],[1444398760600,null],[1444398760700,null],[1444398760800,null],[1444398760900,null],[1444398761000,null],[1444398761100,null],[1444398761200,null],[1444398761300,null],[1444398761400,null],[1444398761500,null],[1444398761600,null],["2015-10-09T13:52:41.7Z",3657],[1444398761800,null],[1444398761900,null],[1444398762000,null],[1444398762100,null],[1444398762200,null],[1444398762300,null],[1444398762400,null],[1444398762500,null],[1444398762600,null],[1444398762700,null],[1444398762800,null],[1444398762900,null],[1444398763000,null],[1444398763100,null],[1444398763200,null],[1444398763300,null],[1444398763400,null],[1444398763500,null],[1444398763600,null],[1444398763700,null],[1444398763800,null],[1444398763900,null],[1444398764000,null],[1444398764100,null],[1444398764200,null],[1444398764300,null],[1444398764400,null],[1444398764500,null],[1444398764600,null],[1444398764700,null],[1444398764800,null],[1444398764900,null],[1444398765000,null],[1444398765100,null],[1444398765200,null],[1444398765300,null],[1444398765400,null],[1444398765500,null],[1444398765600,null],[1444398765700,null],[1444398765800,null],[1444398765900,null],[1444398766000,null],[1444398766100,null],[1444398766200,null],[1444398766300,null],[1444398766400,null],[1444398766500,null],[1444398766600,null],[1444398766700,null],[1444398766800,null],[1444398766900,null],[1444398767000,null],[1444398767100,null],[1444398767200,null],[1444398767300,null],[1444398767400,null],[1444398767500,null],[1444398767600,null],[1444398767700,null],[1444398767800,null],[1444398767900,null]]}]}]}

torkelo has pointed out (grafana/grafana#2930 (comment)) that the timestamps fro the two are different - for some weird reason, they're normal int epochs for mean(), but max() is giving some weird ISO 8601 timestamp as a string?

[victorhooi]

The below is predicated on this issue being triaged/confirmed

Quick question - is there any idea of how tricky this issue would be to fix?

Or any kind of workaround that is available now?

The reason I'm asking is because I'm scheduled to give an internal demo of InfluxDB next week...and it might be somewhat awkward/embarrassing for me if max() doesn't work, since it's one of the main functions we use...haha. (We need to show peaks in the data). So just wondering if there's something I can do to get it to work before then.

[beckettsean]

@victorhooi I don't see anything that indicates the timestamps are strings. What leads you to that conclusion?

Can you give some samples that return only a few dozen points, and perhaps using pretty=true in the query string parameters so that the output is easier to read? Side-scrolling a thousand points in single-line JSON is not a good way for me to debug things.

[victorhooi]

@beckettsean Sure, I can give a shorter example. Sorry about the scrolling, there doesn't seem to be a way in Github to make it wordwrap, so I've manually word-wrapped with fold.

When I use mean(), I get points like this:

[1444853214000,100.92]

But when I use max(), I see datapoints like this:

["2015-10-14T20:06:52Z",14.8]

The quotation marks around it lead me to think it's a string - and I'm not sure why it's not just an epoch like for mean(). Grafana of course won't graph the above.

Here is the complete dump for both:

Request URL for mean():

http://insight.mongodb-field.com:3000/api/datasources/proxy/1/query?epoch=ms&q=S
ELECT+mean(%22disk_util_percentage%22)+AS+%22disk_util_percentage%22+FROM+%22sar
_disk%22+WHERE+%22hostname%22+%3D+%27sessionmgr03%27+AND+%22device%22+%3D+%27dev
8-0%27+AND+time+%3E+1444853208s+and+time+%3C+1444853215s+GROUP+BY+time(100ms)

Response for mean():

{"results":[{"series":[{"name":"sar_disk","columns":["time","disk_util_percentag
e"],"values":[[1444853208000,null],[1444853208100,null],[1444853208200,null],[14
44853208300,null],[1444853208400,null],[1444853208500,null],[1444853208600,null]
,[1444853208700,null],[1444853208800,null],[1444853208900,null],[1444853209000,1
6.57],[1444853209100,null],[1444853209200,null],[1444853209300,null],[1444853209
400,null],[1444853209500,null],[1444853209600,null],[1444853209700,null],[144485
3209800,null],[1444853209900,null],[1444853210000,14.7],[1444853210100,null],[14
44853210200,null],[1444853210300,null],[1444853210400,null],[1444853210500,null]
,[1444853210600,null],[1444853210700,null],[1444853210800,null],[1444853210900,n
ull],[1444853211000,14],[1444853211100,null],[1444853211200,null],[1444853211300
,null],[1444853211400,null],[1444853211500,null],[1444853211600,null],[144485321
1700,null],[1444853211800,null],[1444853211900,null],[1444853212000,14.8],[14448
53212100,null],[1444853212200,null],[1444853212300,null],[1444853212400,null],[1
444853212500,null],[1444853212600,null],[1444853212700,null],[1444853212800,null
],[1444853212900,null],[1444853213000,99.1],[1444853213100,null],[1444853213200,
null],[1444853213300,null],[1444853213400,null],[1444853213500,null],[1444853213
600,null],[1444853213700,null],[1444853213800,null],[1444853213900,null],[144485
3214000,100.92],[1444853214100,null],[1444853214200,null],[1444853214300,null],[
1444853214400,null],[1444853214500,null],[1444853214600,null],[1444853214700,nul
l],[1444853214800,null],[1444853214900,null]]}]}]}

Request URL for max():

Request URL:http://insight.mongodb-field.com:3000/api/datasources/proxy/1/query?
epoch=ms&q=SELECT+max(%22disk_util_percentage%22)+AS+%22disk_util_percentage%22+
FROM+%22sar_disk%22+WHERE+%22hostname%22+%3D+%27sessionmgr03%27+AND+%22device%22
+%3D+%27dev8-0%27+AND+time+%3E+1444853208s+and+time+%3C+1444853215s+GROUP+BY+tim
e(100ms)

and the corresponding response:

{"results":[{"series":[{"name":"sar_disk","columns":["time","disk_util_percentag
e"],"values":[[1444853208000,null],[1444853208100,null],[1444853208200,null],[14
44853208300,null],[1444853208400,null],[1444853208500,null],[1444853208600,null]
,[1444853208700,null],[1444853208800,null],[1444853208900,null],["2015-10-14T20:
06:49Z",16.57],[1444853209100,null],[1444853209200,null],[1444853209300,null],[1
444853209400,null],[1444853209500,null],[1444853209600,null],[1444853209700,null
],[1444853209800,null],[1444853209900,null],["2015-10-14T20:06:50Z",14.7],[14448
53210100,null],[1444853210200,null],[1444853210300,null],[1444853210400,null],[1
444853210500,null],[1444853210600,null],[1444853210700,null],[1444853210800,null
],[1444853210900,null],["2015-10-14T20:06:51Z",14],[1444853211100,null],[1444853
211200,null],[1444853211300,null],[1444853211400,null],[1444853211500,null],[144
4853211600,null],[1444853211700,null],[1444853211800,null],[1444853211900,null],
["2015-10-14T20:06:52Z",14.8],[1444853212100,null],[1444853212200,null],[1444853
212300,null],[1444853212400,null],[1444853212500,null],[1444853212600,null],[144
4853212700,null],[1444853212800,null],[1444853212900,null],["2015-10-14T20:06:53
Z",99.1],[1444853213100,null],[1444853213200,null],[1444853213300,null],[1444853
213400,null],[1444853213500,null],[1444853213600,null],[1444853213700,null],[144
4853213800,null],[1444853213900,null],["2015-10-14T20:06:54Z",100.92],[144485321
4100,null],[1444853214200,null],[1444853214300,null],[1444853214400,null],[14448
53214500,null],[1444853214600,null],[1444853214700,null],[1444853214800,null],[1
444853214900,null]]}]}]}

[victorhooi]

@beckettsean I repeated the same query via the InfluxDB CLI shell, and also got incorrect results.

Here is the mean() query:

> SELECT mean("disk_util_percentage") AS "disk_util_percentage" FROM "sar_disk" WHERE "hostname" = 'sessionmgr03' AND "device" = 'dev8-0' AND time > 1444853208s and time < 1444853215s GROUP BY time(100ms)
name: sar_disk
--------------
time                    disk_util_percentage
1444853208000000000
1444853208100000000
1444853208200000000
1444853208300000000
1444853208400000000
1444853208500000000
1444853208600000000
1444853208700000000
1444853208800000000
1444853208900000000
1444853209000000000     16.57
1444853209100000000
1444853209200000000
1444853209300000000
1444853209400000000
1444853209500000000
1444853209600000000
1444853209700000000
1444853209800000000
1444853209900000000
1444853210000000000     14.7
1444853210100000000
1444853210200000000
1444853210300000000
1444853210400000000
1444853210500000000
1444853210600000000
1444853210700000000
1444853210800000000
1444853210900000000
1444853211000000000     14
1444853211100000000
1444853211200000000
1444853211300000000
1444853211400000000
1444853211500000000
1444853211600000000
1444853211700000000
1444853211800000000
1444853211900000000
1444853212000000000     14.8
1444853212100000000
1444853212200000000
1444853212300000000
1444853212400000000
1444853212500000000
1444853212600000000
1444853212700000000
1444853212800000000
1444853212900000000
1444853213000000000     99.1
1444853213100000000
1444853213200000000
1444853213300000000
1444853213400000000
1444853213500000000
1444853213600000000
1444853213700000000
1444853213800000000
1444853213900000000
1444853214000000000     100.92
1444853214100000000
1444853214200000000
1444853214300000000
1444853214400000000
1444853214500000000
1444853214600000000
1444853214700000000
1444853214800000000
1444853214900000000

Here is the max() query:

> SELECT max("disk_util_percentage") AS "disk_util_percentage" FROM "sar_disk" WHERE "hostname" = 'sessionmgr03' AND "device" = 'dev8-0' AND time > 1444853208s and time < 1444853215s GROUP BY time(100ms)
name: sar_disk
--------------
time                    disk_util_percentage
1444853208000000000
1444853208100000000
1444853208200000000
1444853208300000000
1444853208400000000
1444853208500000000
1444853208600000000
1444853208700000000
1444853208800000000
1444853208900000000
2015-10-14T20:06:49Z    16.57
1444853209100000000
1444853209200000000
1444853209300000000
1444853209400000000
1444853209500000000
1444853209600000000
1444853209700000000
1444853209800000000
1444853209900000000
2015-10-14T20:06:50Z    14.7
1444853210100000000
1444853210200000000
1444853210300000000
1444853210400000000
1444853210500000000
1444853210600000000
1444853210700000000
1444853210800000000
1444853210900000000
2015-10-14T20:06:51Z    14
1444853211100000000
1444853211200000000
1444853211300000000
1444853211400000000
1444853211500000000
1444853211600000000
1444853211700000000
1444853211800000000
1444853211900000000
2015-10-14T20:06:52Z    14.8
1444853212100000000
1444853212200000000
1444853212300000000
1444853212400000000
1444853212500000000
1444853212600000000
1444853212700000000
1444853212800000000
1444853212900000000
2015-10-14T20:06:53Z    99.1
1444853213100000000
1444853213200000000
1444853213300000000
1444853213400000000
1444853213500000000
1444853213600000000
1444853213700000000
1444853213800000000
1444853213900000000
2015-10-14T20:06:54Z    100.92
1444853214100000000
1444853214200000000
1444853214300000000
1444853214400000000
1444853214500000000
1444853214600000000
1444853214700000000
1444853214800000000
1444853214900000000

Notice how for max(), every time there is a result, the timestamp magically changes to some weird ISO8601 format, rather than epoch. The Influx shell doesn't really show you what is a string and what isn't (e.g. via quotes, say), but I'm guessing in this case those ISO8601 timestamps it's printing could actually be strings?

(I noticed your request for pretty=true - I'm assuming the above supplants that, but if you still need that, let me know).

[beckettsean]

Thanks, @victorhooi, with both new examples I can actually see the string timestamps. When parsing the one line return earlier those didn't pop out.

@corylanou @jwilder @DanielMorsing something wonky with timestamps and MAX in 0.9.5 nightly.

[victorhooi]

Cool, glad the new examples help =).

Let me know if there's anything you want me to test on this data-set, or any weird workarounds I'd be happy to guinea pig, haha.