jessicachen888 commented on issue #3694: Foreign table cannot be loaded in SQL lab Tab URL: https://github.com/apache/incubator-superset/issues/3694#issuecomment-338120038 I have enabled celery. But when I run the same query, the following error appears: <img width="1273" alt="screen shot 2017-10-20 at 2 07 46 pm" src="https://user-images.githubusercontent.com/16902443/31808199-bbbd5dee-b537-11e7-9c7c-9288f2507895.png";> In config.py: `# On Redis from werkzeug.contrib.cache import RedisCache RESULTS_BACKEND = RedisCache( host='localhost', port=6379, key_prefix='superset_results') class CeleryConfig(object): BROKER_URL = 'redis://localhost:6379/0' CELERY_IMPORTS = ('superset.sql_lab', ) CELERY_RESULT_BACKEND = 'redis://localhost:6379/0' CELERY_ANNOTATIONS = {'tasks.add': {'rate_limit': '10/s'}} CELERYD_LOG_LEVEL = 'DEBUG' CELERYD_PREFETCH_MULTIPLIER = 1 CELERY_ACKS_LATE = True # CELERY_CONFIG = None CELERY_CONFIG = CeleryConfig SQL_CELERY_DB_FILE_PATH = os.path.join(DATA_DIR, 'celerydb.sqlite') SQL_CELERY_RESULTS_DB_FILE_PATH = os.path.join(DATA_DIR, 'celery_results.sqlite') ` Console: `JessicaChens-MacBook-Pro:incubator-superset-master Jessica$ superset worker -------------- [email protected] v3.1.25 (Cipater) ---- **** ----- --- * *** * -- Darwin-15.6.0-x86_64-i386-64bit -- * - **** --- - ** ---------- [config] - ** ---------- .> app: __main__:0x109310710 - ** ---------- .> transport: redis://localhost:6379/0 - ** ---------- .> results: redis://localhost:6379/0 - *** --- * --- .> concurrency: 32 (prefork) -- ******* ---- --- ***** ----- [queues] -------------- .> celery exchange=celery(direct) key=celery [2017-10-20 14:00:59,546: WARNING/MainProcess] [email protected] ready. 2017-10-20 14:15:37,576:INFO:root:[stats_logger] (incr) sql_json 2017-10-20 14:15:37,579:INFO:root:Parsing with sqlparse statement SELECT "Station" AS "Station", COUNT(*) AS count FROM public.event_warnings WHERE "Start_Time" >= '2016-01-01 00:00:00' AND "Start_Time" <= '2017-10-19 15:02:07' GROUP BY "Station" ORDER BY count DESC LIMIT 50000 2017-10-20 14:15:37,643:INFO:root:Triggering query_id: 40 2017-10-20 14:15:37,643:INFO:root:Running query on a Celery worker /Users/Jessica/anaconda/lib/python3.4/site-packages/sqlalchemy/sql/sqltypes.py:596: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage. 'storage.' % (dialect.name, dialect.driver)) 2017-10-20 14:15:37,719:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 14:15:37] "POST /superset/sql_json/ HTTP/1.1" 202 - `
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services
![https://user-images.githubusercontent.com/16902443/31808199-bbbd5dee-b537-11e7-9c7c-9288f2507895.png"](https://user-images.githubusercontent.com/16902443/31808199-bbbd5dee-b537-11e7-9c7c-9288f2507895.png"){kind=link}