You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/03/21 07:53:49 UTC
[GitHub] [incubator-superset] elukey commented on issue #7074: Filter-box
charts broken with 0.31 with Druid datasources
elukey commented on issue #7074: Filter-box charts broken with 0.31 with Druid datasources
URL: https://github.com/apache/incubator-superset/issues/7074#issuecomment-475138187
@mistercrunch I cherry picked the patch on top of the release--0.31 branch and now I get this:
```
Mar 21 07:43:10 analytics-tool1004 superset[27042]: 2019-03-21 07:43:10,755:DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): druid1003.eqiad.wmnet
Mar 21 07:43:10 analytics-tool1004 superset[27042]: 2019-03-21 07:43:10,759:DEBUG:urllib3.connectionpool:http://druid1003.eqiad.wmnet:8082 "GET /status HTTP/1.1" 200 None
Mar 21 07:43:10 analytics-tool1004 superset[27042]: 2019-03-21 07:43:10,760:INFO:root:Running two-phase topn query for dimension [project]
Mar 21 07:43:10 analytics-tool1004 superset[27042]: 2019-03-21 07:43:10,774:ERROR:root:HTTP Error 500: Internal Server Error
Mar 21 07:43:10 analytics-tool1004 superset[27042]: Druid Error: Internal Server Error
Mar 21 07:43:10 analytics-tool1004 superset[27042]: Query is: {
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "aggregations": [],
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "dataSource": "redacted",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "dimension": "redacted",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "filter": {
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "dimension": "redacted",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "type": "selector",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "value": "redacted"
Mar 21 07:43:10 analytics-tool1004 superset[27042]: },
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "granularity": "all",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "intervals": "2019-03-19T00:00:00+00:00/2019-03-20T00:00:00+00:00",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "metric": null,
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "postAggregations": [],
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "queryType": "topN",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "threshold": 1000
Mar 21 07:43:10 analytics-tool1004 superset[27042]: }
Mar 21 07:43:10 analytics-tool1004 superset[27042]: Traceback (most recent call last):
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/pydruid/client.py", line 488, in _post
Mar 21 07:43:10 analytics-tool1004 superset[27042]: res = urllib.request.urlopen(req)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/usr/lib/python3.7/urllib/request.py", line 222, in urlopen
Mar 21 07:43:10 analytics-tool1004 superset[27042]: return opener.open(url, data, timeout)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/usr/lib/python3.7/urllib/request.py", line 531, in open
Mar 21 07:43:10 analytics-tool1004 superset[27042]: response = meth(req, response)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/usr/lib/python3.7/urllib/request.py", line 641, in http_response
Mar 21 07:43:10 analytics-tool1004 superset[27042]: 'http', request, response, code, msg, hdrs)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/usr/lib/python3.7/urllib/request.py", line 569, in error
Mar 21 07:43:10 analytics-tool1004 superset[27042]: return self._call_chain(*args)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/usr/lib/python3.7/urllib/request.py", line 503, in _call_chain
Mar 21 07:43:10 analytics-tool1004 superset[27042]: result = func(*args)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/usr/lib/python3.7/urllib/request.py", line 649, in http_error_default
Mar 21 07:43:10 analytics-tool1004 superset[27042]: raise HTTPError(req.full_url, code, msg, hdrs, fp)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: urllib.error.HTTPError: HTTP Error 500: Internal Server Error
Mar 21 07:43:10 analytics-tool1004 superset[27042]: During handling of the above exception, another exception occurred:
Mar 21 07:43:10 analytics-tool1004 superset[27042]: Traceback (most recent call last):
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/superset/viz.py", line 410, in get_df_payload
Mar 21 07:43:10 analytics-tool1004 superset[27042]: df = self.get_df(query_obj)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/superset/viz.py", line 213, in get_df
Mar 21 07:43:10 analytics-tool1004 superset[27042]: self.results = self.datasource.query(query_obj)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/superset/connectors/druid/models.py", line 1286, in query
Mar 21 07:43:10 analytics-tool1004 superset[27042]: client=client, query_obj=query_obj, phase=2)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/superset/connectors/druid/models.py", line 883, in get_query_str
Mar 21 07:43:10 analytics-tool1004 superset[27042]: return self.run_query(client=client, phase=phase, **query_obj)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/superset/connectors/druid/models.py", line 1158, in run_query
Mar 21 07:43:10 analytics-tool1004 superset[27042]: client.topn(**pre_qry)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/pydruid/client.py", line 123, in topn
Mar 21 07:43:10 analytics-tool1004 superset[27042]: return self._post(query)
Mar 21 07:43:10 analytics-tool1004 superset[27042]: File "/srv/deployment/analytics/superset/venv/lib/python3.7/site-packages/pydruid/client.py", line 508, in _post
Mar 21 07:43:10 analytics-tool1004 superset[27042]: separators=(',', ': '))))
Mar 21 07:43:10 analytics-tool1004 superset[27042]: OSError: HTTP Error 500: Internal Server Error
Mar 21 07:43:10 analytics-tool1004 superset[27042]: Druid Error: Internal Server Error
Mar 21 07:43:10 analytics-tool1004 superset[27042]: Query is: {
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "aggregations": [],
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "dataSource": "redacted",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "dimension": "redacted",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "filter": {
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "dimension": "redacted",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "type": "selector",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "value": "redacted"
Mar 21 07:43:10 analytics-tool1004 superset[27042]: },
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "granularity": "all",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "intervals": "2019-03-19T00:00:00+00:00/2019-03-20T00:00:00+00:00",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "metric": null,
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "postAggregations": [],
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "queryType": "topN",
Mar 21 07:43:10 analytics-tool1004 superset[27042]: "threshold": 1000
Mar 21 07:43:10 analytics-tool1004 superset[27042]: }
```
I have redacted some details of the Druid query that I thought were not needed, but if something is missing I'll provide it. It seems now that Druid returns 500, and that the `aggregations` parameter is still empty (while we have configured metrics in the Druid datasources panel).
I am going to check how to switch from the Druid connector to pydruid's sql alchemy, is it something present in the docs?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org