anilkumar000 opened a new issue, #21122:
URL: https://github.com/apache/superset/issues/21122
Hello, im trying to use "SQLLAB_BACKEND_PERSISTENCE": True for caching
sqllab_query_results. But the feature is failing to return response of queried
result back to superset and throwing below Error logs. Could please correct and
help me on this feature.
**Superset version -** v2.0
**Superset instance -** On Kubernetes container using Helm
**Feature Flag configuration** in superset_config.py -
```
FEATURE_FLAGS = {
"DASHBOARD_NATIVE_FILTERS": True,
"DASHBOARD_CROSS_FILTERS": True,
"ENABLE_TEMPLATE_PROCESSING": True,
"ENABLE_EXPLORE_DRAG_AND_DROP": True,
"DASHBOARD_RBAC": True,
"VERSIONED_EXPORT": True,
"GENERIC_CHART_AXES": True,
"SQLLAB_BACKEND_PERSISTENCE": True
}
```
**Expected :** to get queried result in sqllab tab.
**Actual Error Logs :**
```
[SupersetError(message="'dict' object has no attribute 'set'",
error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR:
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>,
extra={'engine_name': 'Trino', 'issue_codes': [{'code': 1002, 'message': 'Issue
1002 - The database returned an unexpected error.'}]})]
Traceback (most recent call last):
File "/app/superset/views/base.py", line 207, in wraps
return f(self, *args, **kwargs)
File "/app/superset/utils/log.py", line 245, in wrapper
value = f(*args, **kwargs)
File "/app/superset/views/core.py", line 2395, in sql_json
command_result: CommandResult = command.run()
File "/app/superset/sqllab/command.py", line 114, in run
raise ex
File "/app/superset/sqllab/command.py", line 98, in run
status = self._run_sql_json_exec_from_scratch()
File "/app/superset/sqllab/command.py", line 151, in
_run_sql_json_exec_from_scratch
raise ex
File "/app/superset/sqllab/command.py", line 146, in
_run_sql_json_exec_from_scratch
return self._sql_json_executor.execute(
File "/app/superset/sqllab/sql_json_executer.py", line 111, in execute
raise SupersetErrorsException(
superset.exceptions.SupersetErrorsException: [SupersetError(message="'dict'
object has no attribute 'set'",
error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR:
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>,
extra={'engine_name': 'Trino', 'issue_codes': [{'code': 1002, 'message': 'Issue
1002 - The database returned an unexpected error.'}]})]
2022-08-18
09:12:41,251:WARNING:superset.views.base:[SupersetError(message="'dict' object
has no attribute 'set'", error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR:
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>,
extra={'engine_name': 'Trino', 'issue_codes': [{'code': 1002, 'message': 'Issue
1002 - The database returned an unexpected error.'}]})]
```
--
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]
