Incubator-superset: Cannot filter based on druid lookup dimension

[stelios313]

I am trying to filter with bound > operator on a druid lookup dimension, and it does not work.

Expected results

Expected to work same as any other dimension i am filtering.

Actual results

How to reproduce the bug

• Add a druid datasource to superset
• Publish a lookup to the druid cluster
• Define in the datasource a custom dimension based on a lookup such as:

{
    "type": "extraction",
    "dimension": "publisher_id",
    "outputName": "publisher_first_revenue_month",
    "outputType": "LONG",
    "extractionFn": {
        "type": "registeredLookup",
        "optimize": true,
        "lookup": "publisher_first_revenue_month"
    }
}    

In the explore screen, generate a query using the custom dimension as the filter criteria with a bound operator (>, < , >=, <=). And the error from pydruid will show up.

Environment

• superset version: 0.35.0
• python version: 3.6

Checklist

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 there are any.
• [x] 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.

[issue-label-bot[bot]]

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.67. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[mistercrunch]

Pretty sure that's been fixed in master at the bug bash. Here https://github.com/apache/incubator-superset/pull/8714

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.