jessicachen888 commented on issue #3694: Foreign table cannot be loaded in SQL lab Tab URL: https://github.com/apache/incubator-superset/issues/3694#issuecomment-338135803 I have set all the celery config but when I ran the same query in the SQL Lab, the following error message appears: ![image](https://user-images.githubusercontent.com/16902443/31810818-bf5e027c-b542-11e7-8097-4db31d2c7bca.png) But still, in the slices section, the public.event_warnings can be found and do all kinds of visualization. ![image](https://user-images.githubusercontent.com/16902443/31810901-20ccfd24-b543-11e7-8c80-812cfa11cf1f.png) The console log appears the following: 2017-10-20 15:54:05,334:INFO:root:[stats_logger] (incr) sql_json 2017-10-20 15:54:05,338: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 16:18:08' GROUP BY "Station" ORDER BY count DESC LIMIT 50000 2017-10-20 15:54:05,421:INFO:root:Triggering query_id: 51 2017-10-20 15:54:05,421:INFO:root:Running query on a Celery worker 2017-10-20 15:54:05,444:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:05] "POST /superset/sql_json/ HTTP/1.1" 202 - 2017-10-20 15:54:05,617:INFO:root:[stats_logger] (incr) queries 2017-10-20 15:54:05,632:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:05] "GET /superset/queries/1508485922891.331 HTTP/1.1" 200 - 2017-10-20 15:54:07,619:INFO:root:[stats_logger] (incr) queries 2017-10-20 15:54:07,631:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:07] "GET /superset/queries/1508486040528.338 HTTP/1.1" 200 - 2017-10-20 15:54:09,621:INFO:root:[stats_logger] (incr) queries 2017-10-20 15:54:09,632:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:09] "GET /superset/queries/1508486040528.338 HTTP/1.1" 200 - 2017-10-20 15:54:11,620:INFO:root:[stats_logger] (incr) queries 2017-10-20 15:54:11,632:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:11] "GET /superset/queries/1508486040528.338 HTTP/1.1" 200 - 2017-10-20 15:54:13,616:INFO:root:[stats_logger] (incr) queries 2017-10-20 15:54:13,631:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:13] "GET /superset/queries/1508486040528.338 HTTP/1.1" 200 - 2017-10-20 15:54:15,617:INFO:root:[stats_logger] (incr) queries 2017-10-20 15:54:15,630:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:15] "GET /superset/queries/1508486040528.338 HTTP/1.1" 200 - 2017-10-20 15:54:17,974:INFO:root:[stats_logger] (incr) queries 2017-10-20 15:54:17,984:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:17] "GET /superset/queries/1508486040528.338 HTTP/1.1" 200 - 2017-10-20 15:54:18,081:INFO:root:[stats_logger] (incr) results 2017-10-20 15:54:18,081:DEBUG:botocore.hooks:Event before-parameter-build.s3.HeadObject: calling handler <function sse_md5 at 0x105dd90d0> 2017-10-20 15:54:18,081:DEBUG:botocore.hooks:Event before-parameter-build.s3.HeadObject: calling handler <function validate_bucket_name at 0x105dd9048> 2017-10-20 15:54:18,081:DEBUG:botocore.hooks:Event before-parameter-build.s3.HeadObject: calling handler <bound method S3RegionRedirector.redirect_from_cache of <botocore.utils.S3RegionRedirector object at 0x10857d748>> 2017-10-20 15:54:18,081:DEBUG:botocore.hooks:Event before-parameter-build.s3.HeadObject: calling handler <function generate_idempotent_uuid at 0x105dd4bf8> 2017-10-20 15:54:18,081:DEBUG:botocore.hooks:Event before-call.s3.HeadObject: calling handler <function add_expect_header at 0x105dd9510> 2017-10-20 15:54:18,081:DEBUG:botocore.hooks:Event before-call.s3.HeadObject: calling handler <bound method S3RegionRedirector.set_request_url of <botocore.utils.S3RegionRedirector object at 0x10857d748>> 2017-10-20 15:54:18,082:DEBUG:botocore.endpoint:Making request for OperationModel(name=HeadObject) (verify_ssl=True) with params: {'headers': {'User-Agent': 'Boto3/1.4.4 Python/3.4.3 Darwin/15.6.0 Botocore/1.5.95'}, 'method': 'HEAD', 'query_string': {}, 'url': 'https://s3.amazonaws.com/foobar-superset/sql_lab_resulted66a13f-1b5b-4e51-a982-62990e1e2b3b', 'body': b'', 'context': {'client_region': 'us-east-1', 'client_config': <botocore.config.Config object at 0x1084d8cf8>, 'signing': {'bucket': 'foobar-superset'}, 'has_streaming_input': False, 'auth_type': None}, 'url_path': '/foobar-superset/sql_lab_resulted66a13f-1b5b-4e51-a982-62990e1e2b3b'} 2017-10-20 15:54:18,082:DEBUG:botocore.hooks:Event request-created.s3.HeadObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x1084d8828>> 2017-10-20 15:54:18,082:DEBUG:botocore.hooks:Event choose-signer.s3.HeadObject: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x105f779e8>> 2017-10-20 15:54:18,082:DEBUG:botocore.hooks:Event choose-signer.s3.HeadObject: calling handler <function set_operation_specific_signer at 0x105dd4ae8> 2017-10-20 15:54:18,082:DEBUG:botocore.hooks:Event before-sign.s3.HeadObject: calling handler <function fix_s3_host at 0x105cb6730> 2017-10-20 15:54:18,089:INFO:werkzeug:127.0.0.1 - - [20/Oct/2017 15:54:18] "GET /superset/results/ed66a13f-1b5b-4e51-a982-62990e1e2b3b/ HTTP/1.1" 410 -
---------------------------------------------------------------- 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