matrixone
matrixone copied to clipboard
Published
20 hours ago •
matrixorigin
matrixorigin
[Bug]: cant see cloumns when connecting to superset
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Environment
- Version or commit-id (e.g. v0.1.0 or 8b23a93):1.0.0-rc
- Hardware parameters:
- OS type:windows-wsl-ubuntu22.04
- Others:
Actual Behavior
when I use superset to connect to MO, superset can't show columns of a table.
The error statement is " select FROM test.users LIMIT 101", there is no * after select.
Expected Behavior
it's mysql.
Steps to Reproduce
set up superset,and add a database ->choose mysql-> connect to MO-> to superset/SQL lab ->choose a table
Additional information
https://superset.apache.org/docs/databases/mysql
superset also said there may be some problem with mysql connector mysqlclient , users can try to use mysql-connector-python, I tried but failed in some error.
Not a bug. This is a superset bug (it generated wrong sql) and MySQL bug (it should have rejected wrong sql).
That said, we may consider to add a mysql_compatibility_mode flag like select_allow_missing_star.
