superset-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [incubator-superset] shashisingh opened a new issue #10215: Explore option in viz shows "Empty Query" error
Date Wed, 01 Jul 2020 08:54:58 GMT

shashisingh opened a new issue #10215:
URL: https://github.com/apache/incubator-superset/issues/10215


   I built docker image from the code in master branch. I followed following steps to build
and start docker container.
   
   1) docker build -f superset:test -f Dockerfile . 
   2) docker run -d -p 10088:8080 -v /home/ubuntu/ssConfig:/app/pythonpath --health-cmd='curl
-f localhost:8080' --name superset_test superset:test 
   3) docker exec -it superset_test superset fab create-admin --username admin --firstname
Superset --lastname Admin --email admin@superset.com --password XXXXX 
   4) docker exec -it superset_test superset db upgrade 
   5) docker exec -it superset_test superset init
   
   /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.
   
   ### 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 ---
   Exception: Empty query?  
   ERROR:superset.viz:Empty query?  
   Traceback (most recent call last):  
   File "/usr/local/lib/python3.6/site-packages/superset/viz.py", line 463, in get_df_payload
 
   df = self.get_df(query_obj)  
   File "/usr/local/lib/python3.6/site-packages/superset/viz.py", line 240, in get_df  
   self.results = self.datasource.query(query_obj)  
   File "/usr/local/lib/python3.6/site-packages/superset/connectors/sqla/models.py", line
1128, in query  
   query_str_ext = self.get_query_str_extended(query_obj)  
   File "/usr/local/lib/python3.6/site-packages/superset/connectors/sqla/models.py", line
655, in get_query_str_extended  
   sqlaq = self.get_sqla_query(**query_obj)  
   File "/usr/local/lib/python3.6/site-packages/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!
   
   - [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.
   - [X] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   


----------------------------------------------------------------
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



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Mime
View raw message