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
Explore option in viz shows "Empty Query" error #10215
Comments
Issue-Label Bot is automatically applying the label Links: app homepage, dashboard and code for this bot. |
Hi @shashanksingh, Thank you for taking the time to report this issue. I'm able to reproduce. Investigating |
@dpgaspar thanks for that man, but I think the reporter, @shashisingh is a different human being :D |
ups! sorry for that @shashanksingh |
I think this was introduced here: #10113, still investigating Seems like that when using explore from SQLLab we have this issue, but if we explore from the datasets list view using the created virtual dataset the charts render correctly from SQLLab: form_data:
from datasets list:
missing the "metrics":["count"] on the first request @ktmud can you take a look? |
Fixed by apache-superset/superset-ui#659 and #10219. Sorry for the inconvenience. |
I built docker image from the code in master branch. I followed following steps to build and start docker container.
/home/ubuntu/ssConfig -> contains superset_config.py where I set DRUID_IS_ACTIVE to True and SQLALCHEMY_DATABASE_URI pointing to a postgres database.
After this I created a database that is setup to query druid broker. I input a group by query similar to the following -> SELECT eventId , eventType, COUNT(*) as counter FROM "druid_datasource_name" GROUP BY("eventId","eventType"); I can see the results in SQLTab. I clicked on "Explore" option to open visualization window.
Additional Tests =>
I tried the query SELECT country_code ,COUNT(*) as entries from wb_health_population GROUP BY("country_code"); -> included in examples. And then clicked on "Explore" in "Results" tab. I have attached a screenshot.
Expected results
I should see a table displayed in the visualization area.
Actual results
I see an error that says "Empty query?".
Stack Trace is shown below ---
Traceback (most recent call last):
File "/app/superset/viz.py", line 463, in get_df_payload
df = self.get_df(query_obj)
File "/app/superset/viz.py", line 240, in get_df
self.results = self.datasource.query(query_obj)
File "/app/superset/connectors/sqla/models.py", line 1128, in query
query_str_ext = self.get_query_str_extended(query_obj)
File "/app/superset/connectors/sqla/models.py", line 655, in get_query_str_extended
sqlaq = self.get_sqla_query(**query_obj)
File "/app/superset/connectors/sqla/models.py", line 798, in get_sqla_query
raise Exception(_("Empty query?"))
Exception: Empty query?
Environment
Environment
• superset version: 0.999.0dev
• python version: 3.6.10
• node.js version: 13.6.0
• npm version: 6.13.4
Checklist
Make sure these boxes are checked before submitting your issue - thank you!
The text was updated successfully, but these errors were encountered: