Yanwenjingcn opened a new issue #19253:
URL: https://github.com/apache/superset/issues/19253
A clear and concise description of what the bug is.
#### How to reproduce the bug
1. config database
clickhouse://test:[email protected]:8888/default
2. go to sql_lab
3. run a clickhouse sql
error log:
2022-03-18
20:33:51,425:DEBUG:urllib3.connectionpool:http://180.97.87.196:8070 "POST
/?query_id=77d02bd7-28ad-418f-b23d-6ff575f5e55f&database=default HTTP/1.1" 200
None
2022-03-18 20:33:51,426:DEBUG:superset.stats_logger:[stats_logger] (timing)
sqllab.query.time_executing_query | 97.369140625
2022-03-18 20:33:51,428:ERROR:superset.sql_lab:Query 6: <class
'AttributeError'>
Traceback (most recent call last):
File "/Users/test/projects/PycharmProjects/superset/superset/sql_lab.py",
line 248, in execute_sql_statement
db_engine_spec.execute(cursor, sql, async_=True)
File
"/Users/test/projects/PycharmProjects/superset/superset/db_engine_specs/base.py",
line 1098, in execute
raise cls.get_dbapi_mapped_exception(ex)
File
"/Users/test/projects/PycharmProjects/superset/superset/db_engine_specs/base.py",
line 1096, in execute
cursor.execute(query)
File
"/Users/test/sandai/py3env/lib/python3.9/site-packages/clickhouse_sqlalchemy/drivers/http/connector.py",
line 117, in execute
self._process_response(response_gen)
File
"/Users/test/sandai/py3env/lib/python3.9/site-packages/clickhouse_sqlalchemy/drivers/http/connector.py",
line 216, in _process_response
self._columns = next(response, None)
File
"/Users/test/sandai/py3env/lib/python3.9/site-packages/clickhouse_sqlalchemy/drivers/http/transport.py",
line 136, in execute
convs = [_get_type(type_) for type_ in types]
File
"/Users/test/sandai/py3env/lib/python3.9/site-packages/clickhouse_sqlalchemy/drivers/http/transport.py",
line 136, in <listcomp>
convs = [_get_type(type_) for type_ in types]
File
"/Users/test/sandai/py3env/lib/python3.9/site-packages/clickhouse_sqlalchemy/drivers/http/transport.py",
line 81, in _get_type
if type_str.startswith('Decimal'):
AttributeError: 'NoneType' object has no attribute 'startswith'
2022-03-18 20:33:51,428:DEBUG:superset.sql_lab:Query 6: 'NoneType' object
has no attribute 'startswith'
2022-03-18
20:33:51,449:WARNING:superset.views.base:[SupersetError(message="clickhouse
error: 'NoneType' object has no attribute 'startswith'",
error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR:
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>,
extra={'engine_name': 'ClickHouse', 'issue_codes': [{'code': 1002, 'message':
'Issue 1002 - The database returned an unexpected error.'}]})]
### Environment
(please complete the following information):
- browser type and version: chrom
- superset version: 1.4.1
- python version: 3.9 3.8
- node.js version: 16.9.1
![Uploading image.png…]()
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ Y ] I have checked the superset logs for python stacktraces and included
it here as text if there are any.
- [ Y ] I have reproduced the issue with at least the latest released
version of superset.
- [ N ] 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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
