Some questions about query?

I have 3 questions about Druid query API:

  1. Can we order the properties at event of a query result?

for example:

“event”: {
“Sum Custom Tag 0 Time”: 619570.625,
“Site”: “UK”,
“Data number”: 112,
“Pages”: “PllMPcsrrej_oe_brx_tpGoeAtmaRemxPPaeayaut_R__Ar”,
“Avg Custom Tag 0 Time”: 5531.880580357143
}

``

Can we order the event by property name as follow?

“event”: {
“Avg Custom Tag 0 Time”: 5531.880580357143,
“Data number”: 112,
“Pages”: “PllMPcsrrej_oe_brx_tpGoeAtmaRemxPPaeayaut_R__Ar”,

  "Site": "UK",
  "Sum Custom Tag 0 Time": 619570.625
}

``

  1. Can we sort group by query results by quantile value of quantile post-aggregator?

  2. can we format a post-aggregator double value with 2 decimal points?

Inline.

I have 3 questions about Druid query API:

  1. Can we order the properties at event of a query result?

for example:

“event”: {
“Sum Custom Tag 0 Time”: 619570.625,
“Site”: “UK”,
“Data number”: 112,
“Pages”: “PllMPcsrrej_oe_brx_tpGoeAtmaRemxPPaeayaut_R__Ar”,
“Avg Custom Tag 0 Time”: 5531.880580357143
}

``

Can we order the event by property name as follow?

“event”: {
“Avg Custom Tag 0 Time”: 5531.880580357143,
“Data number”: 112,
“Pages”: “PllMPcsrrej_oe_brx_tpGoeAtmaRemxPPaeayaut_R__Ar”,

  "Site": "UK",
  "Sum Custom Tag 0 Time": 619570.625
}

``

Currently this is not possible but it should be a small code change to make it possible.

  1. Can we sort group by query results by quantile value of quantile post-aggregator?

You should be able to sort results on a post aggregator. If this doesn’t work, it is a bug. Quantile support in Druid: http://druid.io/docs/latest/development/approximate-histograms.html

  1. can we format a post-aggregator double value with 2 decimal points?

This requires a small amount of code to be written and contributed to Druid. You can also do this on the client side.