myarnav commented on issue #4612: In the “SQL Lab”, the “Results” section shows 
“Pending” constantly
URL: 
https://github.com/apache/incubator-superset/issues/4612#issuecomment-380741990
 
 
   ok, I followed following steps and was able to setup redis. I had to install 
 the following packages to fix the issue
   1. Install gevent
   2. install mysql package 
   3. save the file in "/venv/local/lib/python2.7/site-packages/" - This is my 
pythonpath
   
   My configuration file looks like this
   ```
   import os
   from werkzeug.contrib.cache import RedisCache
   ROW_LIMIT = 5000
   SUPERSET_WORKERS = 4
   # You will be serving site on port 8000 from gunicorn which sits in front of 
flask, and then send to nginx
   SUPERSET_WEBSERVER_PORT = 8000
   SECRET_KEY = '\2\mthisismyscretkey\1\2\a\b\y\h'
   SQLALCHEMY_DATABASE_URI = 'sqlite:////home/ubuntu/.superset/superset.db'
   # Flask-WTF flag for CSRF
   CSRF_ENABLED = True
   # Set this API key to enable Mapbox visualizations
   MAPBOX_API_KEY = ''
   CACHE_DEFAULT_TIMEOUT = 86400
   CACHE_CONFIG = {
   'CACHE_TYPE': 'redis',
   'CACHE_DEFAULT_TIMEOUT': 86400,
   'CACHE_KEY_PREFIX': 'superset_',
   'CACHE_REDIS_HOST': 'localhost',
   'CACHE_REDIS_PORT': 6379,
   'CACHE_REDIS_DB': 1,
   'CACHE_REDIS_URL': 'redis://localhost:6379/1'}
   class CeleryConfig(object):
       BROKER_URL = 'redis://localhost:6379/1'
       CELERY_IMPORTS = ('superset.sql_lab', )
       CELERY_RESULT_BACKEND = 'redis://localhost:6379/1'
       CELERY_ANNOTATIONS = {'tasks.add': {'rate_limit': '10/s'}}
       CELERYD_LOG_LEVEL = 'DEBUG'
       CELERYD_PREFETCH_MULTIPLIER = 1
       CELERY_ACKS_LATE = True
   
   CELERY_CONFIG = CeleryConfig
   RESULTS_BACKEND = RedisCache(
       host='localhost',
       port=6379,
       key_prefix='superset_results'
   )
   
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to