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

Druid Slice is broken after upgrade superset from 0.18 to 1.2 #16456

Closed
Asura1977 opened this issue Aug 26, 2021 · 1 comment
Closed

Druid Slice is broken after upgrade superset from 0.18 to 1.2 #16456

Asura1977 opened this issue Aug 26, 2021 · 1 comment
Labels
question & help wanted Use Github discussions instead

Comments

@Asura1977
Copy link

Asura1977 commented Aug 26, 2021

Make sure these boxes are checked before submitting your issue - thank you!

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

We have a superset site using version 0.18 now. When we try to upgrade it to version 1.2, we found the slice based on Druid cannot work as expected.

The slice in version 0.18 looks like:
image
The slice upgrade to 1.2 looks like:
image

The metrics are missing and dimensions are not grouped by.

The setting of the slice is:
image
The data source setting is:
image

The query in new version is:
{ "queryType": "scan", "dataSource": "campaign_realtime_ectr_prod_v1", "granularity": "all", "intervals": "2021-08-06T00:00:00+00:00/2021-08-26T03:44:27+00:00", "filter": { "type": "regex", "dimension": "campaign_name", "pattern": "Live Pass" }, "columns": [ "campaign_id", "campaign_name", "__time" ], "metrics": [], "limit": 50000 }
It seems that the columns fields have a "__time" column and no options in metrics.

Thanks.

@Asura1977 Asura1977 added the #bug Bug report label Aug 26, 2021
@villebro
Copy link
Member

@Asura1977 the native Druid connector is in the process of being deprecated (see #6032 for details). If you want to continue using Druid on a fresh version of Superset I would encourage you to switch to the SqlAlchemy connector for Druid which is actively supported in Superset.

@junlincc junlincc added question & help wanted Use Github discussions instead and removed #bug Bug report labels Aug 26, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question & help wanted Use Github discussions instead
Projects
None yet
Development

No branches or pull requests

3 participants