You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "sandeepkokane (via GitHub)" <gi...@apache.org> on 2025/01/02 14:29:18 UTC
[I] Kylin SQLAlchemy connection issue [superset]
sandeepkokane opened a new issue, #31684:
URL: https://github.com/apache/superset/issues/31684
### Bug description
Facing issue using kylin
i am using latest version using pip install kylinpy as per docs [Kylin Connector](https://superset.apache.org/docs/configuration/databases#apache-kylin)
https://github.com/Kyligence/kylinpy/issues/56
### Screenshots/recordings
<img width="1287" alt="398908124-ccbe777d-d02d-49fd-8958-50a736502f7b" src="https://github.com/user-attachments/assets/b41bf98c-7e48-4605-81e9-860b239e4206" />
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
superset_app | 2025-01-02 13:24:49,928:DEBUG:superset.stats_logger:[stats_logger] (incr) test_connection_attempt
superset_app | 2025-01-02 13:24:49,942:DEBUG:superset.models.core:Database._get_sqla_engine(). Masked URL: kylin://ADMIN:XXXXXXXXXX@kylin_server/learn_kylin
superset_app | 2025-01-02 13:24:49,945:DEBUG:superset.stats_logger:[stats_logger] (incr) test_connection_error.DBAPIError
superset_app | 2025-01-02 13:24:49,947:DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error
superset_app | 2025-01-02 13:24:49,947:WARNING:superset.views.error_handling:SupersetErrorsException
superset_app | Traceback (most recent call last):
superset_app | File "/app/superset/commands/database/test_connection.py", line 170, in run
superset_app | raise DBAPIError(ex_str or None, None, None)
superset_app | sqlalchemy.exc.DBAPIError: (builtins.NoneType) None
superset_app | [SQL: KylinSQLCompiler._compose_select_body() takes 7 positional arguments but 9 were given]
superset_app | (Background on this error at: https://sqlalche.me/e/14/dbapi)
superset_app |
superset_app | The above exception was the direct cause of the following exception:
superset_app |
superset_app | Traceback (most recent call last):
superset_app | File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request
superset_app | rv = self.dispatch_request()
superset_app | File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request
superset_app | return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
superset_app | File "/usr/local/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 95, in wraps
superset_app | return f(self, *args, **kwargs)
superset_app | File "/app/superset/views/base_api.py", line 119, in wraps
superset_app | duration, response = time_function(f, self, *args, **kwargs)
superset_app | File "/app/superset/utils/core.py", line 1364, in time_function
superset_app | response = func(*args, **kwargs)
superset_app | File "/app/superset/utils/log.py", line 303, in wrapper
superset_app | value = f(*args, **kwargs)
superset_app | File "/app/superset/views/base_api.py", line 91, in wraps
superset_app | return f(self, *args, **kwargs)
superset_app | File "/app/superset/databases/api.py", line 1215, in test_connection
superset_app | TestConnectionDatabaseCommand(item).run()
superset_app | File "/app/superset/commands/database/test_connection.py", line 199, in run
superset_app | raise SupersetErrorsException(errors) from ex
superset_app | superset.exceptions.SupersetErrorsException: [SupersetError(message='(builtins.NoneType) None\n[SQL: KylinSQLCompiler._compose_select_body() takes 7 positional arguments but 9 were given]\n(Background on this error at: https://sqlalche.me/e/14/dbapi)', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'Apache Kylin', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})]
### Checklist
- [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
--
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Kylin SQLAlchemy connection issue [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #31684:
URL: https://github.com/apache/superset/issues/31684#issuecomment-2567862424
<!-- Greeting -->
Hey there, @sandeepkokane! I'm here to help you with your Kylin SQLAlchemy connection issue. Let's squash this bug together! 🐞
<!-- Answer -->
There is a similar closed issue regarding the inability to connect Apache Kylin to Superset, but no solution was found in the comments <sup>[[1]](https://github.com/apache/superset/issues/22532)</sup>.
In your case, the error seems to be related to the `KylinSQLCompiler._compose_select_body()` function receiving an incorrect number of arguments. This might be an issue with the `kylinpy` library or its integration with SQLAlchemy. You might want to check if there are any updates or patches available for `kylinpy` or if there are any known compatibility issues with the version of SQLAlchemy you are using.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/ab73640c-e5bd-433a-a96b-c6749145669b?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/ab73640c-e5bd-433a-a96b-c6749145669b?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/ab73640c-e5bd-433a-a96b-c6749145669b?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/ab73640c-e5bd-433a-a96b-c6749145669b?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/ab73640c-e5bd-433a-a96b-c6749145669b?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/ab73640c-e5bd-433a-a96b-c6749145669b?feedback_type=other)</sup>
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Kylin SQLAlchemy connection issue [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #31684:
URL: https://github.com/apache/superset/issues/31684#issuecomment-3887914300
Sorry to be that guy, but I'm closing this one out since this is a kylinpy library issue, not a Superset bug. The linked upstream issue (kylinpy#56) shows the problem is in the third-party driver... I hope they're able to help solve it, or another driver can be found/made.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Kylin SQLAlchemy connection issue [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #31684:
URL: https://github.com/apache/superset/issues/31684#issuecomment-2569824750
@zhaoyongjie might have some ideas here :D
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Kylin SQLAlchemy connection issue [superset]
Posted by "zhaoyongjie (via GitHub)" <gi...@apache.org>.
zhaoyongjie commented on issue #31684:
URL: https://github.com/apache/superset/issues/31684#issuecomment-2577283127
@sandeepkokane I have no idea for this issue, I have left Kyligence, which is Kylin maintaining company, long time. One thing, I suggestion that you might folk the kylinpy to you local and fix this issue by yourself.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Kylin SQLAlchemy connection issue [superset]
Posted by "sandeepkokane (via GitHub)" <gi...@apache.org>.
sandeepkokane commented on issue #31684:
URL: https://github.com/apache/superset/issues/31684#issuecomment-2631162968
can anyone else help me with this @rusackas @zhaoyongjie
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Kylin SQLAlchemy connection issue [superset]
Posted by "sandeepkokane (via GitHub)" <gi...@apache.org>.
sandeepkokane commented on issue #31684:
URL: https://github.com/apache/superset/issues/31684#issuecomment-2576781973
@zhaoyongjie can you help us out here :)
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Kylin SQLAlchemy connection issue [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #31684: Kylin SQLAlchemy connection issue
URL: https://github.com/apache/superset/issues/31684
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org