sivasakthipt commented on issue #11202: URL: https://github.com/apache/incubator-superset/issues/11202#issuecomment-705953779
I am getting the following error in superset while selecting the sample schema, ``` DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): localhost:9200 INFO:werkzeug:223.228.146.132 - - [09/Oct/2020 03:53:13] "GET /superset/extra_table_metadata/1/sample/default/ HTTP/1.1" 200 - DEBUG:urllib3.connectionpool:http://localhost:9200 "POST /sample/_search?size=1 HTTP/1.1" 200 277 INFO:elasticsearch:POST http://localhost:9200/sample/_search?size=1 [status:200 request:0.006s] DEBUG:elasticsearch:> None DEBUG:elasticsearch:< {"took":1,"timed_out":false,"_shards":{"total":1,"successful":1,"skipped":0,"failed":0},"hits":{"total":{"value":1,"relation":"eq"},"max_score":1.0,"hits":[{"_index":"sample","_type":"_doc","_id":"1","_score":1.0,"_source":{"name":6,"age":"10","email":"[email protected]"}}]}} DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): localhost:9200 DEBUG:urllib3.connectionpool:http://localhost:9200 "POST /_sql/ HTTP/1.1" 200 210 INFO:elasticsearch:POST http://localhost:9200/_sql/ [status:200 request:0.004s] DEBUG:elasticsearch:> {"query":"SHOW COLUMNS FROM \"sample\""} DEBUG:elasticsearch:< {"columns":[{"name":"column","type":"keyword"},{"name":"type","type":"keyword"},{"name":"mapping","type":"keyword"}],"rows":[["age","INTEGER","integer"],["email","VARCHAR","keyword"],["name","TINYINT","byte"]]} WARNING:es.basesqlalchemy:Unknown type found byte reverting to string INFO:werkzeug:223.228.146.132 - - [09/Oct/2020 03:53:13] "GET /api/v1/database/1/table/sample/default/ HTTP/1.1" 200 - Triggering query_id: 31 INFO:superset.views.core:Triggering query_id: 31 timeout can't be used in the current context WARNING:superset.utils.core:timeout can't be used in the current context signal only works in main thread Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/superset/utils/core.py", line 624, in __enter__ signal.signal(signal.SIGALRM, self.handle_timeout) File "/usr/lib64/python3.6/signal.py", line 47, in signal handler = _signal.signal(_enum_to_int(signalnum), _enum_to_int(handler)) ValueError: signal only works in main thread ERROR:superset.utils.core:signal only works in main thread Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/superset/utils/core.py", line 624, in __enter__ signal.signal(signal.SIGALRM, self.handle_timeout) File "/usr/lib64/python3.6/signal.py", line 47, in signal handler = _signal.signal(_enum_to_int(signalnum), _enum_to_int(handler)) ValueError: signal only works in main thread SQLite Database support for metadata databases will be removed in a future version of Superset. WARNING:superset.sql_lab:SQLite Database support for metadata databases will be removed in a future version of Superset. Query 31: Executing 1 statement(s) INFO:superset.sql_lab:Query 31: Executing 1 statement(s) Query 31: Set query to 'running' INFO:superset.sql_lab:Query 31: Set query to 'running' Query 31: Running statement 1 out of 1 INFO:superset.sql_lab:Query 31: Running statement 1 out of 1 DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): localhost:9200 DEBUG:urllib3.connectionpool:http://localhost:9200 "POST /_sql/ HTTP/1.1" 200 146 INFO:elasticsearch:POST http://localhost:9200/_sql/ [status:200 request:0.011s] DEBUG:elasticsearch:> {"query":"SELECT age,\n email,\n name\nFROM sample\nLIMIT 100"} DEBUG:elasticsearch:< {"columns":[{"name":"age","type":"integer"},{"name":"email","type":"keyword"},{"name":"name","type":"byte"}],"rows":[[10,"[email protected]",6]]} Query 31: <class 'KeyError'> ERROR:superset.sql_lab:Query 31: <class 'KeyError'> INFO:werkzeug:223.228.146.132 - - [09/Oct/2020 03:53:13] "POST /superset/sql_json/ HTTP/1.1" 500 - ``` ---------------------------------------------------------------- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
