Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]druid Approximate Histogram post-aggregations #2344

Closed
3 tasks done
fangyeqing opened this issue Mar 6, 2017 · 1 comment
Closed
3 tasks done

[Bug]druid Approximate Histogram post-aggregations #2344

fangyeqing opened this issue Mar 6, 2017 · 1 comment

Comments

@fangyeqing
Copy link

fangyeqing commented Mar 6, 2017

@bkyryliuk When I use this feature, I found a bug :
Support more druid postaggregations#2235

  • I have checked the superset logs for python stacktraces and included it here as text if any
  • I have reproduced the issue with at least the latest released version of superset
  • I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

source code version: 9d8d421

Steps to reproduce

Step 1. At Druid's ingestion time

"approxHistogramFold" aggregator is created as follows:

{
          "type" : "approxHistogramFold",
          "name" : "rsp_time",
          "fieldName" : "rsp_time",
          "resolution" : 500,
          "numBuckets" : 500,
          "lowerLimit" : 0.0
}

Step 2. Create Druid Metrics in Superset

Metrics NO1: "approxHistogramFold" aggregator
metrics1

Metrics NO.2: post-aggregators
metrics2

Step 3.Query in Superset

When choose both post-agg response_0.99 and approxHistogram-aggregator rsp_time, you can get the right result
resp1

But, when only choose post-agg response_0.99,

HTTP Error 500: Server Error Druid Error: None Query is: { "aggregations": [], "intervals": "2017-02-27T18:40:21+00:00/2017-03-06T18:40:21+00:00", "dataSource": "adtime_stat", "granularity": "all", "postAggregations": [ { "fieldName": "rsp_time", "type": "quantile", "name": "response_0.99", "probability": 0.99 } ], "queryType": "timeseries" }

Because to query for results, an "approxHistogramFold" aggregator must be included in the query,we can see the official doc for details

Bug fix

#2345

Others

When I create a "quantiles"post-agg
quan2

Then I send a query request, and I get Object object, it's hard to read
quan0

I think the display of "quantiles"post-agg can be more readable
resp1

PR

#2346

@mistercrunch
Copy link
Member

Notice: this issue has been closed because it has been inactive for 413 days. Feel free to comment and request for this issue to be reopened.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants